Jump to content

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


Recommended Posts

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

Link to comment
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).

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...