+ Reply to Thread
Results 1 to 1 of 1

Weird Runtime Error When I Opened Excel file and VBA Editor

  1. #1
    Registered User
    Join Date
    06-10-2016
    Location
    United States
    MS-Off Ver
    Microsoft 365 Enterprise
    Posts
    63

    Weird Runtime Error When I Opened Excel file and VBA Editor

    Hi all,

    Anyone ever seen this runtime error? Attached are 3 things; runtime error pdf, file structure pic (not all PDF files shown), and excel file with code in the module. I have been working on the VBA for several days, mostly stumbling along finding what I can that is freely available to use and modify. All code works, except the last sub which I am still trying to figure out. The code is not well organized yet, sorry I'm not good at adding notes. The first two subs create the files in the C:\NSSH folder. Everything else is to create and manipulate the information on the "MainCombine" worksheet.

    Anyway, when I opened the NSSH excel file and the VBA editor this morning, the runtime error popped up. Can anyone look at my code and give me a hint as to what the problem is? I dabble in Excel VBA, that's all. I'm a novice - that is the point I'm trying to convey.

    Thank you, tdsg
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by tdsg; 02-15-2022 at 08:58 AM.

+ 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] #Name error appears when excel file is opened by other user
    By Apple25 in forum Excel General
    Replies: 9
    Last Post: 08-17-2020, 05:53 PM
  2. [SOLVED] assistance on vba file remains opened getting runtime error 9
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-02-2017, 03:34 PM
  3. Replies: 0
    Last Post: 11-22-2013, 07:28 AM
  4. Replies: 5
    Last Post: 10-08-2013, 04:33 PM
  5. Runtime error: File could not be found...even though I just opened it
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-20-2013, 03:41 PM
  6. [SOLVED] VBA Runtime error 9 when closing opened workbook
    By Deryl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2012, 09:18 AM
  7. Really Weird #REF Error in Complex Excel File?
    By cgmodzel in forum Excel General
    Replies: 4
    Last Post: 11-30-2006, 09:12 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