pathname

Hi I am trying to test this on a folder containing 5 files, it opens all files but it only completes the action on 1 file then seems to freeze excel completely. I am new to the world of Macros and lifted the code from a website, so I am hoping this will be a good way to get an answer. Have I...

<tbody> Hi I am trying to copy a folder from and paste it into another folder which I have created on my desktop. The creation of the folder went succesfully but copying doesn't seem to work for some reason. It keep getting the error that the filename cannot be found although the pathname is...

Below is an extract of some code that fails because there are spaces in the pathname and the filename (e.g. "AR timesheet.xlsm". I have tried various options such as Chr(34), """"" and %20 but can't seem to get it to work. If I take out the spaces in the path and filename then the code works...

Hi, I have the following code but I got the error message saying that "Run-Time Error 424, Object Required". Wonder if someone could point out what the cause is, and how to rectify? Sub callCFP() pathName = "C:\Code\subFolder_1" Set fso = CreateObject("Scripting.FileSystemObject")...

I am new to VBA. The code below works, except for two issues I cannot solve. (1) When I run macro, I have to manually select the path to the file (ProviderCounts) in vlookup. If I try Workbooks.Open; then the file opens, but stays on that file and resets the macro to the beginning. (2) Within...

Hi There, I was looking around but could not find a direct answer and I am unsure of the print functions and parameters in VBA. What I would like to do is print a range of cells, say A5:E40, to a pdf using Adope PDF. I would also like the name of the created pdf file to be that of a certain...

I come here to ask for some help from my VBA expert's friends. I have about 150 .xls files where I have the measurements of the buildings where I've worked in and I need the data of these 150 workbooks in a single main file where I have monthly measurements with a general report and charts...

Hi all, I have quite a simple question for you, having just migrated to a mac and Office 2011. Of course the first thing I want to try out is whether the macros from my PC still work ... I have a Cell on a sheet, that contains the full pathname of the file I want to load. My macro uses this...