Using Default Path

[Rocky0201]

Hi folks.

I have a .xlsm spreadsheet with a number of .htm files in the same folder. The spreadsheet referrences the .htm files. I would like to know if there is a way to not having the need to define the path to open these files but to use the path that the .xlsm file was loaded from. This way I do not need to hardcode a path which will allow the spreadsheet to work no matter what falder it is placed in and the .htm's are in the same folder.

The code I'm trying to avid is below:

MyPath = "X:\Level 1\Pilot\Incident Reports\"
ChDrive MyPath
ChDir MyPath

In advance, thanks for the help...

 

[Norie]

Can't you just get the path for the workbook the code is in like this?

MyPath = ThisWorkbook.Path

 

[TheNoocH]

try something like this

mypath = thisworkbook.path
chdrive left(mypath,3)
chdir mypath

 

[Rocky0201]

I found a solution. I am using:

MyFolder = ThisWorkbook.Path

Seems to be working fine...

Thanks,

Rocky

 

[Rocky0201]

Thanks folks.. seems that your reply to my post and my replay happened at the same time... I truly appreciste the quick response.