Image capture Snapshot of a live Reuters feed

monk22

New Member
Joined
Jul 31, 2007
Messages
12
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?!!!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

monk22

New Member
Joined
Jul 31, 2007
Messages
12
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?
 

blackbox

Board Regular
Joined
Apr 2, 2006
Messages
122

ADVERTISEMENT

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

in a module
Code:
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

New Member
Joined
Jul 31, 2007
Messages
12
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

Board Regular
Joined
Apr 2, 2006
Messages
122
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

New Member
Joined
Jul 31, 2007
Messages
12
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,101
Messages
5,768,101
Members
425,453
Latest member
bince

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top