+ Reply to Thread
Results 1 to 5 of 5

A Classic Run-Time 1004

  1. #1
    Registered User
    Join Date
    12-18-2009
    Location
    Leeds
    MS-Off Ver
    Excel 2003
    Posts
    5

    A Classic Run-Time 1004

    I have a bit of VBA which updates connections in a workbook to a new server and/or database name, which you can then update all the tables with. It is useful because I have a lot of SQL linked tables, which would take a lot of time to update manually.

    Before anyone says I should use PowerPivot, I'll say that I tried, and unfortunately it regularly crashed or threw up errors. This way works. Sort of...

    So, the problem is that at the moment it seems to be throwing a 1004 error, though I'm sure it has been working in the past. A

    Here is the code:

    Please Login or Register  to view this content.
    cn.OLEDBConnection.Connection... etc is the error line.


    Any help would be very gratefully received!
    Last edited by AMCAlex; 07-08-2013 at 06:49 AM. Reason: Clarification

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: A Classic Run-Time 1004

    Possibly this? http://support.microsoft.com/kb/818808

  3. #3
    Registered User
    Join Date
    12-18-2009
    Location
    Leeds
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: A Classic Run-Time 1004

    Quote Originally Posted by Kyle123 View Post
    No, I don't think so. I'm running Excel 2013.

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: A Classic Run-Time 1004

    Where are you getting your error?

  5. #5
    Registered User
    Join Date
    12-18-2009
    Location
    Leeds
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: A Classic Run-Time 1004

    Quote Originally Posted by Kyle123 View Post
    Where are you getting your error?

    I later added this to the original post. The error is on the n.OLEDBConnection.Connection... etc line.

    It is a really strange one, because I am sure I've used this before. Perhaps I'm just being blind to something I've accidentally deleted.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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