Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
I need to refresh external data in Excel automatically, daily
What I was wanting to do is have the data refresh each night around 8pm when noone is around. I'm an AS/400 programmer and trying to manipulate data in excell is new to me. But, the idea i had was to create a macro that opens and closes the file. Then if I could run this macro in a batch file I...- amynboys
- Post #4
- Forum: Microsoft: Office
-
I need to refresh external data in Excel automatically, daily
I have an excel spreedsheet that gets external data through query. I need a way to refresh this data on a daily basis automatically, without human intervention. Can someone help me with this? Thanks in advance. Amy- amynboys
- Thread
- Replies: 5
- Forum: Microsoft: Office
