Link to Excel Spreadsheet from Access form

D

Decembersonata

My access db relies on information that first must be reformatted using
Excel. On my Add New Record form, I want to link to this Excel spreadsheet
using a command button. How do I specifiy the specific spreadsheet to be
called up? I'm assuming I'll use an On Click procedure, but need help
writing the Visual basic code. Thanks
 
A

Amduke

Thank you for your quick respons, but.... it doens't work.
Find here some code I used; maybe there is some mismatch in the used syntax:

Dim oSource As Object
Dim StrSource As String
Set oSource = CreateObject("Excel.Application")


'Not Allocated.xls
StrSource = "I:\be\_agb\agfaproj\logistiek\WOS\Not Allocated.xls"
oSource.Workbooks.Open (StrSource)
'oSource.Visible = True
oSource.Run ("RefreshAll")

'this doens't work
objActiveWkb.Close Savechanges:=True
'this doens't work
oSource.Close Savechanges:=True

oSource.Workbooks.Close (StrSource)
 
Top