Macro to Refer the current Workbook for opening PPT Template
Hi,
I have the following line of code in a Macro (Which u people only give me & is working Gr8. Thanks once again)
What I need is, I need to change this code to get take the PPT from the file where the excel is already there so that, eventif I am not connected to network, (Z drive is my server) I can get the PPT which is in the same folderPHP Code:PPT.Presentations.Open Filename:="Z:\Monthly Reports\DU Dashboard\DU Dashboard Template.pptx"
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
Hi,
Can anyone help me pls?
Hi
does the template have the same name in the current directory? if so
might work
Please Login or Register to view this content.
Hi,
Thanks for the help.
But I am getting the following error
Snap1.jpg
Hi
if there is a file with that name in the same directory as your workbook, try this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks