Hi All,
After i develop the program i compile it into internet package(.CAB) and upload the CAB & HTM File using IIS so others can access the program use the Internet Explorer. Then when i key in the information and need to print out into excel file turn up the program cant find the template file that i assign in the coding and prompt out error message.
Could anyone advise it is turn into CAB file can not use the App.Path? If not need to use which method... Can give any example ?
Here the coding....
Dim strExcelFile As String
strExcelFile = App.Path & "\Book.xls"
If Not FSO.FileExists(strExcelFile) Then
MsgBox "Fail to open Book.xls", vbExclamation, "Missing File"
Exit Function
End If