LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
pom pom is offline
external usenet poster
 
Posts: 7
Default VBA ActivePrinter

Hi all!

I need to send out a spreadsheet to users on different sites which has
several print macros included (making complicated selections). The document
has to be printed in colour - I set the macros up for my PC, using the path
to my colour printer. This will obviously be different for other users, and
the colour printer will not (generally) be their default printer. Before I
change the code completely, does anyone know a way of setting up an unknown
colour printer as your ActivePrinter?!

Cheers!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.ActivePrinter??? Aldo Miele Excel Programming 1 September 7th 04 12:18 PM
Method 'ActivePrinter' of object '_Application' failed kiat Excel Programming 0 August 18th 03 03:45 PM


All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"