Determining the full path and filename of an active workbook

G

Guest

Is there any way to determine the full path and filename of the active
workbook? I'm writing a macro that creates and saves files, and I'd like it
to reference the full path of the file so that I can use the same program to
open and view the files afterwards. Any suggestions?
 

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

Problem with file path to sharepoint 0
Function or formula to show currently active workbook name in cell 1
Listing files with full path 2
Run macro from active workbook whose name keeps changing 20
Save All Worksheets as CSV 7
Active or current file path 9
save and exit macro 8
Get path of open workbook 4

Top