@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
What format are your report files in?
On Apr 26, 11:46 am, "Chidurala, Shrinivas "
wrote:
> Please help.
>
> Regards,
> Shrinivas
> Citi(r) Global Transaction Services - India
> UB City, Canberra Block, # 24, Vittal Mallya Road,
> Bangalore - 56 00 01.
> Ph - +91-80-4144 6339 / 6340
> Email -
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
Please help.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339 / 6340
Email - shrinivas.chidur...@citi.com
-Original Message-
From: Chidurala, Shrinivas [ICG-GTS]
Sent: Monday,
