import csv macro for excel 2000 and up

**catchg** · 02-17-2013, 03:35 PM

I have a macro assigned to a button that is used to import a csv file into an existing sheet named "Data". The macro was created using Excel 2010. I would like the macro to also work in all previous versions back to Excel 2000. Is it possible to adapt the code to work on Excel 2000 and up? Below is the code I am using. Thanks in advance!

Please Login or Register  to view this content.

**JBeaucaire** · 02-18-2013, 12:36 AM

Have you tried this on Excel 2000?
Did it fail?

When you compile or DEBUG the error, which line is highlighted?

**catchg** · 02-18-2013, 01:36 PM

Thanks for taking the time to help me. When I select the import data button using Excel 2000, I get "Run-time error 438" displayed. Debugging shows highlighted in yellow the following:

With Application.FileDialog(msoFileDialogFilePicker)

**JBeaucaire** · 02-18-2013, 03:53 PM

A couple of other techniques to test, see if you can get the results you need:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**catchg** · 02-19-2013, 01:23 PM

I've tried the 2 techniques you suggested and can not get the file open dialog window on XL 2000. I read the following info at:

http://support.microsoft.com/kb/213371/en-us

So, I tried the code from the link above and the file dialog window appears in XL 2000 and imports the csv data into a new workbook. The code follows:

Please Login or Register  to view this content.

As you can see in my original post, I am trying to import the csv data into an existing worksheet named "Data" (Range f6). I believe the way QueryTable was coded back then also needs to be considered. Any suggestions to have the imported data load into the existing sheet named "Data" when using XL 2000 version and up would be greatly appreciated. Thanks!

**catchg** · 03-20-2013, 07:45 PM

JBeaucaire, I am able to get the file dialog box to open in Excel 2000 with the code I posted in reply above. It loads the csv into a new workbook. Could you kindly give me some suggestions how to load the csv data into an existing sheet named "Data" starting in cell F6. Please keep in mind I am trying to write the macro to import csv into existing sheet named "Data" that works on excel versions 2000 to 2013. Any suggestions would be appreciated. Thanks!

**JBeaucaire** · 03-20-2013, 07:48 PM

Turn on the macro recorder and let it record you doing an Import Data from File routine. That recorded macro can then be tweaked to use the one of the "get filename" methods you've already explored and insert that filename into the macro you recorded at the appropriate spot.