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  

VBA/Visio course recommendation?



 
 
Thread Tools Display Modes
  #1  
Old August 29th, 2008, 04:44 PM posted to microsoft.public.visio.general
Paul
external usenet poster
 
Posts: 406
Default VBA/Visio course recommendation?

I learned my Visio on the streets, which means by banging around. Not
much use of the stencils except when I need a shape. Trial and error
on the interconnect types, and connection handles.

I want to take a VBA course because it would add a lot of value in the
environment of MS Windows applications. I suspect that I should try
to lean it toward Visio first, and Excel second. The combination of
Visio and VBA seems quite rare. Would anyone have suggestions? Any
special considerations to keep in mind due to the hole-filled
knowledge of Visio, as learned by banging around?

Thanks.
  #2  
Old August 30th, 2008, 03:01 AM posted to microsoft.public.visio.general
WapperDude
external usenet poster
 
Posts: 589
Default VBA/Visio course recommendation?

Hey Paul --
Unfortunately, there isn't a nice text for Visio VBA as there is for Excel.
I'll refer you to an answer posted in the Developer section, subject is:
is there a book for macros in visio 2003?.

I've seen similar posts to yours, and the common answer seems to be the same
as in the post above, basically, trial by fire, and when stumped, ask for
help in a forum. Part of the problem is Visio offers much more breadth in
this arena than say Excel, and, Visio isn't quite as stable in my opinion.
Some quite a bit can change from release to release. But, if your looking to
do VBA in Excel, my recommendation is the current text by John Walkenbach.

Wapperdude



"Paul" wrote:

I learned my Visio on the streets, which means by banging around. Not
much use of the stencils except when I need a shape. Trial and error
on the interconnect types, and connection handles.

I want to take a VBA course because it would add a lot of value in the
environment of MS Windows applications. I suspect that I should try
to lean it toward Visio first, and Excel second. The combination of
Visio and VBA seems quite rare. Would anyone have suggestions? Any
special considerations to keep in mind due to the hole-filled
knowledge of Visio, as learned by banging around?

Thanks.

  #3  
Old August 30th, 2008, 12:35 PM posted to microsoft.public.visio.general
John... Visio MVP
external usenet poster
 
Posts: 900
Default VBA/Visio course recommendation?

DVS has been the standard starting point for Visio development since it was
first released. The examples were in VB, when Visio was the first non
Microsoft product to fully implement VBA, the examples in DVS were in VBA.
Originally it was a blue book, then a PDF and it's final incarnation was as
a Microsoft Press book (and a set of MSDN webpages).

So what is DVS. Originally it was Developing Visio Shapes, then renamed
Developing Visio Solutions, then Developing (Microsoft) Visio Solutions. For
those who have bought Graham Wideman's book, the unofficial name of the DVS
book is Da Very Start. ;-)

So, find a copy of Visio.pdf from an older version of Visio, buy the MS
press book, or visit the MSDN website. Though the book was released for
Visio 2002 and the pdfs are getting long in the tooth, more than 90% of the
information is still applicable to Visio 2007. Hopefully the book will be
updated for the next version of Visio.

Oh, I almost forgot, David Parker's book covers Data graphics, something
that was included in Visio 2007.

(We have also been bribing Graham to update his VIsio 2002 book)

John... Visio MVP

"WapperDude" wrote in message
...
Hey Paul --
Unfortunately, there isn't a nice text for Visio VBA as there is for
Excel.
I'll refer you to an answer posted in the Developer section, subject is:

is there a book for macros in visio 2003?.

I've seen similar posts to yours, and the common answer seems to be the
same
as in the post above, basically, trial by fire, and when stumped, ask for
help in a forum. Part of the problem is Visio offers much more breadth in
this arena than say Excel, and, Visio isn't quite as stable in my opinion.
Some quite a bit can change from release to release. But, if your looking
to
do VBA in Excel, my recommendation is the current text by John Walkenbach.

Wapperdude



"Paul" wrote:

I learned my Visio on the streets, which means by banging around. Not
much use of the stencils except when I need a shape. Trial and error
on the interconnect types, and connection handles.

I want to take a VBA course because it would add a lot of value in the
environment of MS Windows applications. I suspect that I should try
to lean it toward Visio first, and Excel second. The combination of
Visio and VBA seems quite rare. Would anyone have suggestions? Any
special considerations to keep in mind due to the hole-filled
knowledge of Visio, as learned by banging around?

Thanks.



  #4  
Old August 30th, 2008, 07:37 PM posted to microsoft.public.visio.general
WapperDude
external usenet poster
 
Posts: 589
Default VBA/Visio course recommendation?

Interesting comment about DVS. It rang a bell, and I searched through my
files of antiquity, and yes, I have a paperback book, Developing Visio
Solutions. It came with Visio Technical 4.1. No author though. Seems to
cover much or most of the basic stuff. The following link will take you to
the website version,
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx, which is
under V2002. See my topic referal in 1st post, which includes John's website
-- has a ton of examples.!


"John... Visio MVP" wrote:

DVS has been the standard starting point for Visio development since it was
first released. The examples were in VB, when Visio was the first non
Microsoft product to fully implement VBA, the examples in DVS were in VBA.
Originally it was a blue book, then a PDF and it's final incarnation was as
a Microsoft Press book (and a set of MSDN webpages).

So what is DVS. Originally it was Developing Visio Shapes, then renamed
Developing Visio Solutions, then Developing (Microsoft) Visio Solutions. For
those who have bought Graham Wideman's book, the unofficial name of the DVS
book is Da Very Start. ;-)

So, find a copy of Visio.pdf from an older version of Visio, buy the MS
press book, or visit the MSDN website. Though the book was released for
Visio 2002 and the pdfs are getting long in the tooth, more than 90% of the
information is still applicable to Visio 2007. Hopefully the book will be
updated for the next version of Visio.

Oh, I almost forgot, David Parker's book covers Data graphics, something
that was included in Visio 2007.

(We have also been bribing Graham to update his VIsio 2002 book)

John... Visio MVP

"WapperDude" wrote in message
...
Hey Paul --
Unfortunately, there isn't a nice text for Visio VBA as there is for
Excel.
I'll refer you to an answer posted in the Developer section, subject is:

is there a book for macros in visio 2003?.

I've seen similar posts to yours, and the common answer seems to be the
same
as in the post above, basically, trial by fire, and when stumped, ask for
help in a forum. Part of the problem is Visio offers much more breadth in
this arena than say Excel, and, Visio isn't quite as stable in my opinion.
Some quite a bit can change from release to release. But, if your looking
to
do VBA in Excel, my recommendation is the current text by John Walkenbach.

Wapperdude



"Paul" wrote:

I learned my Visio on the streets, which means by banging around. Not
much use of the stencils except when I need a shape. Trial and error
on the interconnect types, and connection handles.

I want to take a VBA course because it would add a lot of value in the
environment of MS Windows applications. I suspect that I should try
to lean it toward Visio first, and Excel second. The combination of
Visio and VBA seems quite rare. Would anyone have suggestions? Any
special considerations to keep in mind due to the hole-filled
knowledge of Visio, as learned by banging around?

Thanks.



  #5  
Old August 30th, 2008, 08:42 PM posted to microsoft.public.visio.general
John... Visio MVP
external usenet poster
 
Posts: 900
Default VBA/Visio course recommendation?

I've been hanging around since before version 1, so I am sort of the
unofficial historian. DVS was part of the official manual that came with
Visio, back in the old days when software did come with manuals. The book
was written by the Visio team and Chris Roth, the Visio Guy, had a hand in
it. His name is mentioned in the authors section in the earlier versions,
but that section was dropped by the time the book was updated for 4.1. (and
yes I do have a shelf load of Visio books that came with the product) One of
my early complaints was that the version number did not appear on the spine.

John...

"WapperDude" wrote in message
...
Interesting comment about DVS. It rang a bell, and I searched through my
files of antiquity, and yes, I have a paperback book, Developing Visio
Solutions. It came with Visio Technical 4.1. No author though. Seems to
cover much or most of the basic stuff. The following link will take you
to
the website version,
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx, which is
under V2002. See my topic referal in 1st post, which includes John's
website
-- has a ton of examples.!



  #6  
Old August 30th, 2008, 09:44 PM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default VBA/Visio course recommendation?

John,
You missed that Graham wrote one for the 2003 version as well.
;-)
al

"John... Visio MVP" wrote in message
...
I've been hanging around since before version 1, so I am sort of the
unofficial historian. DVS was part of the official manual that came with
Visio, back in the old days when software did come with manuals. The book
was written by the Visio team and Chris Roth, the Visio Guy, had a hand in
it. His name is mentioned in the authors section in the earlier versions,
but that section was dropped by the time the book was updated for 4.1.
(and yes I do have a shelf load of Visio books that came with the product)
One of my early complaints was that the version number did not appear on
the spine.

John...

"WapperDude" wrote in message
...
Interesting comment about DVS. It rang a bell, and I searched through my
files of antiquity, and yes, I have a paperback book, Developing Visio
Solutions. It came with Visio Technical 4.1. No author though. Seems
to
cover much or most of the basic stuff. The following link will take you
to
the website version,
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx, which
is
under V2002. See my topic referal in 1st post, which includes John's
website
-- has a ton of examples.!




  #7  
Old August 30th, 2008, 10:14 PM posted to microsoft.public.visio.general
John... Visio MVP
external usenet poster
 
Posts: 900
Default VBA/Visio course recommendation?

We were discussing DVS. Graham's books go beyond DVS so they require that
you are acquianted with DVS.

As to Graham's 2003 version, the SIGNED version is sitting within three feet
of this keyboard, next to his other two books. There is also space next to
them for his next edition.

John...

"AlEdlund" wrote in message
...
John,
You missed that Graham wrote one for the 2003 version as well.
;-)
al

"John... Visio MVP" wrote in message
...
I've been hanging around since before version 1, so I am sort of the
unofficial historian. DVS was part of the official manual that came with
Visio, back in the old days when software did come with manuals. The book
was written by the Visio team and Chris Roth, the Visio Guy, had a hand
in it. His name is mentioned in the authors section in the earlier
versions, but that section was dropped by the time the book was updated
for 4.1. (and yes I do have a shelf load of Visio books that came with
the product) One of my early complaints was that the version number did
not appear on the spine.

John...

"WapperDude" wrote in message
...
Interesting comment about DVS. It rang a bell, and I searched through
my
files of antiquity, and yes, I have a paperback book, Developing Visio
Solutions. It came with Visio Technical 4.1. No author though. Seems
to
cover much or most of the basic stuff. The following link will take you
to
the website version,
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx, which
is
under V2002. See my topic referal in 1st post, which includes John's
website
-- has a ton of examples.!






  #8  
Old September 2nd, 2008, 01:07 PM posted to microsoft.public.visio.general
Paul
external usenet poster
 
Posts: 406
Default VBA/Visio course recommendation?

Thanks for the references, Wapper, John, and Al.

Would you know of any actual courses (possibly multilple days) to get
someone jumpstarted? Sitting down with a book presumes realistic
scheduling and scope of mainline activities (which isn't always in
one's control). In the absence of such, it isn't all that fine to be
doing other stuff (or actually, there is, but there are other things
competing for that time!). However, it is OK to take a time-out to
formally get a jumpstart via courses.

If there are no courses that are visio-oriented, what Excel-oriented
course would minimize the gap in getting started in visio? Would it
be overly presumptuous to also have the criteria of looking for a
course for those who haven't yet picked up VBA on the streets of
Excel, and have a intermediate knowledge of Excel as a spreadsheet
rather than a programming tool? I.e. same degree of knowledge depth
as one might have of older spreadsheet programs such as sc on unix,
Quatro, and older applications on the venerable CBM machines....

On Aug 30, 5:14*pm, "John... Visio MVP"
wrote:
We were discussing DVS. Graham's books go beyond DVS so they require that
you are acquianted with DVS.

As to Graham's 2003 version, the SIGNED version is sitting within three feet
of this keyboard, next to his other two books. There is also space next to
them for his next edition.

John...

"AlEdlund" wrote in message

...



John,
You missed that Graham wrote one for the 2003 version as well.
;-)
al


"John... Visio MVP" wrote in message
...
I've been hanging around since before version 1, so I am sort of the
unofficial historian. DVS was part of the official manual that came with
Visio, back in the old days when software did come with manuals. The book
was written by the Visio team and Chris Roth, the Visio Guy, had a hand
in it. His name is mentioned in the authors section in the earlier
versions, but that section was dropped by the time the book was updated
for 4.1. (and yes I do have a shelf load of Visio books that came with
the product) One of my early complaints was that the version number did
not appear on the spine.


John...


"WapperDude" wrote in message
...
Interesting comment about DVS. *It rang a bell, and I searched through
my
files of antiquity, and yes, I have a paperback book, Developing Visio
Solutions. *It came with Visio Technical 4.1. *No author though. *Seems
to
cover much or most of the basic stuff. *The following link will take you
to
the website version,
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx, which
is
under V2002. *See my topic referal in 1st post, which includes John's
website
-- has a ton of examples.!- Hide quoted text -


- Show quoted text -


  #9  
Old September 2nd, 2008, 02:32 PM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default VBA/Visio course recommendation?

IMHO VBA merely provides a framework for describing how to work with
information, the challange is in understanding the knowledge space that
you're working in. Regarding VBA, a standard introductory course to visual
basic should offer all that you need . I haven't seen anyone offer a
combination of visual basic focused on office products. Even the Office
Connections Conference usually focus' on word/excel/powerpoint.

Regarding education relative to Visio, I've seen some consulting firms that
offer it. Visio is a very rich environment with a unique set of features and
functions that should be understood first. Where the four primary books that
John mentioned have some VBA code in them, their primary function is to
first teach Visio. There are numerous examples in these forums of those that
have built "smart shapes" using just the shapesheet within the tool and not
adding a lot of code.

Al

"Paul" wrote in message
...
Thanks for the references, Wapper, John, and Al.

Would you know of any actual courses (possibly multilple days) to get
someone jumpstarted? Sitting down with a book presumes realistic
scheduling and scope of mainline activities (which isn't always in
one's control). In the absence of such, it isn't all that fine to be
doing other stuff (or actually, there is, but there are other things
competing for that time!). However, it is OK to take a time-out to
formally get a jumpstart via courses.

If there are no courses that are visio-oriented, what Excel-oriented
course would minimize the gap in getting started in visio? Would it
be overly presumptuous to also have the criteria of looking for a
course for those who haven't yet picked up VBA on the streets of
Excel, and have a intermediate knowledge of Excel as a spreadsheet
rather than a programming tool? I.e. same degree of knowledge depth
as one might have of older spreadsheet programs such as sc on unix,
Quatro, and older applications on the venerable CBM machines....

On Aug 30, 5:14 pm, "John... Visio MVP"
wrote:
We were discussing DVS. Graham's books go beyond DVS so they require that
you are acquianted with DVS.

As to Graham's 2003 version, the SIGNED version is sitting within three
feet
of this keyboard, next to his other two books. There is also space next to
them for his next edition.

John...

"AlEdlund" wrote in message

...



John,
You missed that Graham wrote one for the 2003 version as well.
;-)
al


"John... Visio MVP" wrote in message
...
I've been hanging around since before version 1, so I am sort of the
unofficial historian. DVS was part of the official manual that came
with
Visio, back in the old days when software did come with manuals. The
book
was written by the Visio team and Chris Roth, the Visio Guy, had a hand
in it. His name is mentioned in the authors section in the earlier
versions, but that section was dropped by the time the book was updated
for 4.1. (and yes I do have a shelf load of Visio books that came with
the product) One of my early complaints was that the version number did
not appear on the spine.


John...


"WapperDude" wrote in message
...
Interesting comment about DVS. It rang a bell, and I searched through
my
files of antiquity, and yes, I have a paperback book, Developing Visio
Solutions. It came with Visio Technical 4.1. No author though. Seems
to
cover much or most of the basic stuff. The following link will take
you
to
the website version,
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx, which
is
under V2002. See my topic referal in 1st post, which includes John's
website
-- has a ton of examples.!- Hide quoted text -


- Show quoted text -


  #10  
Old September 2nd, 2008, 06:34 PM posted to microsoft.public.visio.general
Paul
external usenet poster
 
Posts: 406
Default VBA/Visio course recommendation?

What you say makes much sense, Al. Will seek out a VBA course.

I've tried to track down a PDF copy of "Developing Microsoft Visio
Solutions" to no avail. It would complement the MSDN website quite
nicely, as it is easier to search the whole document for words/
phrases, and presumably has an index. Easier to search than a hard
copy, too (though I have ordered the book). It seems kind of odd that
it isn't online.

On Sep 2, 9:32*am, "AlEdlund" wrote:
IMHO VBA merely provides a framework for describing how to work with
information, the challange is in understanding the knowledge space that
you're working in. Regarding VBA, a standard introductory course to visual
basic should offer all that you need . I haven't seen anyone offer a
combination of visual basic focused on office products. Even the Office
Connections Conference usually focus' on word/excel/powerpoint.

Regarding education relative to Visio, I've seen some consulting firms that
offer it. Visio is a very rich environment with a unique set of features and
functions that should be understood first. Where the four primary books that
John mentioned have some VBA code in them, their primary function is to
first teach Visio. There are numerous examples in these forums of those that
have built "smart shapes" using just the shapesheet within the tool and not
adding a lot of code.

Al

"Paul" wrote in message

...
Thanks for the references, Wapper, John, and Al.

Would you know of any actual courses (possibly multilple days) to get
someone jumpstarted? *Sitting down with a book presumes realistic
scheduling and scope of mainline activities (which isn't always in
one's control). *In the absence of such, it isn't all that fine to be
doing other stuff (or actually, there is, but there are other things
competing for that time!). *However, it is OK to take a time-out to
formally get a jumpstart via courses.

If there are no courses that are visio-oriented, what Excel-oriented
course would minimize the gap in getting started in visio? *Would it
be overly presumptuous to also have the criteria of looking for a
course for those who haven't yet picked up VBA on the streets of
Excel, and have a intermediate knowledge of Excel as a spreadsheet
rather than a programming tool? *I.e. same degree of knowledge depth
as one might have of older spreadsheet programs such as sc on unix,
Quatro, and older applications on the venerable CBM machines....

On Aug 30, 5:14 pm, "John... Visio MVP"
wrote:



We were discussing DVS. Graham's books go beyond DVS so they require that
you are acquianted with DVS.


As to Graham's 2003 version, the SIGNED version is sitting within three
feet
of this keyboard, next to his other two books. There is also space next to
them for his next edition.


John...


"AlEdlund" wrote in message


...


John,
You missed that Graham wrote one for the 2003 version as well.
;-)
al


"John... Visio MVP" wrote in message
...
I've been hanging around since before version 1, so I am sort of the
unofficial historian. DVS was part of the official manual that came
with
Visio, back in the old days when software did come with manuals. The
book
was written by the Visio team and Chris Roth, the Visio Guy, had a hand
in it. His name is mentioned in the authors section in the earlier
versions, but that section was dropped by the time the book was updated
for 4.1. (and yes I do have a shelf load of Visio books that came with
the product) One of my early complaints was that the version number did
not appear on the spine.


John...


"WapperDude" wrote in message
...
Interesting comment about DVS. It rang a bell, and I searched through
my
files of antiquity, and yes, I have a paperback book, Developing Visio
Solutions. It came with Visio Technical 4.1. No author though. Seems
to
cover much or most of the basic stuff. The following link will take
you
to
the website version,
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx, which
is
under V2002. See my topic referal in 1st post, which includes John's
website
-- has a ton of examples.!

 




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 07:30 AM.


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