working with excel

[ch_rk2004]

Hi all,

My application creates an excel file and saves it in temp folder with a name including machine name (the name system on which the script is executed).

The requirement is, i need open that excel file and save it at particular location irrespective of the machine on which it is executed.
how can i handle this ...?

[supputuri]

you can get the computer name using the below code

Code:

Set WshNetwork = CreateObject("WScript.Network")
ComputerName = WshNetwork.ComputerName

Then from there you can take it forward I guess let me know if you need any more help

[ch_rk2004]

can u pl help on further steps..from the code given we can get the machine name, but how can i copy the file to new location....

[supputuri]

Use the File system object and copyfile or copy methods to copy the file into new location.

To get the temp path use Envrionment("SystemTempDir")

Let me know if you need the snippet.