+ Reply to Thread
Results 1 to 4 of 4

Unable to get 2 files auto refresh,auto open done, update link file closure saving failure

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    Moga, India
    MS-Off Ver
    Excel 2007
    Posts
    0

    Post Unable to get 2 files auto refresh,auto open done, update link file closure saving failure

    Dear,

    I have file which auto opens two others files & links are updated, but now files are auto opened, but links are not updated, and they dont get closed, and remain open, following is vba, it worked earlier, but now not working, kindly explain, where is the problem

    Sub Autoupdate_Irhistoryfile()
    Dim x As Workbook
    Dim y As Workbook

    Application.ScreenUpdating = False

    Application.AskToUpdateLinks = False
    Application.DisplayAlerts = False
    Set y = Workbooks.Open("C:\Users\Sethi\Google Drive\HARINDER FILES\IR CALL HISTORY FILE [Conflict 1].xlsx")
    Set x = Workbooks.Open("C:\Users\Sethi\Google Drive\HARINDER FILES\copy IR.xlsb")

    x.UpdateLink Name:="C:\Users\Sethi\Google Drive\HARINDER FILES\IR CALL HISTORY FILE [Conflict 1].xlsx", _
    Type:=xlExcelLinks
    Application.AskToUpdateLinks = True

    y.Close True
    x.Close False
    End Sub

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello princesethi2,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    06-18-2013
    Location
    Moga, India
    MS-Off Ver
    Excel 2007
    Posts
    0

    Re: Unable to get 2 files auto refresh,auto open done, update link file closure saving fai

    Sure, your reply is awaited.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Unable to get 2 files auto refresh,auto open done, update link file closure saving fai

    Hello princesthi2 and Welcome to Excel Forum
    This section of the site is set aside for introductions only. In order to have your issue addressed you will need to copy your question from post #1 and submit it as a new thread in either the Excel General or Excel Programming / VBA/ Macros section. I would also encourage you to read the directions (Forum Rules #3) pertaining to how to enclose your code in code tags.
    I hope that you have a blessed day.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Import into an Excel File, open by anyone and data always auto refresh
    By calvinfoo in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-14-2016, 04:34 AM
  2. Workbook closure and auto Saving
    By Cupragsw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2014, 09:36 AM
  3. Auto update open excel file.
    By pandp in forum Excel General
    Replies: 6
    Last Post: 09-02-2012, 07:55 AM
  4. Auto refresh data from external file when open
    By joaogvaz in forum Excel General
    Replies: 3
    Last Post: 10-16-2011, 09:40 PM
  5. Replies: 0
    Last Post: 05-15-2011, 01:23 PM
  6. Auto Refresh without open source file
    By RachealTong in forum Excel General
    Replies: 3
    Last Post: 04-19-2011, 08:30 AM
  7. Auto Open file VBA Refresh MS Query Save Close
    By gcutter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2005, 11:05 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