Solved

Best Programming Language for Interacting with MS Word Other than VBA…

Posted on 2011-09-27
8
276 Views
Last Modified: 2012-05-12
Hi All

<Rant> MS Word macro security is driving me nuts.  I have a bunch of macros bundled up and signed with a digital certificate.  I keep getting support calls from people who don't read the message telling them to adjust their macro security settings and think the macros just don't work.  And adding trusted locations etc. is way to difficult for the average word user.  </Rant>

There are a few other issues as well… I'd like to be able to:
- fix bugs without having to modify the entire project and reinstall everything
- add new language without having to reinstall the entire package
- introduce updates from the internet

Most of the functionality the macros provide includes:
- assigning document information
- enforcing formatting rules
- checking for consistency in formatting
- updating cross references
- inserting pictures etc in a consistent way


If I'm not mistaken there are other ways besides using VBA macros to control MS Word…?  

I'm looking for information on what would be a good approach to replacing macros to eliminate current frustrations (or eliminate current frustrations while keeping macros) and also, anticipating that I will need to hire a programmer, what skill set should I be advertising for?

Thanks!
0
Comment
Question by:DrTribos
  • 4
  • 3
8 Comments
 
LVL 37

Accepted Solution

by:
TommySzalapski earned 350 total points
ID: 36714983
Instead of creating macros you can use VSTO (Visual Studio Tools for Office) to create add-ins. There are great because they can be integrated automatically with the menu/ribbon and can be programmed in any of the .NET languages (C#, Visual Basic, Visual C++)

For simple things, vbScript also works well. You can also add the Word libraries in any .NET project and manipulate the Word files from there, but I'm guessing your best bet is the add-in.

You would create your own ribbon/menu category and put all your macros in there. Add-ins do not need macro security since they are installed.
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 36714987
"They are great" not "There are great"
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 36715002
And you would just advertise for someone who can program add-ins for Word.
Anyone who's worth his salt as a programmer and knows C#, Visual Basic, or VBA could figure it all out very quickly too.
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 36715019
re rant - yes, (users only read things when the telephone support isn't available?) adding to trusted sites isn't an obvious thing to do AND it might not be allowed with internal IT regulations.  

I've even had the person responsible for IT at a client telephoning me and asking how do I do that, they couldn't find the setting.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 14

Author Comment

by:DrTribos
ID: 36727338
Hi TommySzalapski  -  Thank you for your comments. "Add-ins do not need macro security" is exactly the information that I need.  

Hi AndyAinscow - Yes, it's a sad day when you have to explain to a clients' IT representative how to add a trusted location or enable macros to run...  in my experience I'd estimate 90% + of people that I've helped could have done it themselves... very few organizations seem to be lock down PCs to the point users are unable to change macro settings or trusted locations....

______

I am guessing that I would need to be prepared to purchase Visual Studio - this seems to come in many flavours ranging in price from ~$350 to 20k! When I go to the MS website to look at the comparison I have given very unhelpful information (comparison seems limited to system requirements!).  Once I have Visual Studio I need to install the VSTO upgrade, seems free?

Questions:
- will the users of the macros / addins require any special infrastructure on their PC (not including MS Word) in order to use them?

- what version of Visual Studio would be suitable - there are so many! The best guidance as to my requirements would be: 'I want to convert all macros to addins' so functionaly does not need to offer more than what I can do in VBA.

Cheers,
0
 
LVL 14

Author Comment

by:DrTribos
ID: 36731938
and then there is something like this... http://netoffice.codeplex.com/
0
 
LVL 37

Assisted Solution

by:TommySzalapski
TommySzalapski earned 350 total points
ID: 36755569
Visual Studio Professional with be all you would need. Yes, the VSTO is a free addition. All the users will have to do is run your install file and it will work.

The link you posted still uses C# or Visual Basic which you might be able to get a non MS compiler for, but the VSTO will be cleaner.
0
 
LVL 14

Author Closing Comment

by:DrTribos
ID: 36805759
TommySzalapski, thanks for your guidance - much appreciated

AndyAinscow, thanks for the rant support  ;-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now