Wednesday, October 17, 2018

#1 2018-10-10 03:37:35 am

timbaldwin
Member
Registered: 2006-08-14
Posts: 60

Print Excel page

Hi

Sorry if this is a stupid question but how do I print a sheadsheet in Excel (Office 365) ?

I've tried the following

Applescript:

tell application "Microsoft Excel"
   
   activate
   
   print window 1 with print dialog
   
   print workbook 1 with print dialog
   
   print sheet 1 with print dialog

end tell

all of which does nothing...

Thanks

Tim

Offline

 

#2 2018-10-10 03:49:15 am

Nigel Garvey
Moderator
From:: Warwickshire, England
Registered: 2002-11-20
Posts: 4690

Re: Print Excel page

Hi.

I don't know about Excel, but in most applications, you print a document or a file or a list of documents or files.


NG

Offline

 

#3 2018-10-10 04:02:11 am

timbaldwin
Member
Registered: 2006-08-14
Posts: 60

Re: Print Excel page

Thanks Nigel

The script I pasted was part of a larger script which creates the spreadsheet on the fly then discards it without saving.  So no file exists, only what is on the screen.

It worked fine with Excel 2008 but stopped working when we upgraded.

Thanks

Tim

Offline

 

Board footer

Powered by FluxBB

RSS (new topics) RSS (active topics)