Open and Refresh an Excel Template from an Access Form

[Bonediggler]

Hi There--

I can open the Excel template I want from Access, however, the underlying data query does not run upon opening. The code I am using is as follows:

Private Sub cmdProtocol_Click()

Dim oXL As Object
Dim oExcel As Object
Dim sFullPath As String

sFullPath = "...template.xlt"


Set oXL = CreateObject("Excel.Application")

With oXL
.Visible = True
.Workbooks.Open (sFullPath)


End With


Set oXL = Nothing
Exit Sub

End Sub


Please let me know what the needed code is, and where it fits in this code.

Thank you!

 

[JerryKlmns]

Bonediggler,

Your excel template you open, does it query access for data? If that is so, then forum707 is most appropriate. If not you should explain "underlying data query does not run upon opening"

 

[Bonediggler]

Hi JerryKlmns--

Yes, it does query Access for data. I will try looking in the forum you suggested for a solution.


Thanks--