Macro to list and open .xlsm files in folder and sub-folder

**Howardc1001** · 02-22-2019, 10:10 AM

I have code to list files in C:\pull and well as sub-folder where workbook contain ACCNTS(P) in the name as well as if files are .xlsm files

eg M_BR ACCNTS (P).xlsm

The codes lists only .xls files in C:\pull and its sub-folder

It would be appreciated if someone could amend my code to include only .xlsm files

Please Login or Register  to view this content.

**JLGWhiz** · 02-22-2019, 10:59 AM

It looks like the code already looks for the .xlsm files but is qualified with a partial file name to limit those files to ones containing ACCNTS(P) in the file name. If you just want all the xlsm files then change this statement

Please Login or Register  to view this content.

in the 'ListFilesinFolder' macro to

Please Login or Register  to view this content.

and it will list all of the .xlsm files.

But it should not have been listing any other type files.

**Howardc1001** · 02-22-2019, 12:27 PM

Thanks for the help. It now extracts all the .xlsm files

I only need the .xlsm files containing "ACCNTS(P) in the name of the workbook for eg M_BR1 ACCNTS (P).xlsm . M_CA_ACCNTS.xlsm etc to be extracted

Kindly amend code accordingly

**JLGWhiz** · 02-22-2019, 02:25 PM

Originally Posted by Howardc1001

Thanks for the help. It now extracts all the .xlsm files

I only need the .xlsm files containing "ACCNTS(P) in the name of the workbook for eg M_BR1 ACCNTS (P).xlsm . M_CA_ACCNTS.xlsm etc to be extracted

Kindly amend code accordingly

Then your original code should have been producing what you wanted. But there is nothing that I can see that would produce only .xls files. Try using this line of code instead.

Please Login or Register  to view this content.

**Howardc1001** · 02-22-2019, 02:35 PM

Thanks for your help. Code is working perfectly

**JLGWhiz** · 02-22-2019, 02:46 PM

Originally Posted by Howardc1001

Thanks for your help. Code is working perfectly

You're welcome,
regards, JLG

**Howardc1001** · 02-23-2019, 02:47 PM

Is it possible to amend code that if no .xlsm file in sub-folder within C:\pull then to extract the .xls file ?

Some sub-folders may only have an .xls workbook

If so kindly amend code

**JLGWhiz** · 02-24-2019, 11:21 AM

You can try this

Please Login or Register  to view this content.

that should then return any Excel file with 'ACCNTS' in the name.

**Howardc1001** · 02-24-2019, 12:43 PM

thanks for the help. Code works perfectly

**JLGWhiz** · 02-24-2019, 07:35 PM

Originally Posted by Howardc1001

thanks for the help. Code works perfectly

You're welcome,
regards, JLG

Macro to list and open .xlsm files in folder and sub-folder

LinkBack

Thread Tools

Rate This Thread

Display

Macro to list and open .xlsm files in folder and sub-folder

Re: Macro to list and open .xlsm files in folder and sub-folder

Re: Macro to list and open .xlsm files in folder and sub-folder

Re: Macro to list and open .xlsm files in folder and sub-folder

Re: Macro to list and open .xlsm files in folder and sub-folder

Re: Macro to list and open .xlsm files in folder and sub-folder

Re: Macro to list and open .xlsm files in folder and sub-folder

Re: Macro to list and open .xlsm files in folder and sub-folder

Re: Macro to list and open .xlsm files in folder and sub-folder

Re: Macro to list and open .xlsm files in folder and sub-folder

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel VBA code for selecting a folder then search & open specified files in that folder

[SOLVED] VBA to save all .CSV files in a folder as .XLSM not working?

[SOLVED] Listing only xlsm files of the folder with VBA

Convert csv files in folder to xlsm

[SOLVED] Open password protected files in folder using list of passwords

Index Page in Folder for Macro buttons, to Run Multiple Macros on all Files in a Folder

Macro to open up all files in certain folder

Bookmarks

Bookmarks

Posting Permissions