View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ChrisBat ChrisBat is offline
external usenet poster
 
Posts: 5
Default 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