change directory

  1. A

    Changing Directory back to original file

    Hi I have a file where I run some code and it allows me to insert a picture into the file on another tab. Once I do this I then run a second piece of code to PDF the file. however I want the PDF to stay in the same folder as the Excel File but what is happening now is its saving it to where I...
  2. C

    Need Help! Create New folder and save file in the new folder

    Hi All! New to VBA. Struggling with this. Would appreciate any help I want to, open a workbook save it in a new directory from created from cell h5 value F:\Job Packets"H5"\my new file name (which will be value from h5 as well followed by the word "lot" I have macro to save work book as the...
  3. P

    changing file path

    Hi, I need to extract data from files that are currently located down this path c:\Users\Owner\Desktop\R2D2\Data\NS25465\labor.xls How do I write code to find and open "labor.xls"? Can I use ChDir Left(ThisWorkbook.Path, InStr(1, ThisWorkbook.Path, ":")) ChDir...

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
Back
Top