-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
updatelinks=false
-
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...- wist
- Thread
- cname excel form unload me updatelinks=false
- Replies: 5
- Forum: Excel Questions
-
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 =...- VBABEGINER
- Thread
- =group$commondashboardqdc data&e9&&b3 error shtsu updatelinks=false
- Replies: 3
- Forum: Excel Questions
-
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...- VBABEGINER
- Thread
- error filename=uname.xls updatelinks=false workbooks.open worksheetsuname.select
- Replies: 5
- Forum: Excel Questions
