Option group of Excel spreadsheets...?

D

David.Krebsbach

I have an option group with 7 choices - each one represents a different
version of an Excel spreadsheet (or could make into 7 sheets in one
workbook). How do I write the VB code to link to the desired spreadsheet for
onClick event of SUBMIT button?

I think I'm asking how to execute a hyperlink in VB?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

option button groups interact with eachother 1
Missing default cell styles on some large existing spreadsheets 0
How do I find what is in a spreadsheet 5
Option Groups: Can I Group the Buttons AND the Box They're In? 2
A2003 bringing in data from an Excel spreadsheet 1
VBA to open an embedded Excel Object 0
Refresh option Group 2
Word & Excel crash when closing (Win7Pro-64, Office2003) 0

Top