Just another Perl shrine | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
I may be barking up the wrong tree, but I do know that in Access, there are two undocumented features called Application.LoadFromText and Application.SaveAsText which could be used to save "objects" including VBA macros. I can't seem to find these in Excel (when using the Object Browser and choosing "Show Hidden Members"), yet I had thought they existed - or maybe had similarly-named equivalents. I will keep looking (my info dates from <> 2003, so it's pretty well buried), and update this node if I find more info. In the meantime, though, you may want to check The Spreadsheet Page, which is a pretty comprehensive resource for all things Excel and spreadsheet, or perhaps google for microsoft Excel MVPs, and extend your search from there.
Update: Added a phrase clarifying what the two undocumented methods were used for. Update^2: Chip Pearson's page, Programming To The Visual Basic Editor (VBE), may also be of use to you. HTH, planetscapeIn reply to Re: Inserting a Button and a Macro in and excel file
by planetscape
|
|