Import Query Box

[garye1980]

Hi, i am working on a Workbook the i want to import another sheet from a different workbook, suppose this might be a weird thing to ask for but I am looking to Import another Excel worksheet to my active one but would like to have a userform or a message asking to input the file name to import click go and import goes to my active sheet in cell A1.

Hopefull someone can help me..

Gary

 

[Andrew Poulsom]

Welcome to the Board.

You can use the GetOpenFilename method to prompt for a file name.

http://support.microsoft.com/kb/161930