Thanks Catalin for the advise , Ill have to study the zip file you gave me!. In regards to your comment. The .Value was a Application.Run (strMa...
Just an update, I just changed the following from .Value to .Copy strMacro = ThisWorkbook.Names(strList) _ .RefersToRange.Rows(CLng(selecte...
Thanks Velouria, That sort of works! But I had another idea Sub Get_Data_From_File1() Dim sFolder As String Dim OpenBook As Workbook ' O...
Very Good Catalin, That works well, thats great. Been annoying me for 3 weeks! Thanks Steve
Mynda, Everthing works in safe mode including right click on table. I can go into Querries and connections. As sson as I drop out to normal view...
I also reset ribbon tabs. Looked at add-ins(No Add-ins) I wonder if it was because I used last month Custom UI and customised the ribbon....any ...
Yep, Rebooted, reinstalled I tried on a another laptop and it works but with mine NUP...no right click on table nor can I click on Querries and con...