PC Review


Reply
Thread Tools Rate Thread

Can you use FileCopy to convert a file as well?

 
 
=?Utf-8?B?aGF2b2NkcmFnb24=?=
Guest
Posts: n/a
 
      17th Aug 2007
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 With Quote
 
 
 
 
=?Utf-8?B?aGF2b2NkcmFnb24=?=
Guest
Posts: n/a
 
      20th Aug 2007
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
FileCopy Bad File Name or number mikesjLFG@gmail.com Microsoft Access Form Coding 3 10th Sep 2007 03:31 PM
RE: Can you use FileCopy to convert a file as well? =?Utf-8?B?RlN0MQ==?= Microsoft Excel Programming 0 17th Aug 2007 02:03 AM
File Not Found error in FileCopy =?Utf-8?B?RGF2aWRFUw==?= Microsoft Access Form Coding 4 24th Aug 2006 10:27 PM
Filecopy, file attributes Eric Microsoft Excel Programming 1 24th Feb 2005 01:31 PM
Attn MVPs: FileCopy & convert jmonty Microsoft Access 1 30th Sep 2003 10:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:36 AM.