Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Macro 2 change another macro. Possible?

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Sydney, OZ
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi All,

    I have a macro that goes through and makes changes to reports that have already been run, so I dont have to roll back each report and then export large chunks of data from filemaker again.

    The current macro opens up each one of the 600 odd reports and makes cosmetic changes based on managements constantly changing ideas of what they want to see (AAAARRRGGHHH!!!).

    I have a combo box on the first page that allows a user to select either month to date figures and percentages, or last days figures or percentages.

    I now want to change this so the user also has an option to see any day from the last month. I have acheived this by using auto filters (easy part), but I also need to change a couple of lines of the exisiting macro,

    Is it possible to have a macro change the contents of another macro in another workbook?

    If not, I will make up another template that does what I want, and make the macro open up each report and copy the data over into the new template and save it as the old file name and trash the other.

    Any help would be great!

    Mat

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can also take a look at Chip Pearson's page:
    http://www.cpearson.com/excel/vbe.htm
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Sydney, OZ
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Excellent! Thanks Heaps!Mat

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wow Chip....

    Cool!

    I suggest http://www.cpearson.com/excel/vbe.htm
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

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
  •