Is it possible to link the cell in excel to the size of the shape
Within Visio, you would need VBA code that references the various Excel object, and reads the value
of the correct cell: using code like myValue = xlObject.xlWorkbookObject.xlWorksheetObj.Range("Ad dress").Value Then you could scale the size of the drawing object based on myValue HTH, Bernie MS Excel MVP "reallylost" wrote in message ... Hi! I was hoping i could get some help. I am currently designing a reactor, but my calculations in excel keep changing the final size of the reactor. Is it possible to link the cell in excel to the size of the shape in visio? For instance if the calculations come to a height of 7cm, can visio automatically take this number and adjust the reactor height accordingly Any help is much appreciated Thanks |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com