Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Twixman23

    Visio Addon Extras

    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...
  2. Twixman23

    Shapes shifting when I use Refresh Data

    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
  3. Twixman23

    Macro Timer

    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...
  4. Twixman23

    Shapes shifting when I use Refresh Data

    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...
  5. Twixman23

    Shapes shifting when I use Refresh Data

    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...
  6. Twixman23

    How to link to a visio event in Access

    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
  7. Twixman23

    How to reference a shapesheet cell

    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
  8. Twixman23

    How to reference a shapesheet cell

    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...
  9. Twixman23

    How to link to a visio event in Access

    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...
  10. Twixman23

    How to link to a visio event in Access

    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...

Part and Inventory Search

Back
Top