"Refresh Data" Question
 

In Excel 2000 SP-3

I used: Data/Get External Data/Import Text File
to import data into a worksheet. Then, to import from another file into
the same worksheet, I used: Data/Refresh Data. It asked me for a file name
and when I entered it it worked fine.

However, when I attempted to record the "Refresh Data" as a macro, all that
was recorded was:
Selection.QueryTable.Refresh BackgroundQuery:=False

The part where I specified the file name was not recorded. When I run the
macro, it asks me for the file name.

How can I specify the file name in the macro so that it does not have to be
entered manually?

Many thanks.

"Refresh Data" Question
 

NS

Change the Connection property of the QueryTable object. The Connection
property looks like

TEXT;C:\MyText1.txt

You can use code like this

sNewFile = "C:\MyText2.txt"

With Sheet1.QueryTables(1)
.TextFilePromptOnRefresh = False
.Connection = "TEXT;" & sNewFile
.Refresh False
End With


--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

wrote in message
...
In Excel 2000 SP-3

I used: Data/Get External Data/Import Text File
to import data into a worksheet. Then, to import from another file into
the same worksheet, I used: Data/Refresh Data. It asked me for a file
name
and when I entered it it worked fine.

However, when I attempted to record the "Refresh Data" as a macro, all
that
was recorded was:
Selection.QueryTable.Refresh BackgroundQuery:=False

The part where I specified the file name was not recorded. When I run
the
macro, it asks me for the file name.

How can I specify the file name in the macro so that it does not have to
be
entered manually?

Many thanks.