Active Printer Ne Issue: Moved from XP/Office2003 to Win7/Office2007

[sxschech]

Just received a new computer going from XP and Office 2003 to Win7 and Office 2007, looks like I have a lot to learn/relearn. Anyway, I managed to bring over an excel file and access file and got the references changed (or so I thought). Now when I try to print, I'm using code provided by 'Programmatically create a PDF from Access 2002
thread707 -1119207'

The code stops at this line:

Application.ActivePrinter = "Adobe PDF on Ne03:"

so I looked at the properties of Active Printer and saw it was now Ne01, so I changed Ne03 to Ne01, but still doesn't work. The error message is:

Run-time error '1004' Method 'ActivePrinter' of object '_Application' failed

Does the code need to be changed more substantially for Windows7 and Office 2007? I am using similar code in both Excel and Access.

Thanks.

 

[sxschech]

Good news, that part of the problem is now solved. After some more trial and error, changing default printers, I got it working. This time it said the printer was Ne04 rather than Ne01. We'll see how long this lasts before Ne number changes again? Now if I can get the code that performs the pdf merge in ms-access 2007 vba working (used to work in 2003), I'll be happy as it currently is crashing the application.

 

[PHV]

msoffice 2007 has a free plugin for creating a PDF.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sxschech]

Does the plug in work in Access and allow merging of multiple pdf files?

 

[sxschech]

Forgot to post back that the merge code is working again. Not sure why it didn't work one day and a few days later worked fine.