Add ins

[LisaGreen]

Hello everyone!

I'm not sure if this belongs in this section or the different application sections so If I've got it wrong I apologise in advance.

I'm trying to get together instructions to set up a VBA add in in Excel Word Powerpoint and Access.

I've googled a lot but found nothing definitive for access or powerpoint.

Is it possible people could either outline the steps for me or maybe post any links for me please?

TIA
Lisa

[HansV]

Would you like to create the add-ins within the Office applications themselves, or using Visual Studio?

For PowerPoint add-ins, see the links in: Creating and Installing Add-ins, Toolbars, Buttons

For Access, there is a tutorial that starts at Creating a Simple Microsoft Access Add-In, but it is geared towards Access 2003 and earlier.

[LisaGreen]

Not using VS if possible. But having said that, do you know if it would be possible using the free VS? I think that's 2013 community thing... not sure.

I found that link for access but as you mention, it's for an earlier version of access. I was looking for something a little more up to date. I'm using office 2016 here. That would be perfect Hans!

Regards
Lisa

[HansV]

See Create VSTO Add-ins for Office by using Visual Studio

I have no experience, nor knowledge on this subject.

[LisaGreen]

Thank you Hans! I'm going to look at that now night owl that I am!

Lisa

[Jay Freedman]

You probably already know this:

For a VBA add-in in Word, create the macro in a .dotm template and store that template in the folder %appdata%\Microsoft\Word\STARTUP. You can have many templates there, although loading them may increase Word's startup time.

For a VBA add-in in Excel, create the macro in the file Personal.XLSB and store that file in the folder %appdata%\Microsoft\Excel\XLSTART.

[LisaGreen]

Thank you Jay!!

Lisa

[Rudi]

    
Some links:

- Excel add-ins overview
- Walkthrough: Create your first VSTO Add-in for Excel
- Simple add-in tutorial

- Word add-ins overview
- Walkthrough: Create your first VSTO Add-in for Word

- PowerPoint add-ins
- Walkthrough: Create your first VSTO Add-in for PowerPoint
- Build your first PowerPoint add-in

[Jan Karel Pieterse]

I have loads of info on add-ins:

https://jkp-ads.com/Articles/buildexceladdin.asp" onclick="window.open(this.href);return false;
https://jkp-ads.com/Articles/DistributeMacro00.asp" onclick="window.open(this.href);return false;
https://jkp-ads.com/Articles/FixLinks2UDF.asp" onclick="window.open(this.href);return false;
https://jkp-ads.com/Articles/UpdateAnAddin.asp" onclick="window.open(this.href);return false;
https://jkp-ads.com/Articles/keepuserformontop.asp" onclick="window.open(this.href);return false;
https://jkp-ads.com/Articles/Excel-Add- ... o-load.asp" onclick="window.open(this.href);return false;

https://jkp-ads.com/Articles/AddinsAndSetupFactory.asp" onclick="window.open(this.href);return false;

[LisaGreen]

JKP!!!

OMG!! I'm going to take my time with this!!! Still haven't found very much for Access to this point.

Thank you Jan Karel!!!!

Lisa

[LisaGreen]

Thank you Rudi!

Lisa

[LisaGreen]

Hello everyone,

I've sort of cross posted on WOW but just asked about how to set up an access add-in.

What is it with access!?? Apart from the link Hans gave, which addresses V2003, I can't find anything about add-ins. BUT! There are plenty of access add-ins to download!


Lisa

[HansV]

I suspect that Microsoft wants us to develop add-ins in Visual Studio with VSTO.

[LisaGreen]

Hans,

Hmmmmmm from what I've read while googling for add-ins for 8 1/2 days, not even that!

They possibly want us to go to script lab / office add-ins.

Lisa