CreateObject("EXCEL.APPLICATION"), Open Workbook, SaveAs new name doesn't work any more ...

I run this script on the server (remote control via terminal services).
So the path is OK

Thks
Hilaire

I understand that the path is a path on the local machine then and not on the server. otherwise I can imagine that this can lead to problems sometimes the OS thinks C:\test refers to a local address instead of remote address

Same thing if I run the script on the server. Changing the path to another path that exists only on the server still gives the same err.

Hi Hilaire,

Looking at your code are you trying to run this from a web page. Either ASP, HTM or any of the others? Especially ASP, P2P or another server-side web page. Because if so then you are going to fail with that code as it doesn't take into account who is logged in or any of their permissions. So if it is serverside page then you need to firstly use the full UNC path (in the format \\server\share\path\file.ext). Then you need to make sure that your web server which is processing the server side page has access to the file. I have tried to do this in the past with pages and had all sorts of problems. I actually had more success with javascript - I'll dig out some code for you.

Cheers,
MalicUK.

Hilaire, here is the javascript I used.

<script language="javascript">
function openExcel(strFileName) {
      var yourAddress = "//server/share/folder/subfolder/";
        openExcelDocPath(yourAddress + strFileName, false);
   }
function openExcelDocPath(strLocation, boolReadOnly) {
        var objExcel;
        objExcel = new ActiveXObject("Excel.Application");
        objExcel.Visible = true;
        objExcel.Workbooks.Open(strLocation, false, boolReadOnly);
   }
</script>

Then I called it in this case by a hyperlink using:

<P><A HREF="#" onClick="openExcel('154.xls');"">1.5.4 File Description</A></P>

Although it can of course be called anywhere where javascript can be called using:

openExcel('myfile.xls');

Thks MalicUK,
this code is (tranlated from VB6 to VBS) part of a VB6 server component that runs as a service on the server, "listens" for new jobs from a database-hosted queue and generates XL files accordingly.
The service is run using a special account that has sufficient rights on the target directory.
Eg I can create a file manually in the target directory when connected as this user on the server.

I provided sample code to narrow the scope a show a simple operation that used to work, and does not work anymore since yesterday (as a side not, we changed the security level of macros/VBA in excel from "average" to "low" cause a company did not send us the latest security certificates).

Maybe there's a prompt or a new server settings that prevents Excel to run in silent mode (The app runs as a NT service, so I don't want excel to show)

Hilaire

>>OK, just majorly confused there<<
Sorry I'm not a native english-speaker so my comments happen to be far from crystal-clear ;-)

in VB6 I tried both fully qualified object types  (excel.application, excel.workbook) and generic object.
sample code is VBS, so no datatype accepted.

In fact I think the question could be shortened as follows :
- yesterday I could use Excel as an ActiveX object in my VB6/VBS code
- today it doesn't work any more
- meanwhile I just changed security level for macros from "average" to "low" (reverting to "average" doesn't solve the prb)
- excel is still OK when used as a client app

Is there a way to fix it whithout re-installing Excel ?

Thanks roos01, I didn't remember this
I finally got it to work in VBS using /unregserver and /regserver,

my VB6 still failed but I noticed that the excel version on the server had been updated.
my VB6 code used
dim objwkb as Excel.Workbook
I got it to work again by using object datatype + late binding
dim objwkb as object
set objwkb = createobject("Excel.Workbook")