Hello-hopefully this the right form for this question:
From an XP machine, I have had no problems using Excel 2007 to import
comma delimited text (csv) files stored on my local hard disk into a
particular spreadsheet. The DataGet External DataFrom Text wizard
works fine and have had no trouble using the Refresh function.
However, on my Vista machine, when refreshing information in a
workbook coming from a data source (i.e.: text file) the file name is
missing from the Import Text File box. But when I look into the
connection properties (from the DataConnectionsPropertiesDefinition
tabConnection File) the correct name of the file is listed. I think
this is related to a security feature in Vista, where it recognized
the source but makes me reselect the file. This is fine, except that
I have several queries set often times within the same workbook so it
becomes a problem when I have to re-do a query that is suppose to work
automatically. Any suggestions?
Thanks,
Diba