I posted a question about this a while back (about a year ago). I never found the answer. I have gone back to tackle a problem I was having then.
I'm executing a macro that refreshes the data (Refresh Data Addon) I imported from an Access DB into Visio. How do I make the Refresh Data Summary...
I wanted to add some clarification to my last post. Are there any command line parameters for the Refresh Data addon like there are for the SaveAsWeb addon such as /silent /folder etc.
Twixman
I need to run a macro every hour. Here is what I need to happen.
1. Open Visio Document
2. Set a variable to the current time (at the moment) + 1 hour (varTime)
3. Set a variable that keeps track of the current time (curTime)
4. Once the curTime = varTime, run Macro.
5. Set varTime for the...
I ended up using the VBA code to delete the certain shapes and refresh the data. My next question: When the data is refreshed, the Refresh Data summary window pops up. Is there a way to automatically click the OK button or even better to make that summary window not show? I don't want to have...
I am currently tracking inventory and when there is one item in a certain space, the object aligns in the dead center, but when there are two or more items in that certain space, the items stack next to each other(using the YAxis), which is a good thing, but the bad thing is all those shapes in...
I figured this out by using the code:
Application.Addons("Refresh Data").Run ""
So I am happy now! I am sure I will have more questions in the future as I learn Visio.
Twixman
Thank you very much! I figured it out after playing with it some. I don't know what I was doing wrong. It works though and that is that matters.
Twixman
I have been learning Visio little by little, and now I want to use VBA to reference what is in a particular cell in a ShapeSheet.
I have a Shape (Sheet.XX) and I put a RUNADDON("Database Refresh") in the Actions section of the ShapeSheet.
How do I reference the Actions section in VBA? I am...
I want to add something to my last post. Is there a way to access the RefreshData in the BuildingPlan Add-ons using something like the menuset or the BuiltInMenus and ItemAtID? I want to know if I can tell Visio in VBA to run the RefreshData add-on. I found how to automatically create an HTML...
I am currently using the database drawing monitor to connect my drawing to an Access database, but is there a way I can call the "Refresh" event in the database monitor from an Access form button? I would prefer not to use the database monitor and just have a button in access that will refresh...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.