ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can you use FileCopy to convert a file as well? (https://www.excelbanter.com/excel-programming/395742-can-you-use-filecopy-convert-file-well.html)

havocdragon

Can you use FileCopy to convert a file as well?
 
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 =(

havocdragon

Can you use FileCopy to convert a file as well?
 
Thanks FSt1, that is what I am doing now =)

The problem is, there are 5 files I am opening and saving as to different
locations on a network, where all 5 files are over 10Mb in size. As you can
imagine, it takes a considerable time more to open them and save them than it
does to do a filecopy =(.

I will keep playing around and see if I can come up with something ;)

"FSt1" wrote:

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 =(



All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com