Visio Macro Shape Data
Tips. When you link a data row to a shape, a link icon appears next to that row in the External Data window. If you'd like to hide the External Data window, click 'Data' and remove the checkmark from the External Data window. You can make the window reappear by putting the checkmark back. When you import Excel data into Visio, you capture a snapshot of the data at that moment in time.
If you change the underlying Excel workbook, refresh your Visio view by clicking 'Data,' followed by 'Refresh All.' . You can also use Excel data to create shapes if none exist in an empty Visio drawing. Click a shape in the Shapes panel to select it, and drag one or more rows from the External Data window onto an empty area in the diagram. Visio creates the shape you selected and links it to the data.
Visio Macro Shape Data Sheet
I have a number of maps (Office Layouts for various buildings) and have a shape (a rectangle) to indicate where a PC is located in each office. The shape has a name related to the Location field in spiceworks so that I can then hook up the data. The page name reflects the office. So the page name is 'MAINOFFICE' and the 1st shape is 'MAINOFFICE01'.There is a spiceworks community message. BUT the link to his website doesn't work so I cannot get his VBA code.So I am looking for some VBA to basically do the following:1.
Visio Macro Get Shape Data
Connect to the database2. For each page 1.N in the VISIO documentA. Run an SQL - select. from devices where name like '%'+pagename+'%'B.
Visio Macro Shape Data Chart
For each row 1.N in result set do the followingi. Find the shape that matches the Location fieldii. Put text in the shape as the Device Name3. Close the database connectionI can pretty much find VBA that does the VISIO stuff, I just need VBA to connect to the spiceworks DB, run an SQL, and then loop through the result set and grab a field. Hence why an Excel example will suffice.Thanks for all help.RegardsGlen. Hi Glen,the data of spiceworks is stored in an sqlite DataBase.You'll need a driver for sqlite for windows to access it via vba. Take a look here:The database of spiceworks is stored under:Yourspiceworksinstallationdbspiceworksprod.dbI strongly recommend that you make a backup of that db and work with an offline version of it.There is also a plugin for firefox called 'SQLite Manager' which will let you open the database and you can see the structures as well as the data and you can also write querys with it.
Hi Everybody,I worked out a way to get the spiceworks data, SO I thought I would share it (.