Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 =( |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 =( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you use FileCopy to convert a file as well? | Excel Programming | |||
FileCopy | Excel Programming | |||
Filecopy, file attributes | Excel Programming | |||
FileCopy | Excel Programming | |||
FileCopy | Excel Programming |