View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BillB BillB is offline
external usenet poster
 
Posts: 1
Default MsgBox for filename and static path

I have a file at the end of a macro that needs to be saved as an
employees name and a date to a directory I want to define.

I want to use a MsgBox and ask for Name and Date. How do I then
convert the entry in the msgbox and join it to my path so the file is
saved with the right name and in the right place?