Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
working with excel
#1
Not Solved
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 ...?
Reply
#2
Not Solved
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
Thanks,
SUpputuri
Reply
#3
Not Solved
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....
Reply
#4
Not Solved
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.
Thanks,
SUpputuri
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)