Exporting as a PDF then openeing folder location rather than actual file...

Hi all,

Hoping you can help...

I've borrowed/pieced together some code to export my sheet as a PDF and allow the user to choose their own location to save the file. What i'd then like to do is open up the folder they chose so that the user can see the new pdf alongside the existing files in the folder (the folder will contain a series of documents about a customers booking, e.g. invoice, confirmation letter etc)

I've added on some code to the end which opens the file path as it was selected by the user but it includes the entire filepath rather than stopping at the folder location (note i've set the open after publish option to false already)

essentially i need to cut the final part of the file path off from "Fname" in the final line of code but because this is saved as a variant from the very first line of the code I don't know how to do this....

Please Login or Register  to view this content.

hope you can help - shout back with any questions if i've not been very clear!