access excel

Dec 12, 2011 at 5:34 PM



In my application, i want to create an excel file in a specified excel file format which contains many formulas and tables.

In the new file i want to put data in the form of names.


The cells are given some defined name. I want to put data in form of the defined name. Say, the excel cell defined name is "Startcell". I want to allot the value 567 to the cell.


I want to do like :

StartCell = "567";


Please help me how can i acieve the same.