| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel button to save sheet contents to new workbook
I have an excel workbook where on Sheet1, I can input some data in column A
and the embedded lookups show data relevant to my input value in columns B through U. Sometimes, I may input as many as 7000 rows of data in column A. Can a "Button" in the workbook be programmed such that it will save the contents of Sheet1 A1:U7000 to a new workbook and prompt me to name it and save to a location of my choice? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel button to save sheet contents to new workbook
The contents should be pasted into the new workbook as text.
"Don" wrote: I have an excel workbook where on Sheet1, I can input some data in column A and the embedded lookups show data relevant to my input value in columns B through U. Sometimes, I may input as many as 7000 rows of data in column A. Can a "Button" in the workbook be programmed such that it will save the contents of Sheet1 A1:U7000 to a new workbook and prompt me to name it and save to a location of my choice? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel button to save sheet contents to new workbook
Which version of Excel ?
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Don" wrote in message ... I have an excel workbook where on Sheet1, I can input some data in column A and the embedded lookups show data relevant to my input value in columns B through U. Sometimes, I may input as many as 7000 rows of data in column A. Can a "Button" in the workbook be programmed such that it will save the contents of Sheet1 A1:U7000 to a new workbook and prompt me to name it and save to a location of my choice? Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel button to save sheet contents to new workbook
sorry....Excel 2007
"Ron de Bruin" wrote: Which version of Excel ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Don" wrote in message ... I have an excel workbook where on Sheet1, I can input some data in column A and the embedded lookups show data relevant to my input value in columns B through U. Sometimes, I may input as many as 7000 rows of data in column A. Can a "Button" in the workbook be programmed such that it will save the contents of Sheet1 A1:U7000 to a new workbook and prompt me to name it and save to a location of my choice? Thanks! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel button to save sheet contents to new workbook
Hi Don
If your data is in a range make a table of your range. And there are code examples on this page to do the copy to a new workbook http://www.rondebruin.nl/tablecode.htm Add code to save the workbook and you are ready -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Don" wrote in message ... sorry....Excel 2007 "Ron de Bruin" wrote: Which version of Excel ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Don" wrote in message ... I have an excel workbook where on Sheet1, I can input some data in column A and the embedded lookups show data relevant to my input value in columns B through U. Sometimes, I may input as many as 7000 rows of data in column A. Can a "Button" in the workbook be programmed such that it will save the contents of Sheet1 A1:U7000 to a new workbook and prompt me to name it and save to a location of my choice? Thanks! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel button to save sheet contents to new workbook
Thanks!
"Ron de Bruin" wrote: Hi Don If your data is in a range make a table of your range. And there are code examples on this page to do the copy to a new workbook http://www.rondebruin.nl/tablecode.htm Add code to save the workbook and you are ready -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Don" wrote in message ... sorry....Excel 2007 "Ron de Bruin" wrote: Which version of Excel ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Don" wrote in message ... I have an excel workbook where on Sheet1, I can input some data in column A and the embedded lookups show data relevant to my input value in columns B through U. Sometimes, I may input as many as 7000 rows of data in column A. Can a "Button" in the workbook be programmed such that it will save the contents of Sheet1 A1:U7000 to a new workbook and prompt me to name it and save to a location of my choice? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save only edited sheet within a workbook (Excel 2003)? | Excel Programming | |||
| Macro to save excel sheet in a workbook | Excel Discussion (Misc queries) | |||
| Button To Sort Sheet Contents On Column? | Excel Programming | |||
| Save workbook via Command Button???? | Excel Programming | |||
| Command Button to Save As Workbook... | Excel Programming | |||
Linear Mode
