ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to get the path from where an Excel Worksheet has been opened (https://www.excelbanter.com/excel-programming/394431-how-get-path-where-excel-worksheet-has-been-opened.html)

Stefan Mueller[_2_]

How to get the path from where an Excel Worksheet has been opened
 
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



All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com