Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tel Tel is offline
external usenet poster
 
Posts: 39
Default Save Worksheet as new workbook with specifics

Hi All,

I want to give a user the opportunity to save a worksheet, which will be
hidden from the user, as a new workbook. In essence I'll create a button
which states "click here to create a Remediation Plan?"

When clicked, I want them to be prompted with a Save As dialog box with a
filename sourced from: Sheet "Remediation Plan" Cell C2 and F2. with VMRP at
the beginning: It will look like ABCD_Company Name_Date. (ABCD being a
constant).

It is possible the company name (e.g. ABC Limited - sourced from C2) will
have spaces and I'd like to replace them with underscores so the suggested
filename becomes "ABCD_ABC_Limited_ddmmyy". I'm don't want to try identify a
pathname, this is something the user can do themselves (as indeed they could
change the filename if it is not in keeping with any naming protocol they may
have.

As a second challenge, I also want to create a macro which will send the
original workbook by e-mail to a pre-defined e-mail address and in doing so
will use the filename format outlined above.

Any helpful hints or useful suggestions.

In context, I am familiar with the concept of macros but wouldn't have a
clue how to write one from scratch so any responses in detail would be highly
appreciated. Please feel free if you have any questions.

Many thanks guys, it's your efforts thus far that have made me look good :-)

Tel
Reply
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
Save Worksheet To Master Workbook Bobzter100 Excel Discussion (Misc queries) 5 March 12th 09 02:55 AM
(DAVE PETERSON) - SAVE WORKSHEET AS A NEW WORKBOOK Gator Girl Excel Worksheet Functions 6 October 21st 08 08:14 PM
How do I save a worksheet within a workbook? jester Excel Discussion (Misc queries) 1 August 7th 06 10:54 PM
Comman Button to Save Worksheet as Workbook tmstreet Excel Discussion (Misc queries) 2 July 17th 06 05:44 PM
Save Worksheet vs Workbook Terry Excel Worksheet Functions 1 January 6th 06 06:31 PM


All times are GMT +1. The time now is 10:55 PM.

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"