Read in a filepath selected by the user

[mcornbill]

Hi Guys

I'm using the following command to open an Excel file:

$FilePath = "c:\testfile.xls" 
$oExcel = _ExcelBookOpen($FilePath)

The Excel file I will be using with this script will be different everytime and will probably not be held in the same location either. So basically rather than declaring the file to open I want it to pop up a windows explorer box, the user browses to the file on their machine, and then that gets read in as $FilePath.

I've searched the forums but having difficulty in finding an answer, can anybody help please?

Cheers

Mark

[AdmiralAlkex]

So you searched the forums but not the helpfile? That's not very smart.... Anyway check FileOpenDialog()

[mcornbill]

So you searched the forums but not the helpfile? That's not very smart.... Anyway check FileOpenDialog()

Humblest apologies but thanks for your help.