ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method (https://www.excelbanter.com/excel-programming/339780-asp-excel2003-run-time-error-1004-export-method.html)

Mau[_3_]

ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method
 

Hello,
I'm trying to export an excel chart from vbscript


If I run the code using a non-administator user it doesn't work


If I put the same user in the administrators group it works.


Any solution to make it working in the first case too?


The folder I'm trying to export to has all the rigths: I give
fullcontrol to everyone..
please help!!!


E.G.
This one work fine only with administrator's user:
Ex.ActiveWorkbook.ActiveChart.Export "C:\FolderEveryOne\Image.gif"


This one work fine always:
Ex.ActiveWorkbook.save "C:\FolderEveryOne\file.xls"


--
Mau
------------------------------------------------------------------------
Mau's Profile: http://www.excelforum.com/member.php...o&userid=27069
View this thread: http://www.excelforum.com/showthread...hreadid=466726



All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com