Quick Code Conversion

[j.lancaster1]

Hello,

I just have a simple issue. The following code allows me to select a .csv file and add the file to my current excel file. I want to do the same thing, but with .xls files instead of .csv I know to change the .csv to .xls in the code, but the data is importing in the incorrect format. I know the issue is somewhere in the "Import Text Data" section at the bottom, but I'm not sure which parameter to change to get it to read the .xls files

Please Login or Register  to view this content.

[BuckoAk]

Take a look at this Link
http://www.excelforum.com/excel-prog...using-vba.html


You will need to set the Path and Range per your needs

MyPath = "C:\"
Set sourceRange = mybook.Worksheets(1).Range("A1:C1")

[patel45]

Please Login or Register  to view this content.

[j.lancaster1]

Thanks guys. I forgot to mention that I needed the new file to import onto a new tab/sheet. Patel45, with your code the new file opens up as it should, but on the tab that the macro was on (and deletes the button). Can you tweak it to where the data is put on a new tab/sheet?