PC Review


Reply
Thread Tools Rate Thread

How tough is it to convert VBA to Addin

 
 
Addin_Noob
Guest
Posts: n/a
 
      10th Mar 2009
Greetings all,

I have built some pretty nice VBA macros for Outlook 2007. I was wondering
if you could give me some idea on how difficult it will be to convert these
to Addins. Also can I do this with VB 6 or VB .Net 2003?

Maybe some step by step tutorials for converting VBA to an addin or other
references would help.

Sorry for the general question.. Just trying to get a feel for the process
before shelling out the money to buy VS. [I currently have VB 6 and VS .Net
2003 Pro]

-Tim
 
Reply With Quote
 
 
 
 
Ken Slovak - [MVP - Outlook]
Guest
Posts: n/a
 
      10th Mar 2009
VS 2003 uses Framework 1.1, I'd not bother using it these days when far less
buggy versions are out there. VB6 can certainly be used and the conversion
curve is far easier since that and VBA are very closely related.

I've never seen any step by step guide for a conversion, you basically just
implement the IDTExtensibilty interface in your Connect module and the VBA
code can pretty much be copied and pasted into the addin.

You might want to look at the VB6 addin template I have up at
http://www.slovaktech.com/outlook_2007_templates.htm. That gives you a
framework to start with.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Addin_Noob" <(E-Mail Removed)> wrote in message
news:7059E96A-5C88-430A-A492-(E-Mail Removed)...
> Greetings all,
>
> I have built some pretty nice VBA macros for Outlook 2007. I was
> wondering
> if you could give me some idea on how difficult it will be to convert
> these
> to Addins. Also can I do this with VB 6 or VB .Net 2003?
>
> Maybe some step by step tutorials for converting VBA to an addin or other
> references would help.
>
> Sorry for the general question.. Just trying to get a feel for the
> process
> before shelling out the money to buy VS. [I currently have VB 6 and VS
> .Net
> 2003 Pro]
>
> -Tim


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Convert .XLA addin to COM addin Jim Cone Microsoft Excel Discussion 0 29th Feb 2012 09:51 AM
VB6 Com Addin versus VBA Addin meldrum_scotland Microsoft Excel Programming 1 23rd Aug 2008 08:09 PM
Re: Tough proper case challange, help convert entire sentance. John Spencer Microsoft Access Queries 0 1st Dec 2006 02:12 PM
Pls clarify how to call an Addin from another addin using VBA =?Utf-8?B?UHJhYmFrYXI=?= Microsoft Excel Programming 1 11th Jan 2006 10:08 AM
convert whole excel file to vba (tough question?) Florianbur Microsoft Excel Programming 3 21st Jun 2004 10:53 AM


Features
 

Advertising
 

Newsgroups
 


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