Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default Permission denied when adding script object (seems Excel bug)

Hi,

I have the following problem in Excel2007

1. I've created a new xls workbook
2. Added a script object to sheet1 as follow(using VBA)
Set lScript = Sheet1.Scripts.Add(, msoScriptLocationInBody,
msoScriptLanguageOther, "Script1")
3. SaveAs xls workbook to xlsx format, then i got to warning message that
script object will be deleted and then I accepted the changes
4. Close Excel
5. Open the xlsx file that saved in step 3
6. SaveAs to xls format again
7. I've tried to add the script object again to the sheet. as follow
Set lScript = Sheet1.Scripts.Add(, msoScriptLocationInBody,
msoScriptLanguageOther, "Script1")
8. I've got "Permission denied" Error. it seems because the the script is
already there. I've tried to search the id in the script collection. but i
couldn't find it. it seems it exist but hidden.

Regards
Raja
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
error 70 permission denied in excel Uwe Excel Programming 3 January 19th 08 03:16 PM
Permission to use object denied. Shannon Excel Programming 3 November 18th 04 11:41 PM
Permission to use object denied WilDeliver[_2_] Excel Programming 2 October 22nd 04 07:46 PM
FileSystemObject: object.Name [= newname] = Permission denied(Erro augustus Excel Programming 0 September 17th 04 01:55 AM
Error Msg: Permission to use object denied A. Nguyen Excel Programming 4 July 14th 03 09:05 PM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"