Lookout

cancel
Showing results for 
Search instead for 
Did you mean: 

Auto print spreadsheets

In Lookout, is it possible to automatically print daily/monthly spreadsheets?
If so, how?

Thanks
Travis
0 Kudos
Message 1 of 3
(3,417 Views)
Hi,

I have been trying to do this for ages.
The best method I came up with was to set up a DDE link to a cell in Excel.
When you want to print from Lookout change the state of this link (e.g. 0 to
1).
Then in the background of Excel, have a macro running that monitors the
state of this cell. When it changes, get the macro to print the sheet.

Its not pretty, its not clever but it works!
(It also means having Excel running all the time)

John

Travis Kinard wrote in message
news:39f0646e@newsgroups.ni.com...
>
> In Lookout, is it possible to automatically print daily/monthly
spreadsheets?
> If so, how?
>
> Thanks
> Travis
0 Kudos
Message 2 of 3
(3,417 Views)
It's easy... use a Run object to send the "print" command. If you wanted
to print say Book1.xls from your temp folder, the Command under the Run object
would be:
"print d:\temp\book1.xls"

The trigger to print ('Run when' field of Run Object) would be the date and
time you want to print.. and I am guessing you already have this setup.

Rgds,

Khalid


"John Dunlop" wrote:
>Hi,>>I have been trying to do this for ages.>The best method I came up with
was to set up a DDE link to a cell in Excel.>When you want to print from
Lookout change the state of this link (e.g. 0 to>1).>Then in the background
of Excel, have a macro running that monitors the>state of this cell. When
it changes, get the macro to print the sheet.>>Its not pretty, its
not clever
but it works!>(It also means having Excel running all the time)>>John>>Travis
Kinard wrote in message>news:39f0646e@newsgroups.ni.com...>>>>
In Lookout, is it possible to automatically print daily/monthly>spreadsheets?>>
If so, how?>>>> Thanks>> Travis>>
0 Kudos
Message 3 of 3
(3,417 Views)