Excel 2007 Import data question

S

Stevens

I have created an .xls file that imports fields from a .csv file. I have the
properties set to 'Prompt for file name on refresh' and 'Refresh data when
opening the file'. When I do this with Excel 2003, The name of the .csv file
to be imported is displayed in the File name of the Import Text File window.

When I create an .xls file that imports fields from a .csv file, with the
same properties as above, in Excel 2007, the name of the .csv file to be
imported is not displayed in the file name in the Import Text File window.
Is there anyway to have this displayed rather than select it from the list?

Any help would be appreciated. Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Write EXCEL files from a FORTRAN Program ? 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Adding data to MS Access from csv file 0
Cannot import CSV file into ACCESS 1
Mail Merge Directory Conditional Page Break 0
Excel And Notepad 3
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Import Multiple CSV Files from Same Folder into Open Workbook 5

Top