XMLSS document to Excel document in .xls format

[Dominik]

Hi all,

I need to save an Excel Xml document (XMLSS) as an Excel document in .xsl
format.

Does anyone know some automatic way to do this?

Thanks in advance,

Dominik.

 

[Eduardo]

Hi,
sorry if you get this message twice but I got a message error when sending
use a button with the macro as follow

Sub BM_XLS_Copy()
'
' BM_XLS_Copy Macro
'

'
ActiveWorkbook.Save
ActiveWorkbook.SaveAs Filename:= _
"C:Yourfilename.xls", FileFormat:=xlExcel8, Password:="",
WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub

 

[Dominik]

Hi Eduardo,

Thanks for your useful response. But I also need to know if I could execute
this macro to my XMLSS file from the command line...

Thanks again,

Dominik.

 

[Eduardo]

Hi Dominik,
You can go to macro choose the macro and click run, if you mean to add to
the ribbon, You cannot do that

 

[Dominik]

Hi again,

I mean to execute excel from the windows command line, open my XMLSS file
and run the marco automatically.

Thaks for all,

Dominik.

 

[Eduardo]

Hi Dominik, as follow are the instructions

You need to palce your code in the Workbook _Open event. To do so:

* Right-click on a worksheet tab and select View Code
* When taken to the VB window, Locate object VBAProject(YourWorkbookName) in
the project explorer window on the left, and expand it if not already
expanded; double-click on This Workbook
* Locate the two drop-down boxes on top of the main window, and change the
one on the left from default (General) to Workbook; notice the two lines of
code that are automatically entered in the main window:

Private Sub Workbook_Open()

End Sub

Whatever code you put in between will be executed whenever you open the
workbook. You could either paste the code here, or leave it in the general
module where it currently is and just call it from here, like:
My_Macro_Name