I know there are threads about this in other places. But I have thus far been unable to locate anything on this that is helpful for me. It is a simple sounding task I have: Column A of an Excel Spreadsheet is a list of host names. I need to ping them (done!), grab the returned ip (done!) and...
Excel gets hung?
I have an object in my visio diagram. From the objects menu (under insert) the microsoft office worksheet object.
I use this to store a lot of information that I use for generating certain images.
Now when my script reads data from the spreadsheet, Excel is opened in the...
Ok. This may not be the BEST way of doing this, but it is what I thought of...
I want to embed several help files and other such information into a visio diagram in the form of an object - wordpad document.
And at specific times, the coding will grab the data from that object, and place it...
I am developing a visio document for my clients. The document is fully automated. There are actually very few drawings that exist on the pages.
One particular page, generated a view of the network Rack they click on.
When this page is generated and loaded everything seems to be fine.
However...
How can i format only the page being viewed currently?
I have figured out how to format the entire document....but this takes a large amount of time.
This is the code i have now (Like i said, it formats all pages)
Application.ActiveDocument.PaperSize = visPaperSizeA3...
I am trying to create a button that i can place on certain pages that the user can click to print out the page they are viewing.
This is a lot harder than orignally expected apparently.
I have tried using
ActiveDocument.PrintOut PrintRange:=visPrintCurrentPage, PrinterName:="XXXXXXXXX"...
My code allows for reports to be generated based on the suers entries and the drawings that have been automated. Its basically an inventory report of all network assets. Thats not important though.
What I am trying to do is save that file to the desktop. The obvious problem with that is that I...
I don't know what I am doing wrong here.
This is my code.
For Count = 0 To lstInventory.ListCount - 1
Printer.Print lstInventory.List(Count)
Next Count
Printer.EndDoc
Everytime I run this I get the error:
Object Required
and it highlights the line
Printer.Print...
This project I have been designing is kinda cool.
Except all my "links" are worthless. I am nto sure what you call it, but when you enter that mode that is entered by hitting "F5" all my icons that are clickable...are now NOT clickable. :(
So much for the perfect project flow. *sobs*
I am using this bit of code to identify what my user is clicking:
ShapeClicked = Visio.ActiveWindow.Selection.Item(1).text
simple enough. the problem is tho, the actual value of this the variable Shapeclicked.
it is [][][][]wan.25[]
i cant use that! how do i get just the wan.25 part?
Ok. Here is what I want to do.
I want to make an visio image clickable (which i have done thru the behavior gump).
Now I want it to run a macro we will call "whatever".
Now what I need to do is have the action of clicking the image pass on to my vba script the text that i have used to...
My visio document executes a large amount of code at start up which causes a long load time. (30s-1m15s, depending on the system) and I was thinking it would be nice to add a splash screen to allow the user to see that the program is actually working and simply inform them that there is a long...
So far, TheInsider has been the most valuable tool I could have ever hoped to have. Here is one more for him or anyone else:
I want to design a "Back" feature for my visio. By "Back" feature I mean something similar to the "Back" button in Internet Explorer. Perhaps even bind it to the...
I am designing something that will be using a large amount of data as variables. And based on user selections, it will be drawing pages to their specifications.
I have decided to do this by using an excel spreadsheet off on its own page to pull data from.
What I need to know is how can I...
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.