Using VBA to enter info on external dialog box
Hi,
I am writing a macro that will automatically download a
spreadsheet from an intranet site. I have two questions:
(1) How do I write the code to run at say 3:00 a.m. every
Saturday?
(2) How do I write the code to click "OK" or "CANCEL" on
the dialog boxes that pop up prior to downloading? I
don't need to enter information on these boxes, just to
say ok or cancel.
Thanks,
Chris
|