> --------------
>> *From: *ashish koul
>> *Sender: *excel-macros@googlegroups.com
>> *Date: *Thu, 3 Nov 2011 13:04:02 +0530
>> *To: *
>> *ReplyTo: *excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ Need to copy of 1st sheet of ev
BlackBerryŽ from Vodafone
> --
> *From: * ashish koul
> *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 3 Nov 2011 13:04:02 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Need to copy of 1st sheet of
> *From: * ashish koul
> *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 3 Nov 2011 13:04:02 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Need to copy of 1st sheet of every
> workbook in a si
: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a
single work book
in which format ur files are saved .xls or xlsx
On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer
wrote:
> Dear Ashish,
>
> I have copied it but when i am running the code it showing error msg pls
> he
in which format ur files are saved .xls or xlsx
On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer
wrote:
> Dear Ashish,
>
> I have copied it but when i am running the code it showing error msg pls
> help.
>
> On 3 November 2011 10:53, ashish koul wrote:
>
>> Sub copy_first_sheet_from_different
Dear Ashish,
I have copied it but when i am running the code it showing error msg pls
help.
On 3 November 2011 10:53, ashish koul wrote:
> Sub copy_first_sheet_from_different_workbooks_to_single()
> Application.DisplayAlerts = False
> Application.ScreenUpdating = False
>
> Dim fld As Object, fi
Sub copy_first_sheet_from_different_workbooks_to_single()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim fld As Object, fil As Object
Dim ask As Workbook, ask2 As Workbook
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Choose the folder"
.InitialFileNam
Hi Sandeep,
Save this attachment in the folder where you have all the workbooks and try
to run the macro (Button) on page 1 of this file.
Hope this helps,
Mrinal
On Wed, Nov 2, 2011 at 2:08 PM, wrote:
> Dear all,
>
> I have many work book in a single folder. I need a macro which if I run
> wi
Dear all,
I have many work book in a single folder. I need a macro which if I run will
copy the 1st sheet of every workbook in a single workbook (though as separate
sheet).
Like if I have 2 workbook viz WB1 and WB2 then I want the 1st worksheet of WB1
as 1st worksheet in a new workbook (say WB
