Page 3 of 3 FirstFirst 123
Results 21 to 27 of 27

Thread: Failing to Find File
Thanks Thanks: 0 Likes Likes: 0

  1. #21
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    Your email ended up in spam. However I did open the workbook - enabled the code, some things happened i can't spare the time to try and figure out everything but it seems to be working normally on my machine (W10 Ent + Office 365 ProPlus)

    I think it is not explicitly a code problem - apart from several debug messages nothing out of the ordinary - wb hides then unhides, opens first time. everything looks OK.

    One more thing to try - change the filename slightly ant try to open it again ( or create a copy with a different name and try to run it).
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

  2. #22
    Board Regular
    Join Date
    Oct 2018
    Posts
    500
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    settings fixed (I was reverting each one individually as my testing failed- trying to narrow down the problem)....

    regarding the hide/unhide- no. All buttons are grayed out except the macros button. Hitting that opens up the macro list window but it's empty. So this literally looks like a copy of excel without a workbook loaded at all. All menus are grayed basically except developer where I can record a macro, etc. Com add-ins are all unselected. If I hit "Check Accessibility" under Review, it says unable to run blah blah blah because no workbook is open to check for accessibility issues.

  3. #23
    Board Regular
    Join Date
    Oct 2018
    Posts
    500
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    The workbook itself seems to work perfectly, names changed and all.

    I am curious- where did you get a debug message? Just when I think I've got one worked out I end up shooting myself in the foot with a new one....

    The whole issue I had was just how excel was opening.....just not sure what to do there.

    Changing file names resulted in the workbook opening as it should with the different names, so all good there.

  4. #24
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    I am glad this helped.

    I got an error while the code was trying to save some values in the developer sheet. But i don't even remember the error number.
    something like: sheets("Developer").range(...).FormulaR1C1="'No"
    This was after I didn't provide the correct (any) password to gain developer access
    I didn't follow it to investigate - just thought maybe the sheet was not properly unlocked for some reason since I didn't even know how to use this file.
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

  5. #25
    Board Regular
    Join Date
    Oct 2018
    Posts
    500
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    Interesting. I'll look into the error.

    Yeah- not sure how to go about excel except maybe a clean install at this point....

  6. #26
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    I wouldnt bother reinstalling.
    Its a single file name problem. It is not the first time I've heard of it but I still don't know the reason - just some vague idea in the back of my head.
    However if the fix is a simple rename - why bother too much
    Cheers.
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

  7. #27
    Board Regular
    Join Date
    Oct 2018
    Posts
    500
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    sorry I think there's a little confusion there- it's not just this file. Originally it was but it's gotten worse and it's not file association (.xlsm) either....I just tried a .xlsb and a .xls and had the same problem

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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