Jump to content
Sign in to follow this  
gumby

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

Recommended Posts

gumby

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
greenmachine

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
gumby

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  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.