I wish to allow a user to navigate to their chosen workbook and then pull
values from specific ranges on a sheet in that workbook, to populate
textboxes in a Userform.

Do I have to open the workbook, please?

Regards.

That would be the only way for a user to navigate.

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
I wish to allow a user to navigate to their chosen workbook and then pull
values from specific ranges on a sheet in that workbook, to populate
textboxes in a Userform.

Do I have to open the workbook, please?

Regards.

I don't think so if I understand what you want, as you can use the
GetOpenFilename method and then use various techniques to access data in
that workbook. But some of those techniques are quite complex (ADO, Harlan
Grove's pull routine, Laurent Longre's beta INDIRECTR facility, or even
implicit worksheet functions), so it would seem simpler top me to just open
it and get the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stuart" wrote in message
...
I wish to allow a user to navigate to their chosen workbook and then pull
values from specific ranges on a sheet in that workbook, to populate
textboxes in a Userform.

Do I have to open the workbook, please?

Regards.

Many thanks to you both.

Regards.

"Tom Ogilvy" wrote in message
...
That would be the only way for a user to navigate.

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
I wish to allow a user to navigate to their chosen workbook and then pull
values from specific ranges on a sheet in that workbook, to populate
textboxes in a Userform.

Do I have to open the workbook, please?

Regards.

I meant I do think so ... even know the other way may be easier, it is
possible.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
I don't think so if I understand what you want, as you can use the
GetOpenFilename method and then use various techniques to access data in
that workbook. But some of those techniques are quite complex (ADO, Harlan
Grove's pull routine, Laurent Longre's beta INDIRECTR facility, or even
implicit worksheet functions), so it would seem simpler top me to just
open
it and get the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stuart" wrote in message
...
I wish to allow a user to navigate to their chosen workbook and then
pull
values from specific ranges on a sheet in that workbook, to populate
textboxes in a Userform.

Do I have to open the workbook, please?

Regards.

I ended up opening the book as suggested.

Regards.

"Bob Phillips" wrote in message
...
I meant I do think so ... even know the other way may be easier, it is
possible.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
I don't think so if I understand what you want, as you can use the
GetOpenFilename method and then use various techniques to access data in
that workbook. But some of those techniques are quite complex (ADO,
Harlan
Grove's pull routine, Laurent Longre's beta INDIRECTR facility, or even
implicit worksheet functions), so it would seem simpler top me to just
open
it and get the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stuart" wrote in message
...
I wish to allow a user to navigate to their chosen workbook and then
pull
values from specific ranges on a sheet in that workbook, to populate
textboxes in a Userform.

Do I have to open the workbook, please?

Regards.