I have a code, where I want to:. Save Masterfile (current active workbook),. amend the workbook and delete sheets,. then save separate copies of the edited workbookas an Excel sheet and a PDF file.The problem I have here is that the code saves the PDF file as the original Masterfile even after I have tried to activate the edited Excel file. Any help here? Would really appreciate any advice!
I could not reproduce the issue you were having.Here is my 'test' code, using a workbook with 4 sheets and information in cells(1,1), one sheet named 'May' - which is deleted, and the new file does not have 'May' and the pdf does not either.I moved the saveas code towards the top of the file. Maybe that will fix your issue, but I don't believe it will.
The Book Of The Law by Aleister Crowley Liber AL vel Legis is the central text of Thelema, written by Aleister Crowley in Cairo, Egypt in the year 1904. Its full title is Liber AL vel Legis, sub figura CCXX, as delivered by XCIII=418 to DCLXVI,1 and it is commonly referred to as The Book of the Law.