Getting file name from Worksheet or Workbook?

  • Thread starter Thread starter Gustaf
  • Start date Start date
G

Gustaf

Wonder if it's possible to get the file name from either a Worksheet or Workbook object. Found the Workbook.Path property, but there's no corresponding File property.

Thanks,

Gustaf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 macro gets workbook name and path from temp file 4
Excel2007 sheet returns workbook.name as temp file. 3
Get calling workbook path? 2
Path Name issue for file opened from Z drive 3
Workbook.Path 3
Open second Excel file with VBA 5
Sending a variable to another workbook? 4
How to reference a cell from anther workbook without opening it 0

Back
Top