View Single Post
  #4   Report Post  
Mau
 
Posts: n/a
Default

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"