Sign in to follow this  
Followers 0
gumby

Help Pls - Need To Create List Of Excel Fls To Save To

4 posts in this topic

Pls help, am fairly new to this, however have written a calculator type program for doing basic stockmarket calculations, in this you can save each trade to an excel spreadsheet, however the problem is i need it to doa new one each month/ and to be able to select which spreadsheet to save to, so i need a dropdown list of spreadsheets in a designated folder. I really don't even know where to start and would so appreaciate some help. In the program it just writes to one spreadsheet, ie is hard coded to one template, I 've no idea how to make this a variable dependent on which excel spreadsheet was selected from the save to list...

arghh. any help on this matter would be v. much appreciate.

cheers

Share this post


Link to post
Share on other sites



Sounds like you could be looking for either GUICtrlCreateCombo (drop-down menu which you would need to populate with *.xls files from a certain folder), or FileOpenDialog(), where you could select a file to use. I can't really help you too much more without more detail or code (preferred).

Share this post


Link to post
Share on other sites

Thanks heaps, got it all sorted now! Big smiles.

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