ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting App.Path in VBA? (https://www.excelbanter.com/excel-programming/292346-getting-app-path-vba.html)

Matthew John Antoszkiw

Getting App.Path in VBA?
 
I'm opening a workbook, and I I can't use relative paths because I'm always
told the file was not found.

Is there a way to get App.Path like in VB, in VBA?
ta.



Tom Ogilvy

Getting App.Path in VBA?
 
Application.Path

Thisworkbook.Path

--
Regards,
Tom Ogilvy


"Matthew John Antoszkiw" wrote in message
...
I'm opening a workbook, and I I can't use relative paths because I'm

always
told the file was not found.

Is there a way to get App.Path like in VB, in VBA?
ta.





Matthew John Antoszkiw

Getting App.Path in VBA?
 
Thanks :)

"Tom Ogilvy" wrote in message
...
Application.Path

Thisworkbook.Path

--
Regards,
Tom Ogilvy


"Matthew John Antoszkiw" wrote in message
...
I'm opening a workbook, and I I can't use relative paths because I'm

always
told the file was not found.

Is there a way to get App.Path like in VB, in VBA?
ta.








All times are GMT +1. The time now is 12:26 PM.

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