A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

VB6 and Visio 2003



 
 
Thread Tools Display Modes
  #1  
Old August 22nd, 2005, 11:42 AM
external usenet poster
 
Posts: n/a
Default VB6 and Visio 2003

Folks:


While browsing through Visio 2003, I noticed a "VB6 Editor" component -
Tools Macro Visual Basic Editor.
I think this is a very useful combination and so I would like to get some
practice with the VB Editor and Visio 2003.
Any references/tutorials/examples deeply appreciated


* What is the purpose of including Visual Basic 6.3 within Visio 2003 ?
* VB6.3 Editor combines with Visio 2003 to accomplish what objectives ?





Thanks,
Jo.





  #2  
Old August 22nd, 2005, 12:17 PM
Chris Roth [ Visio MVP ]
external usenet poster
 
Posts: n/a
Default VB6 and Visio 2003

Some places to look:

John Marshall's (MVP) Site http://www.mvps.org/visio/VBA.htm
Microsoft Visio Developers
http://msdn.microsoft.com/office/understanding/visio/


And my quick Visio 101 in VBA:

To get hold of a shape, try this:

Dim visShp as visio.shape
set visShp = Visio.ActiveWindow.Selection(1) 'assuming a shape is selected

To see the text:

visShp.Text

To get at any property:

visShp.Cells("cellname").Formula ' or .ResultIU

Go to Window Show ShapeSheet to see all the cells that a shape contains.

This should get you started!

--

Hope this helps,

Chris Roth
Visio MVP


JoJo wrote in message ...
Folks:


While browsing through Visio 2003, I noticed a "VB6 Editor" component -
Tools Macro Visual Basic Editor.
I think this is a very useful combination and so I would like to get some
practice with the VB Editor and Visio 2003.
Any references/tutorials/examples deeply appreciated


* What is the purpose of including Visual Basic 6.3 within Visio 2003 ?
* VB6.3 Editor combines with Visio 2003 to accomplish what objectives ?





Thanks,
Jo.







  #3  
Old August 22nd, 2005, 01:27 PM
external usenet poster
 
Posts: n/a
Default VB6 and Visio 2003

Chris:

Thanks for your reply. Here are some additional questions that immediately
pop up.

I would like to use VB6/Visio combo to DISCOVER then DISPLAY various devices
on a network segment using Ping/ICMP/etc.

* How can I accomplish this goal ? Do I need to install a Visio
ActiveX component into my VB application ? Or do I have to use multiple
lines of VB code ?
* Is there a list of Visio ActiveX components to achieve various
objectives ?
* Where is your "quick Visio 101 in VBA" ?
* Can various Visio functions be launched from the Windows Command Prompt
? I am considering the possibility of running a batch file to DISCOVER &
DISPLAY various network segments ?
* Another way of ask the previous question is as follows: Does Visio
have a separate executable file for its DISCOVERY engine ?



Thanks,
John.


"Chris Roth [ Visio MVP ]" wrote in
message ...
Some places to look:

John Marshall's (MVP) Site http://www.mvps.org/visio/VBA.htm
Microsoft Visio Developers
http://msdn.microsoft.com/office/understanding/visio/


And my quick Visio 101 in VBA:

To get hold of a shape, try this:

Dim visShp as visio.shape
set visShp = Visio.ActiveWindow.Selection(1) 'assuming a shape is selected

To see the text:

visShp.Text

To get at any property:

visShp.Cells("cellname").Formula ' or .ResultIU

Go to Window Show ShapeSheet to see all the cells that a shape contains.

This should get you started!

--

Hope this helps,

Chris Roth
Visio MVP


JoJo wrote in message ...
Folks:


While browsing through Visio 2003, I noticed a "VB6 Editor" component -
Tools Macro Visual Basic Editor.
I think this is a very useful combination and so I would like to get some
practice with the VB Editor and Visio 2003.
Any references/tutorials/examples deeply appreciated


* What is the purpose of including Visual Basic 6.3 within Visio 2003
?
* VB6.3 Editor combines with Visio 2003 to accomplish what objectives
?





Thanks,
Jo.









  #4  
Old August 22nd, 2005, 01:35 PM
Al Edlund
external usenet poster
 
Posts: n/a
Default VB6 and Visio 2003

understand it is VBA, not VB 6. There are differences.
al

JoJo wrote in message ...
Folks:


While browsing through Visio 2003, I noticed a "VB6 Editor" component -
Tools Macro Visual Basic Editor.
I think this is a very useful combination and so I would like to get some
practice with the VB Editor and Visio 2003.
Any references/tutorials/examples deeply appreciated


* What is the purpose of including Visual Basic 6.3 within Visio 2003 ?
* VB6.3 Editor combines with Visio 2003 to accomplish what objectives ?





Thanks,
Jo.







  #5  
Old August 22nd, 2005, 03:45 PM
Al Edlund
external usenet poster
 
Posts: n/a
Default VB6 and Visio 2003

Short answer. the visio autodiscovery addon was discontinued in 2002, you
have to write your own. Network discovery algorithms come in many shapes;
from the semi-active reading of arp cache to the active ping of possible
addresses. Address sweeps tend to be discouraged because they look like
denial-of-service attacks.

basic visio programming can be found over here
http://msdn.microsoft.com/library/en...asp?frame=true

you should consider the v2003 sdk
http://msdn.microsoft.com/library/de...HV01083292.asp

some network code that can be adapted to work in visio is over at Randy
Birchs site
http://vbnet.mvps.org/

I personally use some activex controls from Dart
http://www.dart.com/powertcp/

finally saving the information (database) is also important and here is an
example of access/excel integration
http://msdn.microsoft.com/library/de...collection.asp

al



JoJo wrote in message ...
Chris:

Thanks for your reply. Here are some additional questions that
immediately pop up.

I would like to use VB6/Visio combo to DISCOVER then DISPLAY various
devices on a network segment using Ping/ICMP/etc.

* How can I accomplish this goal ? Do I need to install a Visio
ActiveX component into my VB application ? Or do I have to use multiple
lines of VB code ?
* Is there a list of Visio ActiveX components to achieve various
objectives ?
* Where is your "quick Visio 101 in VBA" ?
* Can various Visio functions be launched from the Windows Command
Prompt ? I am considering the possibility of running a batch file to
DISCOVER & DISPLAY various network segments ?
* Another way of ask the previous question is as follows: Does Visio
have a separate executable file for its DISCOVERY engine ?



Thanks,
John.


"Chris Roth [ Visio MVP ]" wrote in
message ...
Some places to look:

John Marshall's (MVP) Site http://www.mvps.org/visio/VBA.htm
Microsoft Visio Developers
http://msdn.microsoft.com/office/understanding/visio/


And my quick Visio 101 in VBA:

To get hold of a shape, try this:

Dim visShp as visio.shape
set visShp = Visio.ActiveWindow.Selection(1) 'assuming a shape is
selected

To see the text:

visShp.Text

To get at any property:

visShp.Cells("cellname").Formula ' or .ResultIU

Go to Window Show ShapeSheet to see all the cells that a shape
contains.

This should get you started!

--

Hope this helps,

Chris Roth
Visio MVP


JoJo wrote in message ...
Folks:


While browsing through Visio 2003, I noticed a "VB6 Editor" component -
Tools Macro Visual Basic Editor.
I think this is a very useful combination and so I would like to get
some practice with the VB Editor and Visio 2003.
Any references/tutorials/examples deeply appreciated


* What is the purpose of including Visual Basic 6.3 within Visio 2003
?
* VB6.3 Editor combines with Visio 2003 to accomplish what objectives
?





Thanks,
Jo.











  #6  
Old August 25th, 2005, 01:33 AM
external usenet poster
 
Posts: n/a
Default Differences between VBA and VB6

Al Edlund:


What are the differences between VBA (found in Visio 2002) and VB6 ?
My goal is to be able to use Visual Basic to accomplish various tasks
(network discovery, etc) in Visio
Any tutorials/references/links deeply appreciated.


Thanks,
John.

"Al Edlund" wrote in message
...
understand it is VBA, not VB 6. There are differences.
al

JoJo wrote in message ...
Folks:


While browsing through Visio 2003, I noticed a "VB6 Editor" component -
Tools Macro Visual Basic Editor.
I think this is a very useful combination and so I would like to get some
practice with the VB Editor and Visio 2003.
Any references/tutorials/examples deeply appreciated


* What is the purpose of including Visual Basic 6.3 within Visio 2003
?
* VB6.3 Editor combines with Visio 2003 to accomplish what objectives
?





Thanks,
Jo.









  #7  
Old August 25th, 2005, 01:22 PM
Al Edlund
external usenet poster
 
Posts: n/a
Default Differences between VBA and VB6

I gave a couple of references in the previous append. this from msdn,
al

Visual Basic is the senior member of the family of Visual Basic products
that includes Visual Basic for Applications and Visual Basic, Scripting
Edition (VBScript). While most of the code that you write in Visual Basic
can be shared with applications written in Visual Basic for Applications or
VBScript, there are some exceptions.

Compatibility with Visual Basic for Applications
Visual Basic for Applications is a single, common application scripting
language and environment that users and developers can leverage across their
Windows desktop. Visual Basic for Applications is included in Microsoft
Office and other Microsoft applications. It is also licensed to other
software vendors and included in a wide range of products.

Visual Basic for Applications, contained in Vba6.dll, is the underlying
language engine for Visual Basic. This library contains all of the language
elements that are shared by Visual Basic for Applications and Visual Basic.
You can view the elements by selecting VBA from the Library listbox in the
Object Browser. Code written in Visual Basic for Applications is portable to
Visual Basic with the following limitations: Visual Basic for Applications
code that refers to application-specific elements (such as an Microsoft
Excel worksheet) may be ported, provided that they contain a fully qualified
reference and provided that the referenced application exists on the target
machine.

Elements specific to Visual Basic, such as forms and intrinsic controls, are
contained in the type library Vb6.olb (which is also visible in the Object
Browser). In general, code written in Visual Basic is portable to Visual
Basic for Applications as long as it doesnt reference these elements.

For More Information To learn more about Visual Basic for Applications,
visit the Microsoft Web site at http://www.microsoft.com.To learn more about
referencing objects, see "Creating a Reference to an Object" in "Programming
with Components." To learn more about native-code compilation, see
"Compiling Your Project to Native Code" in "More About Programming."

JoJo wrote in message ...
Al Edlund:


What are the differences between VBA (found in Visio 2002) and VB6 ?
My goal is to be able to use Visual Basic to accomplish various tasks
(network discovery, etc) in Visio
Any tutorials/references/links deeply appreciated.


Thanks,
John.

"Al Edlund" wrote in message
...
understand it is VBA, not VB 6. There are differences.
al

JoJo wrote in message ...
Folks:


While browsing through Visio 2003, I noticed a "VB6 Editor" component -
Tools Macro Visual Basic Editor.
I think this is a very useful combination and so I would like to get
some practice with the VB Editor and Visio 2003.
Any references/tutorials/examples deeply appreciated


* What is the purpose of including Visual Basic 6.3 within Visio 2003
?
* VB6.3 Editor combines with Visio 2003 to accomplish what objectives
?





Thanks,
Jo.











 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.