@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: Wednesday, April 27, 2011 12:47 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ RE: Multiple file Formatting
save all work in a directory and run the macro and choose taht directory
Function
save all work in a directory and run the macro and choose taht directory
Function SelectFolder(Optional Title As String, Optional TopFolder _
As String) As String
Dim objShell As New Shell32.Shell
Dim objFolder As Shell32.Folder
Set objFolder = objShell.BrowseForFolder _
(0, Title, 1, TopFolder
Hi Srinivas,
if all the files are under same folder than u can write an macro which opens
each file automatically and then which runs your macro for formatting.
You can use fso file object and then you can open each file in the folder
using the for next where u can call ur macros
Hope this might
