View Single Post
 
Old 04-20-2022, 07:11 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 872
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

shouldn't the line which causes the error begin:
objPPTX
rather than

PPTX
?


Part 2:
objPPTX.ActivePresentation.saveas Filename:="C:\Users\s.kalantari\Desktop" & cell01 & ". PPTX"
(not tested. cell01 shouldn't contain any illegal filename characters)


I suspect there's a way to change file names without opening the file at all.
Reply With Quote