+ Reply to Thread
Results 1 to 3 of 3

METHOD Object Failure

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,599

    METHOD Object Failure

    .
    .
    My project is showing an error : "METHOD 'Worksheet of object'_Global Failed". I'm trying to query data in a separate workbook and display
    in the Listbox and Textboxes on a Userform.

    It utilizes a routine by Chip Pearson - which functions really well if the data is located in the same workbook.

    Please advise what error/s are present in the existing project to query another workbook. His code doesn't indicate this but it appears to presume
    that if it is to query another workbook, the code only has to indicate the path and not first "open" the other workbook (module code). I've indicated which workbook to query in the Module: InWorkbook = "C:\Program Files\Logit\FCC.xlsm"

    Thank you for your assistance.
    .
    .
    Image1.jpg
    .
    .
    Image2.jpg
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,613

    Re: METHOD Object Failure

    The search methods used require the workbook to be open. Not sure where you get the presumption.

    This would open a workbook if it's not already opened.
    Please Login or Register  to view this content.
    For future reference:
    1.) if you are doing something funky like you do to hide Excel, give the us a heads up on that and how to get around it. Or better yet, disable it if it has nothing to do with your query. It's not obvious what's going on initially when the workbook is opened.
    2.) give the procedure name for the code you have an issue with. Makes it easier to find and understand what you're talking about.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,599

    Re: METHOD Object Failure

    AlphaFrog

    Thank you so much for your assistance. I apologize for the confusion re: the workbook being hidden. This doesn't justify it but I was working on several things this morning and forgot to change the coding so the things would not be hidden.

    With your assistance the project does what I need it to, using just a few rows of data. Let's see if it will run with alot more.

    Thank you again !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Paste Method Failure when copying between worksheets
    By stubbsj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2012, 09:17 AM
  2. 'Select method' failure
    By kysaul in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2008, 01:54 PM
  3. Select method of Range class failure
    By jayron in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2007, 10:56 AM
  4. Method 'SaveAs' failure
    By w.goodwater in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2007, 06:47 PM
  5. [SOLVED] BorderAround method failure
    By johnhildreth@citynet.net in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2005, 02:50 PM
  6. [SOLVED] OpenText Method failure
    By Bryan Dickerson in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-13-2005, 05:06 PM
  7. Range object global failure
    By Otto Moehrbach in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2005, 05:06 PM
  8. [SOLVED] GoalSeek Method failure
    By Fixit_Steve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06535 seconds
  • Memory Usage 8,969KB
  • Queries Executed 16 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (3)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (3)postbit_legacy
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (4)showthread_bookmarksite
  • (8)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1