I'm trying to run an agent from the web to export data to Excel. I've installed Excel on the server from MS Office 2000, I can install excel from office 2k7 if it's recommended.
Users could be using IE, FF or a browser on an MAC.
The server is giving me the following error on the SaveAs line-
Microsoft Excel: The file could not be accessed. Try one of the following:
Make sure the specified folder exists.
Make sure the folder that contains the file is not read-only.
Make sure the filename does not contain any of the following characters: < > ? [ ] : or *.
Make sure the file/path doesn't contain more than 218 characters.
Code below. I've seen a lot of posts around this subject, either they are for the notes client or not Script based, but none seem to provide a solution for the error that I'm having.
Dim session As NotesSession
Dim db As NotesDatabase
Dim doc As NotesDocument
Set session = New NotesSession
Set db = session.currentDatabase
Dim myobject As Variant
Dim mysheet As Variant
Set myobject = createObject("Excel.application")
Set mysheet = myobject.workbooks(1).Worksheets(1)
mysheet.name = "Review"
mysheet.cells(2, 5).value="Transfer to Excel"
Set myobject = Nothing ' free up the memory