Hi Everyone,
I've been trying (and failing) to solve an error the following bit of VBA for the last few weeks, and I haven't seen someone post online with a similar issue.
Essentially, I have a bit of code that creates a few hundred PDFs based on information held in other sheets. The code looks like this:
Randomly I will get the following error: Run-time error '1004': Method 'ExportAsFixedFormat' of object '_Worksheet' failed
The line highlighted is the PDF export line.
Hitting resume continues the code, but there will a PDF from the selection that has been missed.
ufProgress is a userform for marking the progress of the macro for users of the sheet.
As you may be able to tell, savepath refers to a network location (which I do have permissions to access). I just ran the code without error when saving to C:\PDFs.
Any help would be greatly appreciated.
Bookmarks