Hey guys great site - I did a search and from everybody's contribution
found enough information to create dynamic file names and folders in m
save as function - thanks.

One difficulty I'm still having is that I created a new toolbar with a
icon to run a macro. Essentially the macro creates a new workbook
populates the new wb with a query, sorts the data, enters formulas
formats table, saves new wb, and sets toolbar with macro button t
visible=false. Essentially, I'm looking for the toolbar to show onl
when they have the one file that contains the macro open. I've trie
attaching the toolbar to the file so it would appear everytime but i
seems the setting visible to false in the macro is overriding th
attaching when I reopen the file. So am I just a step or two away? O
do I need to totally attack this a different way?

It's being developed in Excel 2002 (XP) SP2

Thanks again,
Jordan


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