sanjdhiman
Programmer
Hi there I have a list of Address in Excel. What I need is a link between word and excel, so when the user via a combo box clicks on a surname, it automatically goes to the Excel sheet and grabs the relevant line of data and puts it into the form in word.. is this possible or am I living in a fantasy world?
I know its possible within say excel using the HLookup function or VLookup but is it possible in VBA and across two applications Word and Excel??
Kind regards
and thanks in advance
Sanj
I know its possible within say excel using the HLookup function or VLookup but is it possible in VBA and across two applications Word and Excel??
Kind regards
and thanks in advance
Sanj