Hello, I've been trying to use combo boxes to open, then copy and paste information from specific worksheets the user requests. So far, my approach has been unsuccessful --and the suggestion to simply use the GetOpenFiles procedure was helpful but failed to address more than the "open files" part of my application.

I'm hoping someone has a better idea. I reference my code below in case it's obvious I'm missing a key fact. Basically, though, my question is this:

Can variables be part of an excel file address as I've tried to use them in the "strFile =" statement immediately below?

Please Login or Register  to view this content.
Where strSubtask, strSubelement and strMonth are procedure level variables defined in the user form as the output of their respective combo box like this:

Please Login or Register  to view this content.