Hello,
I have managed to put up following codes to open pdf file and folder containing other files.
Please Login or Register to view this content.Can you guys please help in combining the above two macros, so that the macro will first try to open the pdf file and if it cannot find the file then open folder instead. Also to set an error message, if it cannot even open folder.Please Login or Register to view this content.
Thank You!
Try this
FilePath variable created
- Current file path ("C:\Users\Laxman\Documents\") exists so I think you are planning to have file paths determined within vba - otherwise message would not be required
Please Login or Register to view this content.
If a response has helped then please consider rating it by clicking on *Add Reputation below the post
When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)
Thanks for helping me out kevin. When i run the macro without file in the folder, it is directly showing error message instead of opening folder.
The macro was supposed to look for file. If the file is not found, open folder with out any error msg. If the user cannot access the folder then error msg be in place.
Thank you for your time!
Odd. It works ok for me.
try amending
toPlease Login or Register to view this content.
If that does not do the trick, please post your code for me (the whole sub)Please Login or Register to view this content.
That did not fix kevin. Macro is resulting only Message box. Following is the code.
Please Login or Register to view this content.
This is exactly the same code
What happens when you run:
Please Login or Register to view this content.
I'm sorry kevin. The problem was that, i logged onto my system with different account, so my path was not holding good.
The macro is working perfect. THANK YOU! very very much.
You are welcome.
Please go to top of thread and, under Thread Tools, mark thread as "solved"
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks