To start, hi everybody.

I have a request: I need to write down a macro to save an .xls
worksheet into XML format but (at the same time) I don't want that the
xml file became the new opened one.

Let me explain you a little bit better:
1 - I have a file called 'stefano.xls'
2 - with this macro...

strFileName = "c:\temp\stefano.xml"
ActiveWorkbook.SaveAs Filename:=strFileName,
FileFormat:=xlXMLSpreadsheet, ReadOnlyRecommended:=False,
CreateBackup:=False

....I'm able to save it onto XML format that I can use to update a web
page but (unfortunately) at this moment if I make any further
modification on my workskeet I do them on XML worksheet and not on
original .xls.

The request is:
How can I save the .xml on an external file but keeping the .xls
opened?

The request is infact to add a further piece of code to above macro in
order to connect via FTP to my site, update the file and come back to
original project.

I hope it's clear and I really thank everybody will help me!

Ciao!
Stefano, Milan, Italy