View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Can you use FileCopy to convert a file as well?

hi,
I have never done it with a xml file but you might try the saveas method.

Regards
FSt1

"havocdragon" wrote:

Hello all!

I have an XML Spreadsheet file saved on a network directory, that on a
weekly basis, I need to copy it to another directory and save it as an excel
spreadsheet. I was wondering if there was a way to use filecopy method to
convert the file?

FileCopy "Oldfile.xml" , "Newfile.xls" Doesnt work unfortuneatly =(