0

I recently wrote a form in VBA for Outlook and saved it to my personal form folder.

Now this form should get exported in a userfriendly fashion. What is the best practise here?

I know that you can go to File -> Export file... in VBA, but this seems to have caused some problems in the past and doesn't seem very intuitive to use both the frm and the frx files.

The form is supposed to be accessed by employees to book their holiday.

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45
Strapotheker
  • 13
  • 2
  • Why not just share the project? https://stackoverflow.com/questions/233702/where-does-outlook-store-the-vba-code-files#:~:text=All%20Outlook%20macros%20are%20stored,hidden%20folder%20on%20most%20systems. – braX Nov 02 '22 at 14:42

1 Answers1

0

That is COM add-ins were invented for. They are designed to be installed on multiple machines and users. VBA macros are not designed for transferring the code - the infrastructure doesn't provide anything for moving solutions automatically like you could do in case of COM add-ins. You need have do that manually in VBA.

If you consider moving your solution to the add-in rails, see Walkthrough: Create your first VSTO Add-in for Outlook to get started quickly. You may choose VB.NET which has a similar syntax with VBA.

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45