+ Reply to Thread
Results 1 to 8 of 8

network path error

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    network path error

    Hi to all.
    I don't understand where the mistake is:

    this work
    Please Login or Register  to view this content.
    this not work:

    Please Login or Register  to view this content.
    error here: Filename:=

    max

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,998

    Re: network path error

    You need brackets round the arguments:

    Please Login or Register  to view this content.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: network path error

    Thanks rorya.
    And this?:

    Please Login or Register  to view this content.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,998

    Re: network path error

    You missed out the extwbk = part after the Set

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: network path error

    Please Login or Register  to view this content.
    Thanks you rorya.
    max

  6. #6
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: network path error

    Another path:


    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  7. #7
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,998

    Re: network path error

    If you are not using the result of a function (and here you are not storing the workbook returned by the OpenDataBase method), you do not enclose the arguments in brackets (unless you use Call).

  8. #8
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: network path error

    Thanks you rorya

    Please Login or Register  to view this content.
    max

+ 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] Vba to copy a file from a network path and place it to another network path location
    By ROHAN999 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-12-2018, 01:09 PM
  2. [SOLVED] OpenProcess throws an error on UNC path, but not on mapped network drive
    By wherbjr35 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2014, 09:24 AM
  3. INDIRECT.EXT function with a network path
    By connor12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2013, 03:32 PM
  4. Replies: 2
    Last Post: 09-19-2013, 09:10 AM
  5. Excel VBA get Network path from local path
    By katto01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2013, 11:31 AM
  6. Network Drive Path
    By smarta in forum Excel General
    Replies: 3
    Last Post: 04-19-2007, 11:14 AM
  7. Path to a network drive
    By CWillis in forum Excel General
    Replies: 2
    Last Post: 06-22-2006, 10:10 PM

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