File open and variables

[arcticpup]

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 March 4, 2009 by arcticpup

[jvanegmond]

Are you looking for FileOpenDialog?

[arcticpup]

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?)

[jvanegmond]

I think you can if you set these parameters:

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