kenuk110
asked on
Have SQL data populate a grid in Visio
Hi,
This is a long shot but I wanted to know if it was possible to do the following;
We have supermarkets that we work in and we 'floor plan' these before we start working and map out where all the locations of the blocks are, it's a handy tool for our guys to find what they need to in the stores. What I would like to do is have the grid on a visio page so; A1-ZZ99 (for instance) and if I have an entry in my DB for grid reference B20 (for instance), it colours that little block in in whatever I choose, or highlights it somehow.
This is just a question to you all to see if it's possible to do this type of thing and if not do you know anyway this could be achieved?
Any help would be much appreciated.
Regards,
Ken
This is a long shot but I wanted to know if it was possible to do the following;
We have supermarkets that we work in and we 'floor plan' these before we start working and map out where all the locations of the blocks are, it's a handy tool for our guys to find what they need to in the stores. What I would like to do is have the grid on a visio page so; A1-ZZ99 (for instance) and if I have an entry in my DB for grid reference B20 (for instance), it colours that little block in in whatever I choose, or highlights it somehow.
This is just a question to you all to see if it's possible to do this type of thing and if not do you know anyway this could be achieved?
Any help would be much appreciated.
Regards,
Ken
ASKER
Hi Scott, thats brilliant, that's pretty much what I need!
I think what I'll need to do is create a page with a box in each grid then try to link it as you have done. I'll use the same file as you so I can send you it back if I get a little stuck!
Thanks for the response.
Ken
I think what I'll need to do is create a page with a box in each grid then try to link it as you have done. I'll use the same file as you so I can send you it back if I get a little stuck!
Thanks for the response.
Ken
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help, really appreciate it.
I've attached a very simple example of something similar that uses the data linking features of Visio Professional. It happens to be a seating chart on which each cubicle changes appearance when the person sitting there needs help. The Visio drawing is controlled by data in the Excel workbook. To see how this example works:
C:\temp\Needs Help\
NOTE: you must use this exact folder name for this example.
Regards,
Scott
Needs-Help-Seating-Chart.zip