Using CreateObject("WScript.Shell") for non special folders

[laxminarayana]

Hi,

I am trying to create hyperlink to a open .pdf file. Every time a new pdf file will be opened based on the cell value. Following code is working only if my pdf files are on "Desktop" Folder. Can someone help me in getting the following code to work for files that are not on C:\ drive. pdf files are located in E:\Laxman\2016\.

Please Login or Register  to view this content.

Thanks
Laxminarayana

[LJMetzger]

Hi,

I think you are making things too complicated. Try the following construction:

Please Login or Register  to view this content.

The 'ThisWorkbook' (or 'ActiveWorkbook') is probably not needed, but that's what I have in code that works.

Lewis

[Kenneth Hobson]

Please Login or Register  to view this content.

[laxminarayana]

Thank You! very much. That works. :-)