Anyone can comment, so leave your views

Tuesday, August 18, 2009

MS Office excel VBA features

Instead of buttons: nice of a link could point to a macro. Click here to do this ... Can be dynamic create in scripts too.
 
Macro Security : keep a Code_Last_Modified_Date - if user trusts a code then a check box not to prompt to trust same file until code is modified.
 
Code Location: Keep code in a linked file - so can change classes etc via version control - in one go instead of having to go to the editor and pasting there. Anyway will be used by developers and when we distribute its our responsibility to tell the users to keep additional files in correct relative folders, or give an installer as with other programs.
 
Microsoft Office Macros are very powerful - and should be encouraged and new features added all the time.
 

G
 
Forum
Ads by google:











Source code, testing article - one stop shop Software applications written in Java for cell phones, PHP, Java Dot net, PHP & Perl for the web and Vb6, Java, VB6, Perl and Excel VBA for the desktop .

- Tushar G Kapila
Bangalore India 2007 © Remaining page can be removed if you save on your pc or server.

Contributors