excel chart export error runtime 1004

  • Thread starter Thread starter Mau
  • Start date Start date
M

Mau

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"
 
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
 
Thank 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:
 
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:
 
Back
Top