Search results for query: *

The file is an add-in The code is OK I have 512Mb but this is the same on 2Gb computers. The task manager is OK and in any case send excel in background doesn't change the processor status.

Unfortunatelly my problem is not realed to this function. In any case, if you lock the calculation too (application.calculation=xlmanualcalculation) you can reduce more this lenght of time!

Screen update disabled and Manual calculation

I have a big excel file with a lot of macros. This file is slow and the code is not too bad. The interesting thing is that when we send Excel in background during an excel calculation (macro or other), for example if you active an explorer window, excel is "speedster". Do you know the reson? Do...

I need to put some images into an Excel workbook. The problems is that my images are too big and I want to reduce the memory size of the images to reduce the final size of the workbook. I tried to use .width and .height but these commands change the visualization only and the image maintain the...

You aren't the best! Simone

Is It possible to invert a sheet?. I want 65536 columns and 256 rows. Thanks Simone

I use big .xls files with many macros and sometimes Excel write in the Formula bar the cell value or formula in bold character! Why? If this is a memory problems, do you know any procedure to clear or optimize the memory! Thanks Simone

Hi, I made a simple excel file that create a dxf file from x,y and z points. If you want I can send to you this file! Simone