filesinpath

  1. D

    Compile Error: Method or data member not found

    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...
  2. D

    Bypass Apple's Excel 2016 Sandbox Requirements

    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...
  3. D

    MAC Excel 2011 VBA File Name Limit of DIR function

    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...
  4. D

    VBA Batch Transfer Data of Old File Template to New File Template

    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...
  5. D

    VBA To Add Values to a Current Range

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top