topic Re: Auto print spreadsheets in Lookout

Auto print spreadsheets

Travis Kinard — Fri, 20 Oct 2000 15:27:42 GMT

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

Thanks
Travis

Re: Auto print spreadsheets

John Dunlop — Thu, 23 Nov 2000 14:37:55 GMT

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

Re: Auto print spreadsheets

Khalid — Mon, 27 Nov 2000 20:45:00 GMT

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>>