Macros?

[Kevin Buchs]

I like to write little VB macros to do various routine text processing steps,
like filling paragraphs.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...aeec-ac921ac9399e&dg=microsoft.public.onenote

 

[Tom S.]

I would press that button a thousand times if I could I have many scripts
in the other MS programs and I miss them in ON.

Tom S.

 

[Erik Sojka (MVP)]

There is an API for OneNote:

http://msdn2.microsoft.com/en-us/office/aa905452.aspx

Do a Google/Live search for "OneNote API".

 

[tshanno]

There is an API for OneNote:

http://msdn2.microsoft.com/en-us/office/aa905452.aspx

Do a Google/Live search for "OneNote API".

Erik,

Thanks for the reply. This is great if you are a developer. Not so
good if you are a user like me and want to call up a built in editor
and bang out a quick VB-type macro in less than an hour like you can
in Word and Excel and Outlook.

I like the flexibility that this feature provides for me but I also
understand that the average user doesn't use this facility as much as
someone like me (not a developer but also more inclined to take time
to customize). In addition I understand that ON is still a young
program and that everything can be done at once. Nevertheless I
certainly do hope that MS manages to get something like this in the
next release. Much of the code must already be there in the other
Office programs so maybe that's a reason to hope.

Tom S.

 

[EMRhelp.org]

Not so good if you are a user like me and want to call up a built in editor
and bang out a quick VB-type macro in less than an hour like you can
in Word and Excel and Outlook.

Nevertheless I
certainly do hope that MS manages to get something like this in the
next release. Much of the code must already be there in the other
Office programs so maybe that's a reason to hope.

Tom S.

I want OneNote VBA as well.
Don't hold your breath. M$ is ditching VBA, the chances of OneNote
ever getting it slim to none.

 

[tshanno]

I want OneNote VBA as well.
Don't hold your breath. M$ is ditching VBA, the chances of OneNote
ever getting it slim to none.

They are ditching it in favor of what? Or are they just ditching
macros/scripts all together?

Tom S.

 

[tshanno]

They are ditching it in favor of what? Or are they just ditching
macros/scripts all together?

Humph. Well, this is what I get for posting without checking things
out. There is a ON VB library. It's accessible through the editor
that comes with the other MS programs. It looks pretty small and
basic but it is there.

I would assume that any script would have to run from my chosen
program (i.e. Outlook in my case for the most part). I guess at some
point I'll take a little time to see what it can do.

Tom S.

 

[Kathy Jacobs]

If you want to see an example of driving OneNote via VBA from Excel, you can
check out Excel VBA to Push Content to OneNote SP1 at
www.mrexcel.com/tip078.shtml - Bill's the co-author of Unleash the Power of
OneNote and he was the first one to come up with a solution

--
Kathy Jacobs, Microsoft MVP OneNote and PowerPoint
Author of Kathy Jacobs on PowerPoint
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Patrick Schmid [MVP]]

VBA hasn't been really updated in several releases. Sure they have
updated the object model of the programs, but VBA itself has stayed the
same (including a pretty stale VBA Editor). VBA is actually not
maintained by the Office division, but rather by the Development
division, which has gone .NET a long time ago and ditched VB/VBA. VBA
will be eventually replaced by Visual Studio Tools for Applications
(VSTA). VSTA is like VBA a script/macro system, but based on the .NET
framework.
The problem for Office is that the change from VBA to VSTA wouldn't be
seamless/automatic for users, and therefore this change would be a major
backwards compatibility issue. I'd say that Office is probably very
reluctant to make the change because of that. However, they are not
going to add VBA to OneNote at a time when VBA is a major legacy issue
for them. Note that the next version of Office for Mac does not have VBA
support anymore (they couldn't get it to work after Apple switched to
Intel processors).

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[tshanno]

VBA hasn't been really updated in several releases. Sure they have
updated the object model of the programs, but VBA itself has stayed the
same (including a pretty stale VBA Editor). VBA is actually not
maintained by the Office division, but rather by the Development
division, which has gone .NET a long time ago and ditched VB/VBA. VBA
will be eventually replaced by Visual Studio Tools for Applications
(VSTA). VSTA is like VBA a script/macro system, but based on the .NET
framework.
The problem for Office is that the change from VBA to VSTA wouldn't be
seamless/automatic for users, and therefore this change would be a major
backwards compatibility issue. I'd say that Office is probably very
reluctant to make the change because of that. However, they are not
going to add VBA to OneNote at a time when VBA is a major legacy issue
for them. Note that the next version of Office for Mac does not have VBA
support anymore (they couldn't get it to work after Apple switched to
Intel processors).

Thank you for this.

Have you heard if this means that we will need to buy Visual Studio to
write a script in the future? Or will an editor be built in like it
currently is for VBA? Or is that decided?

Tom S.

 

[Patrick Schmid [MVP]]

VSTA is the direct successor of VBA and is integrated into the apps as
well. So no VS needed.
And in terms of decisions, nothing has been decided on this topic at
all, at least by Office. The development group sees VSTA as successor of
VBA, so it seems natural that VBA will eventually be succeeded by it.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[EMRhelp.org]

VSTA is the direct successor of VBA and is integrated into the apps as
well. So no VS needed.
And in terms of decisions, nothing has been decided on this topic at
all, at least by Office. The development group sees VSTA as successor of
VBA, so it seems natural that VBA will eventually be succeeded by it.

Patrick Schmid [OneNote MVP]
--------------http://pschmid.net
***
Office 2007 RTM Issues:http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007:http://pschmid.net/office2007/customize
RibbonCustomizer Add-In:http://pschmid.net/office2007/ribboncustomizer
OneNote 2007:http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog:http://pschmid.net/blog/feed

Thank you for this.

Have you heard if this means that we will need to buy Visual Studio to
write a script in the future? Or will an editor be built in like it
currently is for VBA? Or is that decided?

Tom S.- Hide quoted text -

- Show quoted text -

It would be nice to have VBA until Visual Studio Tools for
Applications (VSTA) is implemented in OneNote 2007.

 

[Patrick Schmid [MVP]]

It would be nice to have VBA until Visual Studio Tools for

Applications (VSTA) is implemented in OneNote 2007.

It would be a nightmare for the OneNote team though to implement it and
then suddenly have to worry about this legacy issues one, two, three
releases down the road.
If they do anything in this regard, it should be VSTA right away.
Of course, nothing will happen for 2007. That's a done deal and no
service pack will change that.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[tshanno]

VSTA is the direct successor of VBA and is integrated into the apps as
well. So no VS needed.
And in terms of decisions, nothing has been decided on this topic at
all, at least by Office. The development group sees VSTA as successor of
VBA, so it seems natural that VBA will eventually be succeeded by it.

I see. Well, I've been poking around and I downloaded Visual Studio
Express for VB. What the hey, its FREE. I'll investigate and see
what can be done. I could download the one for C# as well, as I know
C and its probably about time I started messing with something more
advanced a bit anyway. Maybe I'll learn something.

By the way the description of these tools on the Microsoft website is
a travesty. Lots of flash and dash but no information about what the
applications actually are and what they do. I heard about VS on the
Internet and wanted to know what it is. The website assumes you know
that because they assume you are looking for it for a specific
purpose. I actually had to do a Google search and look at an article
on another website. This isn't the first time this has happened to
me. Is there someone somewhere I should email about this?

Tom S.

 

[Patrick Schmid [MVP]]

No, there isn't anyone. It is really assumed that you know what Visual
Studio is, same as it is assumed you know what Office or Windows are.
In case you didn't find the information, Visual Studio is a development
environment from Microsoft. If you want to write any program for Windows
or add-ins for Office, Visual Studio is one of the best development
tools out there to do that (I'd almost say the best).

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed