LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Save it giving as a name the content of a cell

I wonder who could help me with this. I've got a spreadsheet called Blank
Form saved as a template. I want to attach a macro to a button in the
spreadsheet called Save It in a way that when someone clicks on it the Save
window opens up and in File name it writes the content of cell A1. The
content of the cell will be something like NAT-NU-1-001 and it should ask
where to save it but give the name of the file by default.

Thank you
 
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
Can I restore previous content before a save? cls1990 Excel Discussion (Misc queries) 4 November 30th 09 09:05 PM
Requiring Cell Content on Save The Chad Excel Discussion (Misc queries) 1 July 3rd 08 12:06 AM
File Save Macro as Cell content TonyD Excel Programming 0 February 19th 07 07:00 PM
save workbook as the date content of a cell within a sheet Brian Excel Programming 1 October 18th 04 08:33 PM
Save as using cell content in file name NickMinUK Excel Programming 1 June 15th 04 10:06 AM


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

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

About Us

"It's about Microsoft Excel"