+ Reply to Thread
Results 1 to 2 of 2

Automatically open a file in a specific file path when another sheet is opened

  1. #1
    Forum Contributor
    Join Date
    06-25-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    179

    Automatically open a file in a specific file path when another sheet is opened

    Hi
    I want to open a specific sheet and refresh only said sheet when i open another sheet for example x.xls

    So opening x.xls will automatically open y.xls

    I've tried this in the workbook code area but it doesn't do anything.

    Any help would be great

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    02-08-2013
    Location
    Louisiana, USA
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Automatically open a file in a specific file path when another sheet is opened

    Take out the Me.Path & and replace it with Filename:=

    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. Replies: 2
    Last Post: 04-12-2013, 07:56 PM
  2. [SOLVED] Get file path from a cell, run a check to see if the file has a specific sheet if yes copy
    By Martha44 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2013, 03:35 AM
  3. Replies: 5
    Last Post: 09-29-2012, 12:40 PM
  4. how to open mdb access file whenever jpg image file is opened
    By thosecars82 in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2010, 08:58 AM
  5. automatically open a file at a specific time
    By juanjose in forum Excel General
    Replies: 1
    Last Post: 08-26-2009, 12:18 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