Edit excel macro programatically
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Edit excel macro programatically

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have created an excel macro in a workbook. What I need to do is edit the excel macro from another excel worksheet. IE do a find and replace on the macro code in the other sheet. I cannot replace the current sheet as it contains important data. This excel sheet is widely deployed and so Ideally I want to write a macro which opens the sheet, edits the code and then saves it. Any ideas?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Leiden, The Netherlands
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Dynamically editing a VBA program (or any kind of program) sounds like bad programming practice and in my opinion should be avoided. Is there no way your problem could be solved by using variables, constants or extra arguments in your function(s)? Or maybe by adding a worksheet that contains the desired settings to your workbook. You might also consider storing the settings in a separate workbook or in a text file that could be read by your macro.

    I hope this will help you find a solution to your problem.

    Marc

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com