+ Reply to Thread
Results 1 to 4 of 4

vba code to open xlsm file from Network Path

  1. #1
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    vba code to open xlsm file from Network Path

    Hi all,

    Please help me on this need , i am applying below vba code to open file But its not working !!!!!!!

    workbooks.open ("\\june\violet\meeting.xlsm")

    the file is in network path

    could someone help me what i should apply for vba code to handle this..

    please

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: vba code to open xlsm file from Network Path

    Remove the brackets, should work fine.

    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    Re: vba code to open xlsm file from Network Path

    HI, Thanks for the reply.

    I tried even this.....but not working. says path not found.
    I checked the path, while i access via hyperlink manually it is working. But when i do via vba its not working.

    Please help

  4. #4
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: vba code to open xlsm file from Network Path

    use
    Please Login or Register  to view this content.

+ 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. Code Starts itself as I open the XLSM file, and it should not
    By mortphil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2013, 08:03 AM
  2. Replies: 3
    Last Post: 05-21-2013, 08:22 AM
  3. Excel 2010 VBA code to determine username of open file on network
    By bcopland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2011, 04:12 AM
  4. Saving .xlsx in a network folder through a .xlsm file
    By jambai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2011, 04:09 PM
  5. Open Workbook using URL instead of network path
    By Raul in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2006, 11:55 AM

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