Re: $$Excel-Macros$$ Reduce the Size

2011-12-13 Thread Jitendra singh
-- > *From:* Jitendra singh > *To:* excel-macros@googlegroups.com > *Sent:* Tue, December 13, 2011 1:25:58 PM > *Subject:* $$Excel-Macros$$ Reduce the Size > > Dear all expert, > > Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce the

Re: $$Excel-Macros$$ Reduce the Size

2011-12-13 Thread Paul Schreiner
long as ever you can.” - John Wesley - From: Jitendra singh To: excel-macros@googlegroups.com Sent: Tue, December 13, 2011 1:25:58 PM Subject: $$Excel-Macros$$ Reduce the Size Dear all expert, Too much data in my Excel

Re: $$Excel-Macros$$ Reduce the Size

2011-12-13 Thread Nikhil Shah
Dear Jitendra, Pl visit following URL http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html Regards Nikhil Shah On Tue, Dec 13, 2011 at 11:55 PM, Jitendra singh wrote: > Dear all expert, > > Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce the > Size withou

$$Excel-Macros$$ Reduce the Size

2011-12-13 Thread Jitendra singh
Dear all expert, Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce the Size without touch data. Thanks and Regards Jitendra Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgen

Re: $$Excel-Macros$$ reduce the size of code

2011-02-14 Thread Rajesh K R
EMP REG").Select >>            Range("B2:O200").Select >>            Selection.Copy >>            Sheets(ShtName).Select >>            Application.Run "Compare.XLS!Module2.Import_fromregister" >>        End If >>    Next M >>

Re: $$Excel-Macros$$ reduce the size of code

2011-02-14 Thread Paul Schreiner
esh K R To: excel-macros@googlegroups.com Sent: Mon, February 14, 2011 9:29:32 AM Subject: Re: $$Excel-Macros$$ reduce the size of code Hi Paul, Thank you very much for your quick replies .Due to my lack of knowledge in vba I can't understand the code well .So I am attaching a project what I

Re: $$Excel-Macros$$ reduce the size of code

2011-02-14 Thread Paul Schreiner
ion.Run "Compare.XLS!Module2.Import_fromregister"     End If     Next M End Sub Paul From: Rajesh Kainikkara To: MS EXCEL AND VBA MACROS Sent: Sun, February 13, 2011 11:17:50 AM Subject: $$Excel-Macros$$ reduce the size of code Hi I have a

$$Excel-Macros$$ reduce the size of code

2011-02-13 Thread Rajesh Kainikkara
Hi I have a workbook which contain 15 sheets ,sheet1 is the data of January, sheet2 is February and so on, the last 3 sheet have some data for comparison.I am using a macro code to copy the data like this Sub Update_sheet_April() If Sheets("APRIL").Range("b5") = 0 Then Application.ScreenUp