All geek questions in one place

Practical limitations of Word / VBA applications

The company I work for has an internally developed Word2003 / VBA application, which already has a size of about 6.5 mb, and they want to add another 200+ macros to it, which, I believe, will make it much larger, I think it's a terrible idea, but finding resources to repurpose a tool using VSTO or some other more useful technology will be a problem.

So here are my questions:

  • Well, as a last resort, have a business dependency on a Word template with macros that is 10, 20, or 30 mbar?
  • Is there a specific Microsoft or suggested limit (file size, number of macros, level of difficulty) to how far you can / should extend the VBA application before it becomes unusable?

In essence, I would like to know if there is a good technical reason to bite a bullet and remake this application.

+4
source share
3 answers

This will give you the limitations of Word 2003 / VBA: The limitations of the operating mode and specifications in Word . Given that the limit is 150 macros, it doesn't look like they can continue to use this to add 200+ macros.

+7
source

I would look at porting some of these macros to an add-in. Nevertheless, VBA, but can be used for several files and receives code far from the data (which is usually a programming victory).

- Edit-- Regarding scaling and size ... I think it's all in the design. If it is put together, productivity will suffer. The file can handle the overall size, but there are restrictions on the size of the module (64k) and the size of the procedure (not well documented, but the IDE will tell you when you hit it). If you start to approach 30 MB of text, then you will want to find another solution.

You did not mention security, but since it is related to medical information, it should be said that VBA is unsafe. If the code is proprietary and offered to external sources, you can wrap it in .xll and install it as an add-on. It can also provide faster lead times.

+2
source

I know this is an old question. But it seems unlikely that there were 200+ macros. If they have not performed each function or created a separate macro, instead of putting them in one macro.

You can write a VBA application in a word macro. But that does not sound so. This is just a bunch of macros.

0
source

Source: https://habr.com/ru/post/1299366/

More articles:


All Articles