Excel Writer Utility

[SwannSG]

I am looking for a utility that will take each line/record of an input file/database with fields : value, data type, target spreadsheet, target sheet, target cell and generate an entry for each line/ record into a corresponding Excel spreadsheet.

So for example an input file/table could contains the following :

Value Data Type Target Spreasheet Target Sheet Target Cell
100 Numeric c:\Spreadsheets\Sampe.xls Sheet2 B4
DES Character c:\Spreadsheets\Sampe.xls Sheet1 C7

This input file/table would then update spreadsheet Sampe.xls.Sheet2.B4 = 100, and Sample.xls.Sheet1.C7 = DES

I would prefer to do this with an application external to Excel.

 

[Zack Barresse]

i don't know if this will help, but try looking at:

http://www.mrexcel.com/board2/viewtopic.php?t=66893&highlight=importing+data+excel

it sounds similar, if not, post back again.

hope this helps.