ExcelBanter - CurDir("c")

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - CurDir("c") (https://www.excelbanter.com/excel-programming/323524-curdir-c.html)

BobAchgill

CurDir("c")

Is there a way to get back the path to the spreadsheet that is running this
VB script?

The subject call only brings back the path to MyDocuments.

Thanks!

Bob Achgill

Tushar Mehta

CurDir("c")

ThisWorkbook.Path

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Is there a way to get back the path to the spreadsheet that is running this
VB script?

The subject call only brings back the path to MyDocuments.

Thanks!

Bob Achgill

All times are GMT +1. The time now is 05:28 PM.