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?
Where strSubtask, strSubelement and strMonth are procedure level variables defined in the user form as the output of their respective combo box like this:
Bookmarks