loading a macro programmatically in excel VBA or perl

Discussion in 'Perl Misc' started by surf, Mar 22, 2006.

  1. surf

    surf Guest

    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.
     
    surf, Mar 22, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. beersa

    EXCEL VBA Caluculation ERROR

    beersa, Mar 16, 2006, in forum: Java
    Replies:
    3
    Views:
    401
    TechBookReport
    Mar 16, 2006
  2. Piet
    Replies:
    0
    Views:
    1,093
  3. Patrick Burke
    Replies:
    0
    Views:
    457
    Patrick Burke
    Jul 21, 2004
  4. Domenico Discepola

    win32::ole and excel VBA macro conversion: SmallScroll

    Domenico Discepola, May 5, 2004, in forum: Perl Misc
    Replies:
    10
    Views:
    560
    Charlton Wilbur
    May 9, 2004
  5. Matt Garrish

    VBA to Perl macro conversion

    Matt Garrish, Sep 17, 2004, in forum: Perl Misc
    Replies:
    0
    Views:
    196
    Matt Garrish
    Sep 17, 2004
Loading...

Share This Page