Hi am new to the form and vba scripting. I want to open a file that is in the parent folder my workbook I use the command ActiveWorkbook.Path & "\test.xls" and it works
(....\parentTest\folder\test.xls).
but I can't find a solution in order to open a file which is located in the "\parentTest\test2.xls".
Thanking you in advance!
Hi alazari,
The following code may help. It goes through a routine to find the path for the Activebook's root directory and then opens a file from that directory.
Hope this helps!
Please Login or Register to view this content.
Daniel
Hi, Daniel,
you may use InStrRev to find the last occurrance (or first from the end) in a string.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
You could also do it like this:
Please Login or Register to view this content.
It works perfectly!
Thank everyone for the immediate responce thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks