Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to save .XLA sheet as new .XLS file
Hi All,
I've designed a Add-in which copies current workbook sheet1 & sheet2 data into Input sheet of Add-In. My requirement is Input sheet has to be saved as new file with .xls extension. Is it possible to do like my requirement if not what is the best method to reachout my requirement? Advanced Thanks Vins |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to save .XLA sheet as new .XLS file
In your XLA file, use code like
Sub SaveInput() ThisWorkbook.Worksheets("Input").Copy Activeworkbook.SaveAs Format(Date,"yyyymmdd") & " Input file.xls" End Sub HTH, Bernie MS Excel MVP "Vinod" wrote in message ... Hi All, I've designed a Add-in which copies current workbook sheet1 & sheet2 data into Input sheet of Add-In. My requirement is Input sheet has to be saved as new file with .xls extension. Is it possible to do like my requirement if not what is the best method to reachout my requirement? Advanced Thanks Vins |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save current sheet to new file | Excel Discussion (Misc queries) | |||
Can you save 1 sheet from a large file into another file? | Excel Worksheet Functions | |||
how do I get a macro to save a sheet and set the file name? | Excel Discussion (Misc queries) | |||
copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
Q: save a sheet to a file | Excel Discussion (Misc queries) |