Boomarks
 

Hi

We are creating bookmarks on word document and we fill the values from xml
file to word document using vb6. same like we need to do on excel file. i
dont know the whats the equalient bookmark concept in excel. can any one give
me idea?

thanks
bala

Boomarks
 

The closest thing to a bookmark in Excel is a range name. To
create a name with code, use something like the following:

ActiveWorkbook.Names.Add Name:="TheName", RefersTo:=Range("A1")

To use the name, use code like

Range("TheName").Value = 123


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Bala" wrote in message
...
Hi

We are creating bookmarks on word document and we fill the
values from xml
file to word document using vb6. same like we need to do on
excel file. i
dont know the whats the equalient bookmark concept in excel.
can any one give
me idea?

thanks
bala

Boomarks
 

Thats great! Thank you so much.

I have an one question. ok first i'll create a name like "TheName" and i
filled some values like 123. now i close the excel sheet. and i'll open the
excel thru Vb6 and now can i read the 123 value using "TheName" name like
word bookmark.

Thanks
Bala

"Chip Pearson" wrote:

The closest thing to a bookmark in Excel is a range name. To
create a name with code, use something like the following:

ActiveWorkbook.Names.Add Name:="TheName", RefersTo:=Range("A1")

To use the name, use code like

Range("TheName").Value = 123


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Bala" wrote in message
...
Hi

We are creating bookmarks on word document and we fill the
values from xml
file to word document using vb6. same like we need to do on
excel file. i
dont know the whats the equalient bookmark concept in excel.
can any one give
me idea?

thanks
bala