Solve : create a batch file?

1.	Solve : create a batch file?
Answer» Hello, i am working on a pipeline company and we deal with 100 of EXCEL sheets DAILY, our job basically is to extract data from database each day for all the pipelines by changing the date and time from excel, and this is takes alot of time to do. so, can i create a batch file where it can change the date and time AUTOMATICALLY?Batch cannot read and write Excel files but Vbscript can.how can i do that with vbscript? QUOTE from: almatar00 on APRIL 22, 2014, 02:13:57 PM how can i do that with vbscript? If you want exact details then more details about the task are needed.

Answer»

Hello,
i am working on a pipeline company and we deal with 100 of EXCEL sheets DAILY, our job basically is to extract data from database each day for all the pipelines by changing the date and time from excel, and this is takes alot of time to do. so, can i create a batch file where it can change the date and time AUTOMATICALLY?Batch cannot read and write Excel files but Vbscript can.how can i do that with vbscript? QUOTE from: almatar00 on APRIL 22, 2014, 02:13:57 PM

how can i do that with vbscript?

If you want exact details then more details about the task are needed.

Discussion

No Comment Found

Related InterviewSolutions

Solve : secrect message batch?
Solve : Folder Transfer Batch File?
Solve : REG ADD Batch?
Solve : How can we spot evil intent by a Poster??
Solve : Check to see if file is 15min or older than current time.?
Solve : usb auto start script like in the pre 2009 days autorun.ini autoplay.exe win7?
Solve : Batch file to copy files from server location to pc's on domain?
Solve : Batch Script: Find and replace strings in text file?
Solve : Renaming from xml content?
Solve : Create a directory with today's date and delete one with yesterday's?