ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excel 2007/Vista: Missing file name on import external data connection (https://www.excelbanter.com/new-users-excel/149218-excel-2007-vista-missing-file-name-import-external-data-connection.html)

diba

Excel 2007/Vista: Missing file name on import external data connection
 
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



All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com