info from another opened excel sheet

[BoFenger]

Hi
I using VBA 6.3 for excel

I want to be able to do the following.
- press a button that open a new excel file
- in the new excel file I want the user to select a sheet of his own choice, lets say he picks a sheet called "test6" and then he select cells(5,9).

my question is: is it possible to transfer the info of the sheet name (test6) a the cell the user picked back to the sheet where I pressed the button

Hope you can help
Br Bo

 

[SkipVought]

Hi,

This does not make sense to me.

You have TWO people involved here...

YOU and a USER, correct?

"...the cell the user picked back to the sheet where I pressed the button..."

How does this USER get the workbook that YOU opened? When YOU open a workbook, it is on YOUR PC.

Like I stated, this does not make any sense at all.



Skip,

_[red][/red]

 

[PHV]

Have a look at the Application.InputBox method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886