Save temporary excel file.

[Happy2day]

How can I save temporary excel file which is exported from application.
Can you please help me ?

Thanks.
Uma

 

[EBGreen]

How can we know how to answer this question?
What do you mean by exported?
If it is a temporary excel file then it is probably saved somewhere already.
What application?

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Happy2day]

Hi ! Thanks for reply.
Application is player tracking.
The excel file is saved as Book1.xls(regular expression :Book*.xls).
filepath is My Documents\Book1.xls

How can I save copy of this file in the network path?


Thanks in Advance
Uma

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/script56/html/FSOoriFileSystemObject.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Happy2day]

Hi PH , Thanks for reply.I finally have found the solution.

***************Start VBScript**********************
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
file1="C:\Documents and Settings\"&username&"\My Documents\book3.xls"
file2= "C:\viewcreditdetail.xls"
fso.CopyFile file1,file2
fso.DeleteFile(file1)
***************End VBScript**********************