LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forcing User inputs apache007 Excel Discussion (Misc queries) 1 February 6th 10 05:11 PM
user inputs with Message Boxes Erik Excel Programming 5 January 28th 09 08:59 PM
User Forms & Checking Inputs Jez Excel Programming 1 February 6th 08 04:24 PM
Extend Border As User Inputs New Rows Paperback Writer Excel Discussion (Misc queries) 1 December 1st 06 02:58 PM
Text Box : Controlling what the user inputs Matthew Balch[_2_] Excel Programming 2 November 15th 06 10:46 AM


All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"