Spreadsheet writes file to same location issue 1

[TheLad]

Guys

Lets say I have downloaded a spreadsheet from a document repository into C:\Temp. I go into the spreadsheet, run the VB Macro, and I want the output to be put into the same directory as the spreadsheet. Please can you advise how I can get the directory path name where the spreadsheet has been downloaded to?

If I just export the file without any location, it saves the file to My Documents.

Please can you help?

--------------------------------------
"Insert funny comment in here!"
--------------------------------------

 

[RivetHed]

ThisWorkbook.Path will give you the current directory of the workbook.

 

[TheLad]

I knew it has to be something simple, thanks for the quick response

--------------------------------------
"Insert funny comment in here!"
--------------------------------------

 

[RivetHed]

No problem.