Printer error with Office 2007 in Vista

[Howard Kaikow]

Printer is connected to a router using cable.
No printer is directly connected to the Vista system.
Vista is hooked up wireless.

Both Word and Powerpoint have no trouble using the print.

In Excel, I get the message "Current printer is unavailable".

Note that I can print with Notepad and IE 7.

VB 6 IDE results in "Problem getting printer information from the system.
Make sure the printer is set up correctly".

One issue is the inconsistency within the Office apps.
The other is VB 6.

 

[Bob Buckland ?:-\)]

Hi Howard,

You may want to use the link below to also post in the MS Office Excel discussion group, or you may want to check in the Windows
Vista Print & Fax discussion group. There were similar issues in the scenario you described with Windows XP that required a hotfix
if it was happening outside of Excel, but there was also a method of fixing it, capturing a Printer Port port, if I recall, but it's
been awhile.

I'm assuming that the printer driver is a Vista compatible one.

The Office apps use printers differently for page layout, for example, before you ever print, so yes there is some differences in
how the printer is accessed by each.

===========
Printer is connected to a router using cable.
No printer is directly connected to the Vista system.
Vista is hooked up wireless.

Both Word and Powerpoint have no trouble using the print.

In Excel, I get the message "Current printer is unavailable".

Note that I can print with Notepad and IE 7.

VB 6 IDE results in "Problem getting printer information from the system.
Make sure the printer is set up correctly".

One issue is the inconsistency within the Office apps.
The other is VB 6. <<
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Howard Kaikow]

"Bob Buckland ?" <75214.226(At Beautiful Downtown)compuserve.com> wrote
in message
I'll take a look at your links on the 'morrow.

If I do a Shut Down, Restart and immediately run an Excel maxro that
references the PagesEtup object, code works.

If I them immediately, try the same code from VB 6, does not work.

Then, if I go back to Excel, again, it does not work.
But I can still print from Word, PowerPoint, etc, and Notepad.

Indeed, I just printed from Word and Powerpoint, thjen went back to Excel
and was able to print from Excel.

Now to try the macro again, ..., this time it worked!

So, I am beginning to suspect NIS 2008 as interfering.

Note that I saw a reference to a similar issue for which the cause was a bug
in the AVG auntie-virus program. Somebody said that there was a workaround,
but did not give the workaround.

I'll have to look into this on the 'morrow.

 

[Howard Kaikow]

THis might be the workaround:

http://www.howtonetworking.com/vista/remapprinter.htm

 

[Howard Kaikow]

Bingo!
Eureka!
Whoopee!

I believe that I found a fix!

On the Vista system, I changed the default printer to Microsoft XPS Document
Writer.
Ran the VB 6 program that uses Excel, no problem.
Printed from VBIDE, no problem.
Printed from Excel.no problem.
I then changed the default printer to the Brother HL-2170W.
Voila!
All appears to now work!
At least VB 6 and Excel do!

 

[Howard Kaikow]

Bingo!
Eureka!
Whoopee!

I believe that I found a fix!

On the Vista system, I changed the default printer to Microsoft XPS Document
Writer.
Ran the VB 6 program that uses Excel, no problem.
Printed from VBIDE, no problem.
Printed from Excel.no problem.
I then changed the default printer to the Brother HL-2170W.
Voila!
All appears to now work!
At least VB 6 and Excel do!

Spoke too soon.
It's broken again.

 

[Howard Kaikow]

Printer is connected to a router using cable.
No printer is directly connected to the Vista system.
Vista is hooked up wireless.

Both Word and Powerpoint have no trouble using the print.

In Excel, I get the message "Current printer is unavailable".

Note that I can print with Notepad and IE 7.

VB 6 IDE results in "Problem getting printer information from the system.
Make sure the printer is set up correctly".

One issue is the inconsistency within the Office apps.
The other is VB 6.

The following seems to have fixed things, at least fer now.

I really needed my default printer to work with Excel and VB 6, so I
installed a BullZip PDF printer, made it the default and things worked with
BullZip as default.

Ever looking for trouble, I then set he Brother printer as the default.

Egad!
Printer worked properly in Excel and VB 6!!!

I'm trying to summon the courage to do a reboot to see if that breaks
things.
Hmmm, now where did I put my bottle of corage pills?