Help with opening an Excel file from within a Word VBA

A

Android

I just discovered this community.

I am trying to run an Excel workbook template from within
a Word document.

Having trouble with this. The closest without error I came
to is the following:

Private Sub cmdCBA_Click()
Dim ExcelSheet As Object
Set ExcelSheet = CreateObject("Excel.Application")
ExcelSheet.Workbooks.Add ("O:\..... \tplCBA.xlt")
End Sub

This does not give errors, but also does nothing. Also,
even though I'm using the same folder for the document and
the template, I still need to specify the full path for
some reason.

Could someone please tell me what I'm doing wrong.

Regards,

Android.
 

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

Open my default template when right click, select New MS Word doc within a folder 0
Embedded Excel into Word with Tables 0
Help with opening an Excel file from within a Word VBA 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Extract embedded excel file from word document 0
Need help modifying code 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2

Top