ExportAsFixedFormat Error

[Murf]

I have an 2007 Access database that pull data from an AS/400 and saves the data in excel. I just added the option to save the excel file as a PDF instead of excel. This code works the first time. But the second report gets the error. If I compact and repair the same report that caused the error works but the next one doesn't. Any Ideas?

Code:
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, FileName:=strSaveAs, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

Error:
91 - Object variable or With block variable not set

strSaveAs = "j:\XLS\FileName.PDF"
xlTypePDF = 0
xlQualityStandard = 0

 

[boblarson]

The problem is that you are using

ActiveWorkbook...

And not fully qualifying it. Activeworkbook should be tied to an Excel Application Object and not by itself. So something like:

objXL.Activeworkbook

if you have created an object named objXL as the application object.

If you don't then Activeworkbook will create an Excel object in the background, but the only way to get rid of it is to either exit the Access database or use Task Manager to kill the Excel instance.

 

[Murf]

Thanks Bob. That did the trick.

 

[boblarson]

Thanks Bob. That did the trick.