Excel Runtime Error 1004 Method Vbproject
Contents |
CloudFlare Ray ID: 2f21f0f2a0732342
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a excel 2013 runtime error 1004 blank message. Please type your message and try again. More discussions in General excel runtime error 1004 pivot table EBS Discussion All PlacesOracle ApplicationsE-Business SuiteE-Business Suite TechnologyGeneral EBS Discussion This discussion is archived 4 Replies Latest reply on Aug
Excel Runtime Error 1004 Macro
21, 2008 10:47 AM by Hussein Sawwan-Oracle 'Run-time error '1004' when running Web ADI on Office 2007 627511 Aug 20, 2008 8:49 AM I have a user who has loaded office 2007 on their http://www.aclnz.com/interests/blogs/webadi-run-time-error-1004-method-vbproject-of-object-workbook-failed machine and when they attempt to create a functional actuals spreadsheet via web ADI they receive an error message 'Run-time error '1004'; Method 'VBProject' of object'_Workbook' failed'. I know that if a user experiences this when using Office 20003 or lower the solution is to navigate to Tools -> Macro -> Security -> Trusted Publishers. At the bottom of this security box there is an option “Trust access https://community.oracle.com/thread/698468?tstart=101 to Visual Basic Project" make sure that this is checked and then click on ok. Close Excel and then try again and this solves the problem. I know that office 2007 is more tabular than drop down menus so am not sure of the navigation path. I have obtained a screen shot from the user and they do not have the tools option on their toolbar. Can anyone help me with this one?? 13018Views Tags: none (add) This content has been marked as final. Show 4 replies 1. Re: 'Run-time error '1004' when running Web ADI on Office 2007 Srini Chavali-Oracle Aug 20, 2008 1:31 PM (in response to 627511) You might get a quicker response in the ADI forum Srini Chavali Like Show 0 Likes(0) Actions 2. Re: 'Run-time error '1004' when running Web ADI on Office 2007 Hussein Sawwan-Oracle Aug 20, 2008 2:33 PM (in response to 627511) Have a look at the following note, it may be helpful. Note: 376013.1 - Run-time error '1004' Opening WebADI Spreadsheet to Import Dimension Members https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=376013.1 Like Show 0 Likes(0) Actions 3. Re: 'Run-time error '1004' when running Web ADI on Office 2007 627511 Aug 21, 2008 1:03 AM (in response
As VBIDE.VBProject For Each VBComp In ActiveWorkbook.VBProject.VBComponents Hi Guys, I got this code on this google group. and it work in my computer at home im using excel 2007. but here in the http://www.pcreview.co.uk/threads/method-vbproject-of-object-workbook-failed.3797357/ office im using excel 2003 and it doesnt work. im getting this " https://knoworacle.wordpress.com/2011/09/02/oracle-web-adi-run-time-error-1004-opening-webadi-spreadsheet/ Activeworkbook.VBProject...=
WebADISpreadsheet September 2, 2011 shivmohan purohit Oracle Functional While downloading Web ADI spreadsheet first time, you may get this error Run-time error ‘1004': Method ‘VBProject' of object ‘_Workbook' failed In Excel 2003, go to "Tools" > "Macro" > "Security" and select the "Trusted Sources" tab. Check the box next to "Trust access to Visual Basic Project". (Note: The box for "Trust all installed add-ins and templates" should also be checked.) In Excel 2007, use the following navigation: Click on the Office button in the upper left corner Click on the Excel Options button On the left, click on the Trust Center Click on the Trust Center Settings button On the left, click on Macro Settings Click on "Trust access to the VBA project object model" You are Welcome to shareTweetEmailPrintShare on TumblrLike this:Like Loading... Related Post navigation ← Back to Back : Sales Order Process Flow in Oracle OrderManagement Oracle HRMS Online Training Sessions in October2011 → 2 thoughts on “Oracle Web ADI : Run-time error ‘1004' Opening WebADISpreadsheet” How To Fix Oracle Adi Error Number 1004 in Windows says: January 20, 2015 at 6:06 pm […] Oracle Web ADI : Run-time error ‘1004' Opening WebADI … – Oracle Web ADI : Run-time error ‘1004' Opening WebADI Spreadsheet. Posted on September 2, 2011 by shivmohan purohit | 1 Comment. While downloading Web ADI spreadsheet first time, you may get this error. […] LikeLike Reply ram shankar says: September 14, 2011 at 2:43 am GOOD! Used! Thanks Ram Shankar Used LikeLike Reply Want to give some comment to author ( Shivmohan Purohit ) Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. Notify me of new posts via email. Search for: Follow Blog via Email Enter your email address to follow this blog and receive notifications of new posts by email. Join 1,027 other followers about.me about.me/shivmohan Memphis, Tennessee, USA1-901-292-0090 , +1-832-597-2518Reach me via Email at shivmohan.purohit@gmail.com >Shivmohan Purohit Chat with ShivmohanComing EventWill update SoonDecember 18th, 2015The big day is here. Follow Shivmohan Purohit's Oracle ERP BLOG on WordPress.com Top Posts &