Camar tool solution

[rinku261]

Hi I am using Camara tool images in my excel sheets (100+).....and it is making my excel very slow i knw camara tool is really a giant resourse eater ...is there any way by which we can get a sloution of it without compromising on linked pic(Camara tool)..........MAY b by increasing excel virtual memory help ......i am just gueesssing ....................?????

 

[Glory]

Code the macro to delete the pictures as the macro is initiated, then recreate them when it's finished.

Edit: Use a separate sub to make it easy to call from any macro in your workbook. use a boolean argument so that you can pass "True" and "False" to the separate sub to indicate whether the macro is starting (and the pictures need to be deleted) or ending (and they need to be recreated).

You might try declaring a static collection in the separate sub, a collection that holds the pictures until the sub is rerun... and then empties after the pictures are recreated.

 

[rinku261]

Thanks for answer ...even when i m trying to write a macro and run it ....it becomes very very slow ........

 

[GlennUK]

Hi I am using Camara tool images in my excel sheets (100+).....and it is making my excel very slow i knw camara tool is really a giant resourse eater ...is there any way by which we can get a sloution of it without compromising on linked pic(Camara tool)..........MAY b by increasing excel virtual memory help ......i am just gueesssing ....................?????

Can you describe what you are aiming to do, and what your overall process is? It may be that there is another way to do what you want.

 

[RoryA]

If you use the camera tool a lot it will slow down your workbook (and your code). The only real workaround I know of is by Jan Karel Pieterse and it involves using formulas in the links so that if a controlling cell is 1, the formula just returns "". See his DDoE post here.

 

[rinku261]

Hi There

I Hv gone through the link bt its not wrking for me may be i using in incorrectly.......where do i need to apply the if formula ....

 

[RoryA]

It goes into the formula for the linked picture.

 

[rinku261]

I tried dis but nt able to insert the formula into the linked pic object.............i am nt able to attach the sample file here ...if possible can u sent me a sample of it in an excel. on rohtash.sagar@rediffmail.com