Writing a macro in Excel that Refreshes External Imported Text File
 

Hi there, I am trying to write a macro that simply refreshes a
spreadsheet that has imported external data. I tried to record a
macro, but I cannot have trhe click on the "Import" button as part of
the macro. Is there anyone who can help me with that simple code.
Currently, the macro just click on the DATA tab and chooses DATA
REFRES. I need to a line that will just click on the "Import" button.
Because the default file to be imported is correct so I don't need to
choose a file. Many thanks