Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need an EXPERT in VBA and knowing how to manipulate objects on an excel sheet
Hi,
my problem is that i have sheet on which i have an image. On thi image, I've got "Shapes" which are a part of an other excel sheet grid (They were selected to be the object to import) and i want to writ some content in these Objects by specifying a range or cell where t write in that grid. I can do this but my problem is that whenever i write something in it i have to open the "shape" (so it opens as an other excel file), write then close it... and that is for the 15 shapes I have on my image Doing this for some time usually crash my program because i'm out o memory. my question would be: can i wrtie in these Objects specifying a rang without having to open and close each of them one a after an other???? My code is: ActiveSheet.Shapes("Machine").Select Selection.Verb xlOpen Range("A4").Value = vMachine ActiveWindow.Close ActiveSheet.Shapes("Calandre").Select Selection.Verb xlOpen Range("B3").Value = vCalandre1 Range("B4").Value = vCalandre2 Range("B5").Value = vCalandre3 ActiveWindow.Close ..... and so on! reply if you have any question, need help! Holysou -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need an EXPERT in VBA and knowing how to manipulate objects on an excel sheet
Thx but my problems is a little bigger... the object i inserted is fro
another excel file ... so it's a part of a excel sheet with Header fo the collumn and the borders of the shape. So when i write something in my object i want to give its a range o position where to write in my object without having to open it . Because when i open the object, it opens an other excel file, write i it , then close it... and doing this seems to gradualy fill my memor because the closed excel sheet don't erase them self in the memory or don'T know ...! so if you have another idea or anything else.... or way to erase mermory allocated for excel with commands in vba please respond! Holysou -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete 1 row of objects, not all on sheet Excel 2007 | Excel Discussion (Misc queries) | |||
Knowing the creation date of an excel sheet email attachment | Excel Discussion (Misc queries) | |||
Using Macros to manipulate drawn objects | Excel Discussion (Misc queries) | |||
Excel Error Message: "Cannot shift objects off sheet" | Excel Discussion (Misc queries) | |||
Calling Procedures from another excel sheet by passing objects | Excel Programming |