arcticpup Posted March 4, 2009 Share Posted March 4, 2009 (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 March 4, 2009 by arcticpup Link to comment Share on other sites More sharing options...
jvanegmond Posted March 4, 2009 Share Posted March 4, 2009 Are you looking for FileOpenDialog? github.com/jvanegmond Link to comment Share on other sites More sharing options...
arcticpup Posted March 4, 2009 Author Share Posted March 4, 2009 Are you looking for FileOpenDialog?Partially, yes I was! ThanksCan 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?) Link to comment Share on other sites More sharing options...
jvanegmond Posted March 4, 2009 Share Posted March 4, 2009 I think you can if you set these parameters:FileOpenDialog ( "title", "init dir", "filter" [, options [, "default name" [, hwnd]]] ) github.com/jvanegmond Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now