Hi, I am not fully conversant with Access/Excel 2007 and I used to open an Excel spreadsheet from Access with the following code
Set db = CurrentDb()
Set appExcel = New Excel.Application
Set wbkNew = appExcel.Workbooks.Open(Filename:="Q:\Contract\Exp ired.xls")
wbkNew.RefreshAll
appExcel.Visible = True

I now need to do the same thing in Access 2007 to Excel 2007. I am not sure what to change can anyone help please

Thanks in advance
Peter

Hi

I am not sure if there are any changes in Access 2007. But surely the code you have posted will work in Excel 2007 also

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)