ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using .pagesetup with no installed printer (https://www.excelbanter.com/excel-programming/323188-using-pagesetup-no-installed-printer.html)

Patrick McNeil

Using .pagesetup with no installed printer
 
We have a server component that creates an Excel workbook to be used as an
email attachment. The workbook\sheets are created via VB6 code.

The problem we have is the network engineers have a tendency to add and
remove printers on the server at will. The Excell application "PageSetup"
property does not work when no printer is installed.

Is there a way to install a "dummy" printer via code that can be used when
we find no physical printer installed? Is there another method we can use?


All times are GMT +1. The time now is 06:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com