current directory

  1. B

    referring to current folder

    hi, can you please help me to understand this issue and correct it? i´ve addapted code to play sounds and it works fine if the mp3 file is placed at C:\Users\Bruno Andrade\Music\ Sub M_02SomNiv2() Dim play As String play = """C:\Users\Bruno Andrade\Music\som02-Niv2.mp3""" Shell...
  2. L

    VBA macro does not consistently point to the current directory

    I have a macro written in Excel 2007 that looks in the same directory as my open workbook and copies the worksheets from all of the other files in the same directory. At least, that's what it is supposed to do. The problem I am having is that when I first open my .xlsm worksheet and run that...
  3. P

    Replace link with current directory path

    Excel 2013 Hi, I'm trying to create a data gatherer template; so it's like a master file that users can just copy and save in a different folder where the rest of the files where the data will be pulled from will be saved. What I need to have the VBA do is replace all the default links within...

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