Use MsgBox to get filename and save .xls file to pre-defined path
Thanks you two. I have learned a bunch about msgbox in trying to do
this. Guess I can start on input boxes now. Your help will make the
start easier! Much asppreciated.
On Wed, 08 Nov 2006 11:58:05 -0800, Bill Burlison
wrote:
I would like to use a msgbox and ask a user to input a filename then,
when they hit ok, save the file as "C:\Folder1\Folder2\TheirInput.xls"
I would also like to test for no entry and alert then require entry
again if they don't put information in there.
|