Running Excel

[kirkm]

Hi,

I want to send someone an xls on a CD with some associated jpg
files. They're not computer literate so the instructions will be copy
all this to a folder and double click the .xls file.

But I can't figure out how to detemine what Path-folder they might
choose. Does any Excel command return this info ?

Thanks - Kirk

PS It's not Application.Path - Pity

 

[Dave Peterson]

The path of the workbook with the code would be:
ThisWorkbook.path

 

[kirkm]

The path of the workbook with the code would be:
ThisWorkbook.path

Thank you Dave. Another step foward
Cheers - Kirk