Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Perl Misc > loading a macro programmatically in excel VBA or perl

Reply
Thread Tools

loading a macro programmatically in excel VBA or perl

 
 
surf
Guest
Posts: n/a
 
      03-22-2006
I am working on a project where a perl script
might create a excel macro, then load it and execute it.
I have not been able to find any info on how to load
a macro programaticaly, either via perl or VBA. I found some info that
seemed to suggest it wasn't possible or not allowed.

If I can't do that, I may have a perl script load configuration data
into a seperate spreadsheet
and use that configuration data to manipulate other spreadsheets via a
more
complex macro.
That may be more complex, but it would mean the macro would
not have to be loaded manualy.

Any suggestions or info appreciated.

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL VBA Caluculation ERROR beersa Java 3 03-16-2006 04:39 PM
VBA to Perl macro conversion Matt Garrish Perl Misc 0 09-17-2004 09:20 PM
Jr. VB/VBA/Excel/XML developer needed for top NYC ibank Patrick Burke XML 0 07-21-2004 06:11 PM
win32::ole and excel VBA macro conversion: SmallScroll Domenico Discepola Perl Misc 10 05-09-2004 02:29 AM
Newbie: Generating indented XML via Excel-VBA Piet XML 0 08-26-2003 08:28 AM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57