Thread: Get user inputs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
C C is offline
external usenet poster
 
Posts: 61
Default Get user inputs

I have a workbook that opens up upon macro run. It opens up in Read Only and
would like to prompt the user to save the file at this point. Once they have
saved the workbook under a new name I would like to delect the original file
located at c:\Sales.xls. I would also like to ask the user to Enter the
start date in MMM YY and end date MMM YY. Then starting in cell E1 Enter the
reporting period they specified.

Can someone help me out with the code to do this?

Thanks in advance.