How to get the path from where an Excel Worksheet has been opened

S

Stefan Mueller

With
ActiveWorkbook.Path
I can get the path where an Excel Worksheet is located.
However, I also need to get the path of the shortcut if you start an
Excel Worksheet via a shortcut.

I need this information because I'd like to write some files to the
directory from where the Excel Worksheed has been opened.

Does anyone know how to get the path from where an Excel Worksheet has
been opened?
If it's not possible to get this path does anyone have a good idea/
workaround for my task to write some files to the directory from where
the Excel Worksheed has been opened?

Stefan
 

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

How to read Excel Array to vb.net Arrays? 20
Merging from an Excel file with graphics 1
How to get the path where a shortcut of an Excel sheet is located 2
Problem with file path to sharepoint 0
Set Folder path for entire module 3
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
Opening Various File types from an Excel Worksheet 3
Macro to open file and copy information from worksheet 1

Top