Using Content Control Checkboxes to open associated excel files

shaztastic · #1 08-24-2018, 11:52 AM

Hi

I'm really struggling with this, code is not my thing any help or pointers really appreciated

I have a word 2010 document. I have a list of documents each with an associated checkbox. If a checkbox is checked I want to open the associated document, which is an excel file, when I click on a command button.

So i have an Active X checkbox with this code which opens the excel file as soon as i check it which is not quite what i want to do but i seem to keep going in circles (if possible i would like to use ContentControl Checkboxes but i cant even get the code I've got to work with them)......

Code:

 
Private Sub CheckBox1_Click()
 Dim oExcel As Excel.Application
    Dim oWB As Workbook
     Set oExcel = New Excel.Application
     Set oWB = oExcel.Workbooks.Open("C:\Temp\MyDoc.xls")
     oExcel.Visible = True
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Export Word Drop-Down Content Control to Excel Specific Sheet	nolanthomas32	Word VBA	4	09-19-2017 06:25 AM
Populate Content Control Dropdowns from Excel	Deirdre Kelly	Word VBA	23	09-07-2017 02:51 PM
Content Control Checkboxes	wlcdo2	Word VBA	3	01-05-2017 05:52 PM
Deleting a table from a content control -- preserving the content control	BrainSlugs83	Word Tables	8	11-14-2013 03:06 AM
Assigning Values to content control checkboxes and calculating results	creative cathy	Word Tables	13	10-07-2012 08:52 PM