Sign in to follow this  
Followers 0
mcornbill

Read in a filepath selected by the user

3 posts in this topic

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

Share this post


Link to post
Share on other sites



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

Humblest apologies but thanks for your help.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0