Radu
New Member
Hi all,
I have a weekly report that I've chosen to reformat using a dashboard approach. All the sheets in my report have combo box form controls that show the start and end of week dates (for instance, 22.02.2010 - 28.02.2010). What I would like is that when the user chooses another week in the combo box's drop-down list, the report corresponding to that week to open in a new Excel instance. All of the historical reports are in the same folder to which all the users have access, and all the reports' names are like "Weekly report - week dates". Can this be done with VBA (I'm fairly new to it)? I would be happy to provide more details, if needed.
Thanks in advance for your response.
Best regards from Romania,
Radu
I have a weekly report that I've chosen to reformat using a dashboard approach. All the sheets in my report have combo box form controls that show the start and end of week dates (for instance, 22.02.2010 - 28.02.2010). What I would like is that when the user chooses another week in the combo box's drop-down list, the report corresponding to that week to open in a new Excel instance. All of the historical reports are in the same folder to which all the users have access, and all the reports' names are like "Weekly report - week dates". Can this be done with VBA (I'm fairly new to it)? I would be happy to provide more details, if needed.
Thanks in advance for your response.
Best regards from Romania,
Radu