Sign in to follow this  
Followers 0
arcticpup

File open and variables

4 posts in this topic

#1 ·  Posted (edited)

Morning all,

I'm working on a new project today, so far so good.

An important note is that I am not working on an Excel spreadsheet here.

What I am trying to automate is the opening of one spreadsheet, copying the contents of the cell, and then opening subsequent spreadsheets and pasting the contents of that cell into this spreadsheet.

The point I am stuck on, is, I want to be able to select the spreadsheets at the start of the script, store those in a variable and be able to call those to be opened automatically.

I've tried hunting in the forums and F1 help without much luck.....

Any suggestions?

Edited by arcticpup

Share this post


Link to post
Share on other sites



Are you looking for FileOpenDialog?

Partially, yes I was! Thanks

Can I store the names selected as variables to be automatically opened by the script at a later point? (So say use fileopendialog box again, have the default filename input as variable and open that?)

Share this post


Link to post
Share on other sites

I think you can if you set these parameters:

FileOpenDialog ( "title", "init dir", "filter" [, options [, "default name" [, hwnd]]] )

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