+ Reply to Thread
Results 1 to 2 of 2

recorded macro "method opentext of object workbooks failed"

  1. #1
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Question recorded macro "method opentext of object workbooks failed"

    Hi,

    Recorded a macro and stored it in the PERSONAL MACRO WORKBOOK

    When i try to run the recorded macro below it says "method opentext of object workbooks failed"
    Im very sure the path and the filename are correct dont know why it gives an error when i run the macro

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: recorded macro "method opentext of object workbooks failed"

    So i just removed the succeeding code after opening the dat file and it works

    Please Login or Register  to view this content.

+ 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. Export Powerpivot to CSV - macro error "Method 'Open' of object '_Recordset' failed"
    By Phil McCready in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2015, 02:51 AM
  2. Excel 2011 Macro error "Method 'GetOpenFilename" of object'_Application'failed
    By rfox69 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 09-26-2012, 08:35 AM
  3. "The "sheets" method from the "_Global" object have failed."
    By mankit87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2011, 08:53 AM
  4. Method'OpenText' of object 'workbooks' failed
    By jazbath in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2009, 02:41 PM
  5. macro returns error "Method 'Open' of object '_Recordset' failed"
    By Leafgreen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-09-2009, 05:40 AM
  6. Error in Macro: "Method 'Paste' of object '_Worksheet' failed"
    By blork in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-05-2006, 01:50 PM
  7. [SOLVED] What is Error "Method "Paste" of object "_Worksheet" failed?
    By vat in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2006, 04:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1