How to open files in excel using VBA

I am working on a project to create a user interface in excel that would have a form with various button, spin buttons, option buttons etc.

So first thing i want to learn is how to open a file in excel through VBA. This is the code I came up with but it doesn't work.
I have a folder on my desktop called notes. I am using it as my test folder to learn code I need for this project.
In the folder I have other folders one is called January the other is February.

I don't think I will use a msg box for this in the actual project. I will use a spin button for this, but for now this is what I came up with.

Please Login or Register  to view this content.

Thank you.

So lets say i want to have a spin button that scrolls through each month of the year. And each month is the name of each folder.. how do I do that.. How do i select at folder level not at the file in the folder ..Because after they select folder then i want a form to come up that the user can then use to select the file. Each month will have the same number of files with the same name.
Example
folder january
file 1
file 2
folder February
file 1
file 2
folder March
file 1
file 2
each month ..........

Not sure how it would be different. Because each month is related to a folder. After the month(folder) is selected they would have up to five files to choose from within the month(folder).

Ok so what would be the code to pull the month that was selected in the first control into the loop of the second control?

Originally Posted by Andy Pope

Please Login or Register  to view this content.

where your useform has a combobox called cboMonthNames that contains month names.
the results are used to populate a listbox called lisFilenames

Thanks I will give this a try and let you know how it goes.

Not sure where i should write this code. Do I put it in the Lisfilenames moduel or the CboMonthNames module/ it looks like it should go in the combo box module but when I tried it gave me an error
i tried it with this code

Please Login or Register  to view this content.

I tried to do it this way. I have two dropboxes. 1 is for the month =cboMonthNames the other is for the file = cboFileName
I have a command button right now just titled commandbutton2.
Here is the code I used but it is not working. I believe I am somehow using the Workbooks.Open incorrectly in my code.

Please Login or Register  to view this content.

The error I'm getting is run-time 1004

strFileName.xlsx could not be found. Check the spelling of the file name, and verify that the file location is correct.

Originally Posted by Andy Pope

perhaps it's time you posted an example workbook

here is an workbook example

sorry didnt know you wanted that too.. attaching it here..