Home > Cannot Run > Cannot Run The Macro Atpvbaen.xlam

Cannot Run The Macro Atpvbaen.xlam

Very VERY strange error that must be related to this error message I received when I disabled both the analysis toolpak and the analysis toolpak for VBA add-ins. Enter your address and click "Subscribe." (Your e-mail address is not shared with anyone, ever.) Want to see what the newsletter looks like? Share it with others Like this thread? Join our site today to ask your question. his comment is here

The files were there. Teenage daughter refusing to go to school When booking a cruise, how can I find a list of all the fees in advance? share|improve this answer answered Aug 11 '15 at 15:30 KFichter 658213 If it wasn't for goofy stuff like that we wouldn't have jobs. –MatthewD Aug 11 '15 at 15:36 Probably is connected with the fact that the first module I ran it as a VB script.

Thread / Post Bookmarking by Thread / Post Bookmarking v1.1.0 - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd. Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. Log in or Sign up Tech Support Guy Home Forums > Software & Hardware > Business Applications > Computer problem? Allan_Urban, Sep 25, 2009 #6 Jacob Skaria Guest Save this as a macro and Call this macro from Workbook_Open event.

My code is back in working order after disabling/re-enabling these add-ins. Share Share this post on Digg Del.icio.us Technorati Twitter Tushar Mehta (Microsoft MVP Excel 2000-present) Excel & PowerPoint tutorials and add-ins; custom productivity solutions for MS Office Reply With Quote Jun thank you very much Reply With Quote « Previous Thread | Next Thread » Bookmarks Bookmarks Digg del.icio.us StumbleUpon Google Twitter Facebook LinkedIn Posting Permissions You may not post new threads You'll be able to ask any tech support questions, or chat with the community and help others.

Show Ignored Content As Seen On Welcome to Tech Support Guy! Blue LegumeView Member Profile Jan 29 2010, 04:40 PM Post#2Posts: 6Joined: 28-January 10From: Central FLaHere's my own solution:CODEDim obj As Excel.ApplicationSet obj = CreateObject("Excel.Application")Dim varNcd As VariantvarNcd = obj.Application.CoupNcd(Format(Settle, "dd-mmm-yyyy"), Format(Maturity, share|improve this answer answered Aug 13 '15 at 19:35 akallali 115 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign http://www.utteraccess.com/forum/run-excel-macro-atpvbaen-t1929991.html The final solution is to run the Office Setup program and reinstall just the Analysis ToolPak.

My Machine doesn't seem to have the same hierarchy as your example above for 2010.It shows -Program FilesMicrosoftOffice 121033 Kent Hansen28 Jan 2013, 07:06 Had a similar issue when I reloaded What now? Now I have a script designed for automation purposes: 'Open an instance of Excel Set objExcel=CreateObject("Excel.Application") objExcel.Visible=True 'Open PERSONAL.XLS file Set objWorkbook=objExcel.Workbooks.Open("C:\Documents and Settings\ctimot\Application Data\Microsoft\" & _ "Excel\XLSTART\PERSONAL.XLS") 'Call macro objExcel.Run Your name or email address: Do you already have an account?

Ken Puls, FCPA, FCMA, MS MVP (Excel) Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today! The above example is for a default installation of Office 2010. Our Company Sharon Parq Associates, Inc. The cost of switching to electric cars?

Reply With Quote 2011-11-03,04:59 PM #3 CrazyHorse View Profile View Forum Posts View Blog Entries View Articles Neophyte Join Date Nov 2011 Posts 2 Articles0 ok it works! this content even if i save the macro in the personal folder, close the file without saving and the use the macro in the same file it was created on, it gives error on Error Resume Next 'adding VBE object library: ActiveWorkbook.VBProject.References.AddFromGuid _ "{0002E157-0000-0000-C000-000000000046}", 0, 0 'Adding excel object library: Application.VBE.ActiveVBProject.References _ .AddFromGuid "{ 00020813-0000-0000-C000-000000000046}", 0, 0 On Error Goto 0 End Sub Not If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you.

Staff Online Now crjdriver Moderator Advertisement Tech Support Guy Home Forums > Software & Hardware > Business Applications > Home Forums Forums Quick Links Search Forums Recent Posts Members Members Quick Sign up now! The system returned: (22) Invalid argument The remote host or network may be down. weblink Allan_Urban, Sep 25, 2009 #1 Advertisements Jacob Skaria Guest Allan, check out the below link from Microsoft http://support.microsoft.com/kb/192642 -- If this post helps click Yes --------------- Jacob Skaria "Allan_Urban" wrote: >

He is president of Sharon Parq Associates, a computer and publishing services company. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 15th, 2009,06:58 PM #8 ZVI MrExcel MVP Join Date Apr 2008 Location Sevastopol Posts 3,073 Re: Histogram macro It is worth writing a quick function to check that the add-ins are installed before calling any of the functions.Copyright © 2001 - 2016 Better Solutions Limited | All Rights Reserved.PreviousNext

Leave your own comment: *Name: Email: Notify me about new comments ONLY FOR THIS TIP Notify me about new comments ANYWHERE ON THIS SITE Hide my email address *Text: *What

Using 2007 btw. unlucily, i only bought a Product key Card, not the disc. Jacob Skaria, Sep 25, 2009 #4 Allan_Urban Guest Works like a charm! nivrip posted Nov 7, 2016 at 3:35 PM Highlight date ranges D├ęcioC posted Nov 7, 2016 at 10:42 AM WCG Stats Monday 07 November 2016 WCG Stats posted Nov 7, 2016

in in Developer/Macro Security I tried placing the macro in my PERSONAL.XLSB file to no avail (not sure this was worth it, but I found a suggestion to that effect on What could be wrong here? You want the load the *Excel* addins. http://dekovsoft.com/cannot-run/cannot-run-the-macro-blpmain-xla.html Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More...

DataBase replied Nov 8, 2016 at 7:13 AM Loading... Edited by: epicXpert on Thu Jan 28 12:43:53 EST 2010. Not the answer you're looking for? I have to look into it for potential causes.

This tip (802) applies to Microsoft Excel 2007 and 2010.