Choose a Folder and loop a sub

**smartbuyer** · 02-11-2016, 11:04 PM

Hi,

I would like to ask for help for a code to:
1. Choose a folder
2. Loop a sub for all the files inside the chosen folder.

all files in the folders are .xls

Couldnt find anything online that allows me to paste my existing sub.

Appreciate any help

**spitfireblue** · 02-11-2016, 11:36 PM

Like this?

Please Login or Register  to view this content.

**smartbuyer** · 02-11-2016, 11:53 PM

I would need a code to allow me to choose a 1 folder and loop the files in that chosen folder only

**spitfireblue** · 02-12-2016, 12:10 AM

That is what it does... however I have amended it slightly so that you only have to put the folder location in once.

Please Login or Register  to view this content.

The blue highlighted code opens each file in the folder and then closes and saves it at the completion of your code, but you can take them out if you need.

**smartbuyer** · 02-12-2016, 12:17 AM

Appreciate your help and I apologise if I was unclear.
There are more than 1 folder location. I ran your code and it doesnt ask me which folder I would like to use. maybe Im missing something

Originally Posted by spitfireblue

That is what it does... however I have amended it slightly so that you only have to put the folder location in once.

Please Login or Register  to view this content.

The blue highlighted code opens each file in the folder and then closes and saves it at the completion of your code, but you can take them out if you need.

**spitfireblue** · 02-12-2016, 01:13 AM

Oh... I understand now. You want to select the folder. Try this...

Please Login or Register  to view this content.

**Doc.AElstein** · 02-12-2016, 11:36 AM

@ spitfireblue
Hi
i just wanted to say that I found this " Shell " " BrowseForFolder " thing a nice alternative to other ways to get at files and so used it effectively....
http://www.mrexcel.com/forum/excel-q...ml#post4427500
So I wanted to mainly say thanks, but also to say in passing that your Default Path is not specified or declared ( OpenAt ). But that is not a problem if the OP has not got Option Explicit as it then just takes it as "" and goes by the default )

@ smartbuyer
The code i did at that reference I gave above allows you to select which files in the Folder you want to do stuff on. That may be of interest

Note also what was said in that other Thread of yours:
http://www.excelforum.com/excel-prog...ml#post4306686

Originally Posted by JLGWhiz

You did not specify a path or directory name, so it is assumed that the Master workbook will be in the same folder as the files and the Master workbook will host the code.......

I think if you had taken note of that you would have seen that you had your problem here very close to solved.
Maybe the next time when you start a similar thread you should copy the URL Link from above in the small Browser Window and post in the Thread at the start. This helps us not to repeat what others have done for you.....

Originally Posted by smartbuyer

.....
Couldnt find anything online that allows me to paste my existing sub. ....

..I think in the other Thread that is more or less what JLGWhiz showed you
Thanks
Alan

Choose a Folder and loop a sub

LinkBack

Thread Tools

Rate This Thread

Display

Choose a Folder and loop a sub

Re: Choose a Folder and loop a sub

Re: Choose a Folder and loop a sub

Re: Choose a Folder and loop a sub

Re: Choose a Folder and loop a sub

Re: Choose a Folder and loop a sub

Re: Choose a Folder and loop a sub

Thread Information

Users Browsing this Thread

Similar Threads

Choose a Folder and Loop a Sub for all files in the chosen folder

[SOLVED] Choose a folder and loop through all files in the chosen folder

[SOLVED] Loop Through Folder, Create Emails with Sub Folder Names in Subject, Attach files in sub

Choose folder & loop through all files to copy - folder is subfolder in network drive

Loop through a specific folder in OUTLOOk and save the attachments to another folder?

[SOLVED] Save as PDF to a folder I choose

How to choose a folder

Bookmarks

Bookmarks

Posting Permissions