Sorry, but I'm not into programming language, but I can do a simpl
Macro Record and even attach it to a button.

I have a simple worksheet template for reservations at our B&B. As soo
as I enter the last name of the guest, a FormatConditioned sell display
to remind me to save the file, as NAME-YYYYMMDD (name and arrival date)

I can put a forumla into one cell that displays that intended fil
name; I can copy it and paste-special-value into another cell. I ca
copy that cell and hit SAVE and Ctl-V that as the name of the file, an
save it.

I can do all that manually, but when I try it as a macro, it tries t
save the file as the name of the LAST guest it did that to. If I'
saving JONES-20070106 it asks if I want to replace SMITH-20061221.

When I look at the debug code (god forbid - it's like opening the hoo
of my car!) I see SMITH-20061221 imbedded in the macro!

What am I missing?

Thanks for any help!

Jim / Sleepless in Toront

--
tdba
-----------------------------------------------------------------------
tdbab's Profile: http://www.excelforum.com/member.php...fo&userid=3693
View this thread: http://www.excelforum.com/showthread.php?threadid=56650