Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel chart export error runtime 1004
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" |
#2
|
|||
|
|||
This is sheer speculation...
Maybe the Export method creates a temporary file in some temp directory to which the non-admin userid lacks write privileges. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article .com, says... 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" |
#4
|
|||
|
|||
Thanks Tushar for your answer...
....I try to give full control to everyone's group for all temporary folders(C:\WINDOWS\Temp; C:\Documents and Settings\[user]\Impostazioni locali\Temp; etc. ) but it doesn't work!!!!! Have you any idea. Tushar Mehta ha scritto: This is sheer speculation... Maybe the Export method creates a temporary file in some temp directory to which the non-admin userid lacks write privileges. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article .com, says... 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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export from Oracle into Excel, "Open" is not an option in XP | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel | |||
Adding a chart to a Word template linked to an Excel doc. | Excel Discussion (Misc queries) | |||
Chart appearance using "export" method | Charts and Charting in Excel |