Hello i have two problems and i need examples of how to...
- I have in a click method some code that saves an excel sheet in the server, when you run it in the server works fine, but when you try to save it from the client it places a message error, about the path where to save. The same thing shows up when you try to access the file saved.
this is my code to save:
dirxls=sys(5)+curdir()+"general.xls"
XLApp.ActiveWorkbook.SaveAs(dirxls)
this is my code to open the file "general.xls"
dirxls = SYS(5) + CURDIR() + "general.xls"
oWorkbook = oExcel.Workbooks.Open( DIRXLS )
How can i solve this?
The other question is the same placed above but applied to tables. When i generating the excel sheet it uses some tables, some problems will comes if two users are using the same procedure (it shows to the other user: The file is in use).
How can i solve this too?
Thanks for your support.