Batch File- Current Date in Excel

Computing.Net > Forums > Programming > Batch File- Current Date in Excel

Batch File- Current Date in Excel

Original Message

Name: Spiderman
Date: July 25, 2008 at 14:25:55 Pacific
Subject: Batch File- Current Date in Excel
OS: Windows XP
CPU/Ram: 1 GB
Model/Manufacturer: Dell

Comment:

Hello,
I need a batch file that places current date and time in different cells in an excel worksheet. Currently I am using this code: echo %date% %time%>datelog.xls, but it places the date and time in the first cell.Anyway of doing this?
Thank you for your answer!
Keep trying!

Report Offensive Message For Removal

Response Number 1

Name: ghostdog
Date: July 26, 2008 at 04:47:53 Pacific

Reply: (edit)

to program excel, you need vbscript/VBA. Not DOS. A simple example
Set objExcel = CreateObject("Excel.Application")objExcel.Visible = True
objExcel.Workbooks.Add
objExcel.Cells(12, 1).Value = "value"

Report Offensive Follow Up For Removal


batch file:Insert date in file batch file name date and time Batch File deleting files by date? Batch File deleting files by date? Batch Files - Reformatting Date	Batch File: Open HTM in current dir batch file Batch File - controled backup Batch file to check file attribute Batch File:Replace text in variable

Hp 5500

running a batchfile 'exte...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Batch File- Current Date in Excel

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 6 Days.
Discuss in The Lounge

DVD-ROM Problems

Reverse Proxy

Help setting up Apache and PHP

DVD Menus in Windows Movie Maker

After installin SP3, NTDLR not foun

All Posts Awaiting Replies