Macro 2 change another macro. Possible?

Mat Key · Apr 9th, 2002, 03:37 PM

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

Al Chara · Apr 9th, 2002, 03:44 PM

Read this thread:
http://www.mrexcel.com/board/viewtop...ic=880&forum=2

Al Chara · Apr 9th, 2002, 03:55 PM

You can also take a look at Chip Pearson's page:
http://www.cpearson.com/excel/vbe.htm

Mat Key · Apr 9th, 2002, 04:03 PM

Excellent! Thanks Heaps!Mat

Jack in the UK · Apr 9th, 2002, 04:06 PM

Wow Chip....

Cool!

I suggest http://www.cpearson.com/excel/vbe.htm

Apr 9th, 2002, 03:44 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Read this thread: http://www.mrexcel.com/board/viewtop...ic=880&forum=2 __________________ Kind regards, Al Chara

Apr 9th, 2002, 03:55 PM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You can also take a look at Chip Pearson's page: http://www.cpearson.com/excel/vbe.htm __________________ Kind regards, Al Chara

Apr 9th, 2002, 04:06 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 03:37 PM	#1
Mat Key New Member Join Date: Apr 2002 Location: Sydney, OZ Posts: 4	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

Apr 9th, 2002, 04:03 PM	#4
Mat Key New Member Join Date: Apr 2002 Location: Sydney, OZ Posts: 4	Excellent! Thanks Heaps!Mat