+ Reply to Thread
Results 1 to 10 of 10

OPEN MULTIPLE ULS - Run-time error in Excel 2013

  1. #1
    Registered User
    Join Date
    08-24-2015
    Location
    Emsworth, England
    MS-Off Ver
    2019
    Posts
    27

    Question OPEN MULTIPLE ULS - Run-time error in Excel 2013

    Apologies if the question has been asked before, I certainly couldn't find any mention of it. I created macro some years back in Excel 2003, I have since upgraded to Excel 2013, the macro runs. but throws a Run-time error.

    Excel Error Message.JPG

    The macro is designed to open multiple URLS, it does two then stops.

    Error Code Picture.JPG

    I can't for the life me see what it is that's stopping it. I've also seen some other macros throwing a similiar error after working. Is it something to do with the upgrade to a later version of Excel???

    Any help would be greatley appreciated.


  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: OPEN MULTIPLE ULS - Run-time error in Excel 2013

    Hello
    Can you upload sample of your workbook?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    08-24-2015
    Location
    Emsworth, England
    MS-Off Ver
    2019
    Posts
    27

    Re: OPEN MULTIPLE ULS - Run-time error in Excel 2013

    Thanks for the response, I've since discovered the macro works on my home pc. Is there a reference or object that I need to activate for macros to work normally. As when I run it at work it throws the errors I mentioned?

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: OPEN MULTIPLE ULS - Run-time error in Excel 2013

    May be the device on which the error occurs has no NetFramework installed

  5. #5
    Registered User
    Join Date
    08-24-2015
    Location
    Emsworth, England
    MS-Off Ver
    2019
    Posts
    27

    Re: OPEN MULTIPLE ULS - Run-time error in Excel 2013

    So nothing I can directly resolve without approching the administrator?

    It seems strange that it can process two URL's then stop.

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: OPEN MULTIPLE ULS - Run-time error in Excel 2013

    Can you upload simple sample of your file to test it on my device and tell you about results?
    I think the problem is because the OS (operating system may be different on both devices)

  7. #7
    Registered User
    Join Date
    08-24-2015
    Location
    Emsworth, England
    MS-Off Ver
    2019
    Posts
    27

    Re: OPEN MULTIPLE ULS - Run-time error in Excel 2013

    Here's the workbook.

    Toolkit.xlsm
    Attached Files Attached Files

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: OPEN MULTIPLE ULS - Run-time error in Excel 2013

    I have tested your file and it is working for me .. I am using Windows 7 32 Bit and office 2016 Professional version
    What is your OS that the problem occurs for you? Is Internet Explorer installed on the device or not?

  9. #9
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: OPEN MULTIPLE ULS - Run-time error in Excel 2013


  10. #10
    Registered User
    Join Date
    08-24-2015
    Location
    Emsworth, England
    MS-Off Ver
    2019
    Posts
    27

    Re: OPEN MULTIPLE ULS - Run-time error in Excel 2013

    I am using Windows 7 and Explorer 11 at work but Windows 10 and Edge at home.

+ 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] Excel 2013 File having multiple formulas taking too much time to Open - Pls Help!!
    By vs.suresh in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-30-2016, 12:04 PM
  2. Replies: 0
    Last Post: 04-21-2015, 09:02 AM
  3. recording macros in Excel 2013, run-time error `1004`
    By atoga in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2015, 12:10 AM
  4. VBA ERROR: run time error 1004: Application-defined or Object-defined error in excel 2013
    By AnanthKrishna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2015, 06:16 AM
  5. MACRO ERROR WITH EXCEL 2013 - Run-Time Error '-2147417848 (80010108)'
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2014, 11:07 AM
  6. Excel 2013 ListView Run-Time error '13', type mismatch
    By PerryBeatty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2014, 09:41 PM
  7. VBA Run-time error '91' In Excel 2013
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-12-2013, 09:28 AM

Tags for this Thread

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