I am creating a excel object using lotusscript/vb code.
Set excelobject = CreateObject("Excel.Application")
I have the following command to send the excel directly to printer
excelobject.worksheets(1).PrintOut - This works well and sends the file directly to printer
Now, I need to invoke a command so that the "Page Setup/Printer Dialogbox" opens to the user so they can make whatever selection they require then send it to printer
I have tried:
commonDialog1.ShowPrinter instead of the print command - This didn't work.
I don't want to use
Any ideas on how to achieve this will be appreciated.