I need your help in openning excel file from Access,but I have the following problem:
1. I have excel file which is linked to Access table.
2. I access I build a form on the table (which linked to Excel).
3. Now I have exceptions while using the following code:
Function OpenExcelSheet(FileName As String, FormName As String)
Set ExcelSheet = CreateObject("Excel.Application")
ExcelSheet.Visible = True
I have the exception "cann't open yyy.xls file" If the form is opened.
If I try to open the file without the form be opened ,It's OK.
please help me.