Re: VBA for serious development
Tech-Archive recommends: Fix windows errors by optimizing your registry
I have an app with about 75k loc in VBA. It is mainly in Access but
also automates Word to within an inch of its life. I am wondering how
to move this app forward into the future.
My concern about the .NET etchnologies (apart from the fact that I know
very little about them!), is that they still seem to be going through a
large amount of change. Ie. you are possibly coding to a moving target.
To get some feel for this, read the relevant blogs at blogs/msdn.com;
these really key you in to what is happening at microsoft.
None the less, at this stage, I personally feel that it would be
difficult to justify creating a large /new/ app in VBA; as opposed to
making a strategic decision to continue enhancing an old app.
Just my 2c, I'll be interested in what others have to say.
HTH,
TC
.
Relevant Pages
- Collections and IDs (Access and VBA)
... I am developping an app in VBA with Access. ... But the objects of class B don't come from a database. ... what key should I use to identify them and store them into (and retrieve them from) the collection in the class A object? ... So in fact, my main concern is how to create a unique ID from VBA code to use the ID as a key when adding them into the collection, and how to keep the ID when looking for retrieving the object from the same collection? ...
(microsoft.public.office.developer.vba) - Re: VBA Error #429: ActiveX component cant create object
... I have a VBA procedure which sends an email. ... Late binding means you can safely remove the reference and only have ... an error when the app executes lines of code in question. ... Tony Toews, Microsoft Access MVP ...
(microsoft.public.access.modulesdaovba) - Re: category Axis
... Most times, that's true for VBA. ... and see what happens when you try to shut your app down - the ... erratic-seeming problems with file handles, recordsets, connections, locks, ... In your DISPOSE method, add code to clean up any object variables your class ...
(microsoft.public.excel.charting) - VBA - XML... which do I choose
... I'd like to write a app which will extend Outlook's tasks to include ... I could write VBA in Outlook itself and modify its forms, ... I could write HTML with VBScript or Java routines, ...
(microsoft.public.office.developer.outlook.vba) - Re: Visual Basic 6.0 on 64-Bit system
... My problem is not really with VB6 itself but VBA macros within Excel. ... Office is still a 32 bit app, so your 32 bit app calling it should all work fine. ...
(microsoft.public.vb.general.discussion) |
|
