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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top