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

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