Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Ekelund1

    Why does Excel File Size explodes when using VBA?!

    Pvw... that explains it. But is there any way I can execute the procedure Excel runs on open to covert them into shared formulas? Or is there another way to write the formulas so that they are saved as shared formulas?? Rob... yes I know and in the much more advanced code all formulas are...
  2. Ekelund1

    Why does Excel File Size explodes when using VBA?!

    Didn't help I am affraid! Any other suggestions?
  3. Ekelund1

    Why does Excel File Size explodes when using VBA?!

    Exactly - in this example it is only 20K bigger. Nut in the real model we are talking a file of 60 MB which is reduced to 5 MB!!! See the problem?? There must be a way to trigger the same procedure that reduces the file after copy or close,open,save agin?!
  4. Ekelund1

    Why does Excel File Size explodes when using VBA?!

    Ekelund1 (TechnicalUser) Nov 9, 2003 I have experienced some problems with writting formulas in visual basic for application in Excel. I have a rather large spreadsheet which is automated with visual basic modules. The problem is when we write the formulas to the spreadsheets in the VB module...
  5. Ekelund1

    Why does Excel File Size explodes when using VBA?!

    I have experienced some problems with writting formulas in visual basic for application in Excel. I have a rather large spreadsheet which is automated with visual basic modules. The problem is when we write the formulas to the spreadsheets in the VB module the spreadsheet file ends up being...

Part and Inventory Search

Back
Top