Murari Rajagopalan
Member
Folks,
I am trying to import a text file which gets updated every hour in excel using Data>From Text and mentioning the URL in the File name path. it works fine and data is getting loaded in excel. When I set automatic refresh for every 60 minutes and during refresh, "Open" file window keeps popping out and asking me to chose the URL path in the file Name. Any idea as how to suppress this Open file window ? thanks in advance.
I am trying to import a text file which gets updated every hour in excel using Data>From Text and mentioning the URL in the File name path. it works fine and data is getting loaded in excel. When I set automatic refresh for every 60 minutes and during refresh, "Open" file window keeps popping out and asking me to chose the URL path in the file Name. Any idea as how to suppress this Open file window ? thanks in advance.
