Newbie question.

I created a workbook with a macro to import and reformat a workboo
then save as to a permenant name. This works great until I created
button to run the macro.

When running multiple times, the button tries to run the macro out o
the 'save as' workbook. This causes problems. How to I force the butto
to always run the macro out of the current workbook

--
Message posted from http://www.ExcelForum.com