File Path Reference to Location of Open Spreadsheet

**R_S_6** · 05-29-2009, 06:59 AM

Hi All,

I have a line of code in a macro that I was provided previously on this forum; It reads:

Please Login or Register  to view this content.

The spreadsheet for which this code is used is located in the same location as "C:\Films\". However is there a way to modify that part of the code such that it looks in the directory in which the spreadsheet is stored? Not sure if '%' signs or some such could be used???

Cheers in Advance,

**DonkeyOte** · 05-29-2009, 07:12 AM

Do you mean instead of

Please Login or Register  to view this content.

Please Login or Register  to view this content.

change This for Active if the code is not running in the same file as the shape etc... (ie ThisWorkbook = file containing code and ActiveWorkbook being just that)