1.

Solve : How to send details of a file into excel sheet.?

Answer»

Hi All, 

I have a file CALLED Myfile.mdl. This file is located in some  LIKE D:\Folder_Name1\Folder_Name2\Myfile.mdl.

When we see the the details of this file We find out NMAE, Size, Type, Date Modified etc...

I want to extract only that date into one Excel file called Myexcel.xls.

I have tried with some code but its giving all the details of all directories and SUB directories, but I need only that file date in the excel sheet which is located in main directory.

Your help will be appriciated more.


Thanks in advance
SarayuThis question was asked and answered yesterday. Perhaps you missed it. Click

Quote

I have tried with some code but its giving all the details of all directories and sub directories, but I need only that file date in the excel sheet which is located in main directory.

If you want to help your own cause, you might consider posting your code. It wouldn't be very much help if I told you I wrote some code for your solution and then didn't post it.

As was previously mentioned you cannot update an Excel SPREADSHEET with batch code. You need to use a Windows script language that supports Excel as an object or supports an access method for the file.

 Well, unless it's a CSV file...


Discussion

No Comment Found

Related InterviewSolutions