Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
sxschech

sxschech

Technical User
Jul 11, 2002
1,033
US
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.

 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
msoffice 2007 has a free plugin for creating a PDF.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Does the plug in work in Access and allow merging of multiple pdf files?
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
644
strongm
strongm
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
516
Andrzejek
Andrzejek
linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
416
linuxguyEastCoast
linuxguyEastCoast
K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
581
combo
combo

Part and Inventory Search

Sponsor

Back
Top