filesinpath

I'm getting the "Compile Error: Method or data member not found" error on the following line of code on my co-workers computer but I have no issues on my computer. We are running the same version of Excel (2016 on a MAC), any idea what the issue could be? Error on mybook.Close...

I have the following macro which increases/decreases material pricing from one "Master Key" to multiple files (pricing templates) in an "/Update/" folder. This macro worked fine for Excel 2011 but when we moved to Excel 2016 it is asking permission to open a folder and I can't select the folder...

I'm running into an issue where I can't use VBA to open a file to inject new data unless the filename is shorter than I believe 28 characters. Is there a workaround for this? Below is my code for reference. Sub FactorChange_Price() Dim MyPath As String, FilesInPath As String Dim...

Using Mac Excel 2011 btw which is why you see a ":" instead of a "/". I'm trying to take the data from a batch of files in a subfolder called "Old" which is located in the directory below my template file. Copy and paste the data from those files into my active workbook which is a new template...

I have code that is supposed to add price changes to current price values for all workbooks in a certain file location but I am having trouble getting it to work. Sorry, am a VBA noob. Here is the code: The BOLDED is the line that is giving me issues. Sub FactorChange_Price() Dim MyPath...