+ Reply to Thread
Results 1 to 2 of 2

Run-time 1004 Workbook Open

  1. #1
    Registered User
    Join Date
    04-08-2015
    Location
    America
    MS-Off Ver
    Office 2013
    Posts
    29

    Run-time 1004 Workbook Open

    I have a workbook setup to run a few macros when it is opened. I locally built the spreadsheet and saved it to a network for others to use.
    I have never had an issue till this morning. The issue doesn't occur if I open the workbook locally.

    I get run-time error 1004 upon opening and it points to the code executed. below is an example of some code that errors.
    Please Login or Register  to view this content.
    I think it is an issue when the workbook is copied from my local to the network. I can work around the error by activating the current worksheet.

    Please Login or Register  to view this content.
    Any help on this would be appreciated.

    Cheers,

    nKife
    Last edited by nKife; 03-01-2016 at 08:28 PM. Reason: Solved

  2. #2
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Run-time 1004 Workbook Open

    Hi nKife,

    Your symptoms may point to a Workbook that got ahead of itself. I don't understand the why, but the how has fixed similar problems for me.

    Typically I want to reference ThisWorkbook or Select a Worksheet at Workbook_Open() and Excel thinks the Excel file is a temporary file. The following usually works for me.

    Typical code that may not work:
    Please Login or Register  to view this content.
    Typical code that usually works:
    Please Login or Register  to view this content.
    I hope this helps.

    Lewis

+ 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. Run-time error 1004 The query did not run, or the databse could not be open
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2015, 06:22 AM
  2. Run-time error '1004':Unable to open
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2014, 05:56 AM
  3. Replies: 0
    Last Post: 10-20-2014, 05:33 PM
  4. Misterious Run-time error 1004 on Workbook Open
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2014, 10:09 AM
  5. Run-time error '1004': Unable to open
    By Nordeen1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2012, 01:34 PM
  6. Error 1004 and 424 upon workbook open
    By jjohanni in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-06-2011, 02:09 PM
  7. workbook.open throws 1004 error
    By gary.smith@primeexalia.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2006, 06:45 PM

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