updatelinks=false

  1. W

    Form doesn't activate workbook after Unload Me

    Hello experts, not sure why this doesn't work but I want to activate a Worbook that I opened via form after the form closes but it doesn't do anything. My Code Private Sub OpenButton_Click() Dim CName As String If Country.Value = "Abu Dhabi" Then CName = "C:\IC\Intercompany Recs Middle...
  2. V

    Run time error

    Hi All, Unable to gauge why error come.. Error on red line pth = Workbooks("QDC.xlsb").Sheets("Home").Range("B7").Value Workbooks.Open Filename:=pth & shtSu, UpdateLinks:=False B7 = ="\\group$\Common\Dashboard\QDC data\"&E9&"\"&B3&"\" E9 = 2018, B3 = Folder Name (i.e. 6.Jun'18) shtSu =...
  3. V

    Workbook check - exist or not

    Hi All, Im getting an error on red line. Error - Invalid inqualifier. can any one please help If myFileExists("\\inmum-i-fs4\group$\WNA Skyline\Common\" & Uname.xls) Then Workbooks.Open Filename:="uname.xls", UpdateLinks:=False Worksheets(Uname).Select Else Set NewWb = Workbooks.Add...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top