saving file

[kenparker23]

I have a textbox (textbox1). I would like to assign a macro to save the document with the name in textbox1. I would like to save in a folder C:\patients. For example: if "John Smith" was in textbox 1. I would like have a macro that when activated would save the document as "John Smith" in the "patients" folder. This is acutally a word question, but I am also using excel. thanks again.

[Trebor76]

Hi there,

Try the following which simply uses Excel's built-in inputbox to do the same:

Please Login or Register  to view this content.

HTH

Robert