Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem occurs when upgrading Excel from 97 to 2002
When I was upgrading our program from Excel 97 to Excel
2002, the code that worked well with Excel 97, now fails in Excel 2002. Please see the following line of failure. Set theCode = ThisWorkbook.VBProject.VBComponents ("thisworkbook").CodeModule When debugging, I found the following error message. Run-time error 1004, Programmatic access to Visual Basic Project is not trusted. Does anyone have any suggestion? Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem occurs when upgrading Excel from 97 to 2002
This one got me too in the beginning. Tools, Macro, Security, Trusted
Sources, Trust Access to Visual Basic Project! -- Julian Milano "YATES" wrote in message ... When I was upgrading our program from Excel 97 to Excel 2002, the code that worked well with Excel 97, now fails in Excel 2002. Please see the following line of failure. Set theCode = ThisWorkbook.VBProject.VBComponents ("thisworkbook").CodeModule When debugging, I found the following error message. Run-time error 1004, Programmatic access to Visual Basic Project is not trusted. Does anyone have any suggestion? Thanks in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem occurs when upgrading Excel from 97 to 2002
Thanks so much, Julian.
-----Original Message----- This one got me too in the beginning. Tools, Macro, Security, Trusted Sources, Trust Access to Visual Basic Project! -- Julian Milano "YATES" wrote in message ... When I was upgrading our program from Excel 97 to Excel 2002, the code that worked well with Excel 97, now fails in Excel 2002. Please see the following line of failure. Set theCode = ThisWorkbook.VBProject.VBComponents ("thisworkbook").CodeModule When debugging, I found the following error message. Run-time error 1004, Programmatic access to Visual Basic Project is not trusted. Does anyone have any suggestion? Thanks in advance! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem upgrading to Excel 2007 | Excel Discussion (Misc queries) | |||
Any problem of migration for upgrading Office 2007 from Office 200 | Excel Discussion (Misc queries) | |||
Excel 2002 CDO Email Problem | Excel Programming | |||
Problem with Excel 2002 | Excel Programming | |||
problem in excel 2002 and windows xp | Excel Programming |