Hello!
I have a program which outputs a report as a PDF file.
I've got the outputting working, but how can I make it open the PDF afterwards?
The PDF file name and path is a variable called filepath (it's generated as part of the code - i.e. filepath = C:\User\Documents\...\file.pdf)
Any help?
Please Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hey nathansav,
I'm worried about this tool being used on a computer with a different pdf reader, version, filepath whatever...does it have to be referenced? Is there no way to make it use the operating system's default program?
Yes, but you'll need to look at that. You need to look at Special Folders in VBA, getting the version of the PDF reader thats a bit trickier, i'd error trap opening the alternatives,
so reader 1
error try reader 2
error try reader 3
no error
Eurgh, sounds complicated. I think I'll just have a MsgBox("Your report can be found at " & filepath). Lazy, but easy. XD
Actually is there a way I can make it open a folder? Because I could at least make it open the folder with the report in it...
Look at Shell() this will help with what you want.
Shell "C:WindowsExplorer.exe", vbNormalFocus
Look at Shell() this will help with what you want.
Shell "C:WindowsExplorer.exe", vbNormalFocus
I'd use an API call:
At the top of your module:
New routine:Please Login or Register to view this content.
So now your code can simply use:Please Login or Register to view this content.
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Will pretty much open anything with the default fileviewerPlease Login or Register to view this content.
Kyle123 and romperstomper's solutions were brill :D Thanks
Kyle's does come up with an excel warning box thingymabob about potential harm to the computer so I'm going with Romper's.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks