Image capture Snapshot of a live Reuters feed

[monk22]

Hello,

>>>>Excel 2003 - snapshot of live data feed

We have an Excel 2003 spreadhseet that contains a live feed from reuters and updates regularly. My boss has asked if we can get an automated snapshot of the spreadsheet every evening at 5pm! So withpout manually capturing a JPEG using Snagit or something like that - I am unsxure how to autiomate this one - any ideas guys?!!!

 

[blackbox]

this thread has some code for the equivalent of Alt+PrintScrn

http://www.tek-tips.com/viewthread.cfm?qid=1122660&page=1

I have macros that print at a certain time but I've never tried to capture screen shots.

you should be able to schedule it with something like

Application.OnTime TimeValue("17:00:00"), "MyMacro"

 

[monk22]

response

Blackbox, thanks for your response. I am fairly new to Excel so you will have to bear with me >>>>>>-Ive tried out the Alt+PrintScrn/"Sendkeys" code and it successfully takes a snapshot and saves to clip-board when I click the SUBMIT button.

However, how do I apply Application.OnTime TimeValue("17:00:00"), "MyMacro" as you have stated above?

 

[monk22]

Also, could you post the print macros if poss? Many thanks

 

[blackbox]

in "ThisWorkbook"

Private Sub Workbook_Open()
Application.OnTime TimeValue("17:00:00"), "print_macro"
End Sub

in a module

Sub print_macro()
    Application.OnTime TimeValue("17:00:00"), "print_macro"
    Dim X As Range
  Set X = Range("a1:f10")
  X.PrintOut
  End Sub

 

[monk22]

Will this work if the workbook is closed? I'm guessing it has to be open at 5PM for this auto-print to run...?

 

[blackbox]

nothing within a workbook will run when closed.

maybe a stand alone VB app or something along those lines could be scheduled to run at a set time.

that's beyond me, sorry

 

[monk22]

OK thanks - possibly a silly question there.

Couple more though:

* Q: Will the "print_macro" print to my default printer? (already set via Windows) I ask this because I altered the time to 10:30AM earlier (at 9:45AM) and nothing came out?

* The most important bit is the macro that captures the image of the spreadsheet. Can we automate to save away to the desktop? Currently using the link above [http://www.tek-tips.com/viewthread.cfm?qid=1122660&page=1] the image is embedded into a spreadsheet after the macro is run.

Hope this makes sense. Thanks