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.