drom
Active Member
- Joined
- Mar 20, 2005
- Messages
- 498
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance
I have a word file.
I have to populate whithin this word file a few lines, a few websites and a few phone numbers.
I know How to write data whithin word's bookmaks as follows:
but when the data I want to enter is a webSite:
What do I have to do??
say I want to enter whithin:
WordDoc.FormFields("wMarc") the website "www.mrExcel.com" and see Link01, and keep the bookmark, for the next time
Thanks!
I have a word file.
I have to populate whithin this word file a few lines, a few websites and a few phone numbers.
I know How to write data whithin word's bookmaks as follows:
Code:
Dim WordDoc As Object: Set WordDoc = WordApp.Documents.Open(wFxFN)
WordDoc.FormFields(wMarcador).Result = wCell
but when the data I want to enter is a webSite:
Code:
XX = 0: XX = InStr(LCase(wCell), "ttp://www")
If XX = 0 Then
WordDoc.FormFields(wMarc).Result = wCell
Else
ZZ=ZZ+1
'WordDoc.FormFields(wMarcador).Result = "LINK_" & Format(ZZ, "00")
'How can I add a hyperlink, say eg: www.mrexcel.com"
With WordDoc.FormFields(wMarc)
'.Result = "LINK_" & Format(ZZ, "00") ????
'.Text = "LINK_" & Format(ZZ, "00") ????
.Hyperlinks.Add Anchor:=.Words(1), Address:="www.mrexcel.Com" ????
End With
What do I have to do??
say I want to enter whithin:
WordDoc.FormFields("wMarc") the website "www.mrExcel.com" and see Link01, and keep the bookmark, for the next time
Thanks!