Modify code to work with xls and xlsx files

**CJ-22** · 08-30-2013, 08:17 PM

Hello,

I have a code (probably found it on this forum) that opens up an Open Dialog Box to open another Excel Workbook. When you select the Excel Workbook you want to open, it copies data from the first workbook to the new one and saves the file. It works great except it will only open .xls files. My work is starting to use .xlsx files now and I need to update the code. Can someone help modify this code to be able to open .xls and .xlsx files? Thanks for any help and here is the code.

Please Login or Register  to view this content.

**Solus Rankin** · 08-30-2013, 10:14 PM

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

first workbook to the new one and saves the file

I don't see where this code saves your workbook FYI

**jindon** · 08-30-2013, 10:20 PM

Change to

Please Login or Register  to view this content.

**CJ-22** · 08-30-2013, 10:26 PM

Thanks for the reply XeRo Solus. I tried your suggestion, but it did not change anything. Either way I can only see .xls files in the dialog box. Even if there are both .xls files and .xlsx files in the folder I am viewing, I can only see the .xls files. I don't know why. Also, you are right. It does not save the file automatically. The file is left open and I manually save it. Sorry for the confusion. Any other suggestions?

**CJ-22** · 08-30-2013, 10:33 PM

Hi Jindon,

Thanks for the suggestion. I tried it but I can still only view .xls files in the Open Dialog Box. The drop down arrow to change file types only has the .xls option, but I do not know why.

**jindon** · 08-30-2013, 10:37 PM

Then your Excel is something wrong....

I can see .xls, .xlsx, xlsm etc, any files starts from .xls

**CJ-22** · 08-31-2013, 11:21 AM

Sorry Jindon, you are right. Somehow I copied and pasted incorrectly. It is now working great. Thanks for all the help.

Modify code to work with xls and xlsx files

LinkBack

Thread Tools

Rate This Thread

Display

Modify code to work with xls and xlsx files

Re: Modify code to work with xls and xlsx files

Re: Modify code to work with xls and xlsx files

Re: Modify code to work with xls and xlsx files

Re: Modify code to work with xls and xlsx files

Re: Modify code to work with xls and xlsx files

Re: Modify code to work with xls and xlsx files

Thread Information

Users Browsing this Thread

Similar Threads

modify SUMIF to work w/ closed files

Merge Data from different .xlsx files & different sheet to a new .xlsx

How to add the columns data of several xlsx files of a folder in another xlsx file

VBA code to turn CSV files into XLSX

[SOLVED] modify xlsx files with excel 2003

Bookmarks

Bookmarks

Posting Permissions