Monitor Google Print with Excel VBA

34 views
Skip to first unread message

djchri...@gmail.com

unread,
Dec 18, 2012, 6:13:14 AM12/18/12
to excel-r...@googlegroups.com
Hello,
my macro Excel is generating reports every day. I want the program in VBA to use Google Print and print the files generated on a remote printer.
other suggestions of solutions are welcome.
Thanks,
Chris

Bruce Mcpherson

unread,
Dec 18, 2012, 6:33:17 AM12/18/12
to excel-r...@googlegroups.com
Hello

Google Cloud Print needs enabled applications to do that. If you look at the printer dialog available in excel, application.Dialogs(xlDialogPrinterSetup).Show , you'll see it doesn't know about cloud printing - this is enabled by the chrome browser. 

I've never tried this, https://tools.google.com/dlpage/cloudconnect ,but this may be a way forward..

bruce


--
 
 

Reply all
Reply to author
Forward
0 new messages