Have a macro that crunches a file each day and saves the file as tha
day's date. I want to have my macro add a button to the daily fil
when it's run and the macro that's attached to the button reside in th
daily file. Not reside with my file that crunches the original file
which I close. Also, if I share the file, the button will work.

I can get the code to insert a button. But, how do I get my macr
which inserts the button, to write/add the code to the daily file t
attach the button too? Basically, the macro writes a macro for the ne
file.

Hope that makes sense.

Thank

--
Lift Of
-----------------------------------------------------------------------
Lift Off's Profile: http://www.excelforum.com/member.php...nfo&userid=824
View this thread: http://www.excelforum.com/showthread.php?threadid=53469

Check out this site...

http://www.cpearson.com/excel/vbe.htm
--
HTH...

Jim Thomlinson


"Lift Off" wrote:


Have a macro that crunches a file each day and saves the file as that
day's date. I want to have my macro add a button to the daily file
when it's run and the macro that's attached to the button reside in the
daily file. Not reside with my file that crunches the original file,
which I close. Also, if I share the file, the button will work.

I can get the code to insert a button. But, how do I get my macro
which inserts the button, to write/add the code to the daily file to
attach the button too? Basically, the macro writes a macro for the new
file.

Hope that makes sense.

Thanks


--
Lift Off
------------------------------------------------------------------------
Lift Off's Profile: http://www.excelforum.com/member.php...fo&userid=8249
View this thread: http://www.excelforum.com/showthread...hreadid=534690

See Chip Pearson's page on this

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

--
Regards,
Tom Ogilvy


"Lift Off" wrote:


Have a macro that crunches a file each day and saves the file as that
day's date. I want to have my macro add a button to the daily file
when it's run and the macro that's attached to the button reside in the
daily file. Not reside with my file that crunches the original file,
which I close. Also, if I share the file, the button will work.

I can get the code to insert a button. But, how do I get my macro
which inserts the button, to write/add the code to the daily file to
attach the button too? Basically, the macro writes a macro for the new
file.

Hope that makes sense.

Thanks


--
Lift Off
------------------------------------------------------------------------
Lift Off's Profile: http://www.excelforum.com/member.php...fo&userid=8249
View this thread: http://www.excelforum.com/showthread...hreadid=534690

Jim: That should do it! Sorry for the ignorance.

Thanks for your help, Clif

--
Lift Of
-----------------------------------------------------------------------
Lift Off's Profile: http://www.excelforum.com/member.php...nfo&userid=824
View this thread: http://www.excelforum.com/showthread.php?threadid=53469