Ok I can save and create pdf, I just need help deleting the .xls file.
Here is code I have:
Code:
Please Login or Register to view this content.
I need to keep the newly created .pdf and delete the created/saved .xls file, I just can't ssem to figure out what I need to write in code.
Michael
Cross-posted:
http://www.mrexcel.com/board2/viewtopic.php?t=265397
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I did not realize the 2 sites we affiliated. Sorry
Does anyone have an answer?
Michael
There not affiliated. However to avoid wasting people time you should declare the cross post by adding the link.
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
The point against cross-posting on ANY forum (at least for me) is that kind souls like myself lend our time and knowledge to help those in need, and we'd rather not waste time fixing a problem when a number of other people are doing the same thing or have already resolved the issue on another board.
It is also very rare that a cross-poster will go back to the multiple boards and update the case(s) so people reading it a day or two later won't attack the problem and waste their time.
With that in mind, below your ActiveWorkbook.Save section of code, try this line of code:
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