Hi Harish If this is related to excel VBA code, then you can use following which I use generally to fasten the execution of the code.
Speed up code and stop screen flickering: ========================================== Sub NoScreenRePainting() Application.ScreenUpdating=False 'Your code here. Application.ScreenUpdating=True End Sub Preventing calculation while executing code: =================================================== Sub NoCalculations() Application.Calculation = xlCalculationManual 'Your code here. Application.Calculation = xlCalculationAutomatic End Sub Speeding up code if you have Worksheet or Workbook Events. Also stops endless loops in Events =========================================================================================== Sub StopAllEvents() Application.EnableEvents = False 'Your code here. Application.EnableEvents = True End Sub Thanks & Regards, Dilipandey -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jun 4, 2009 at 3:52 PM, Harish Bhati <bhatibablu.ms...@gmail.com>wrote: > Hey Dilip, > > Thanks for reply, but it doesn't work for me. > > I have observed that this is problem with *only *this excel > file.I tried on *different system*(more than 10 system), same problem > occurs.I also tried to save this excel file when no other file was being > used,but same problem was occurred.I concluded that it is not a system > problem. > This excel file has to be distributed widely.So i need a solution > which works on any system. > > I think this problem because of some variable which is used in > macro, but i don't know which variables/methods create this problem. > > > Thanks, > Harish > > > > > On Thu, Jun 4, 2009 at 2:14 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > >> Hi Harish, >> >> Check if this problem occurs only with Excel. If not, then go to Task >> Manager (Alt + Ctrl + Del) and check how many programs are running in >> background and how much is the memory consumption by them. Now you can >> control them as per your needs. >> For windows, Go to run and type "msconfig" and now you can control the >> programs to run automatically or to run in background >> >> Other way could be, check your startup folder and remove the un-wanted >> programs from there. >> If you find issues with this, then Alternatively, you can go to run and >> type "regedit" and search that program and remove it from the machine. >> >> There may be other issues and then there may be other solutions as well. >> Let me know if you have some. >> >> Thanks,. >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> On Tue, Jun 2, 2009 at 5:19 PM, Harish <bhatibablu.ms...@gmail.com>wrote: >> >>> >>> I have a 2 MB workbook containing multiple sheets, formulas. A toolbar >>> have been also implemented and status bar also is being used in VBA >>> code. >>> >>> My problem is that I try to save the excel file, it takes too much >>> time(around 40 sec) in saving. >>> Machine also hang-ups when this excel file is being saved. >>> >>> Initially I thought that Workbook_BeforeSave() takes much time,but >>> after analyzing I came to know that this function also consumes very >>> less time(around 1 sec). >>> >>> Please help me to solve this issue. >>> >>> Thanks in advance, >>> Harish >>> >>> >>> >>> >>> >>> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
