Re: $$Excel-Macros$$ Need urgent help on macro error.

2013-08-19 Thread Shrinivas Shevde
Dear Indarjit Can you share a file with me because I have the same work Regards Shrinivas On Mon, Aug 19, 2013 at 2:33 PM, Indrajit $nai wrote: > Thanks a lot to both of you. > > You guys are simply awesome :) > > > On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi wrote: > >> add below "M

Re: $$Excel-Macros$$ Need urgent help on macro error.

2013-08-19 Thread Indrajit $nai
Thanks a lot to both of you. You guys are simply awesome :) On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi wrote: > add below "Microsoft Scripting Runtime" library from tool-->reference > > > -- > *From:* Indrajit $nai > *To:* excel-macros@googlegroups.

Re: $$Excel-Macros$$ Need urgent help on macro error.

2013-08-19 Thread ravinder negi
add below "Microsoft Scripting  Runtime" library from tool-->reference From: Indrajit $nai To: excel-macros@googlegroups.com Sent: Monday, August 19, 2013 4:08 AM Subject: $$Excel-Macros$$ Need urgent help on macro error. Hi All, Kindly find attached the

Re: $$Excel-Macros$$ Need urgent help on macro error.

2013-08-18 Thread De Premor
Try to add this Dim FSO as Object Then replace your line code to : Set FSO = CreateObject("Scripting.FileSystemObject") On 19-08-2013 5:38, Indrajit $nai wrote: Hi All, Kindly find attached the macro based data collection file. But when I am running the macro it's showing the some error. K