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.
Private Sub OpenButton_Click()
Dim CName As String
If Country.Value = "Abu Dhabi" Then CName = "C:\IC\Intercompany Recs Middle...
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
E9 = 2018, B3 = Folder Name (i.e. 6.Jun'18)
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
Set NewWb = Workbooks.Add...