ImZick Posting Whiz in Training 201 posts since Dec 2012 Reputation Points: 0 [?] Q&As Helped to Solve: 4 [?] Skill Endorsements: 6 [?] •Community Member 0 2 Years Ago Hi everyone i have a connection to my sheet like this Dim da As New OleDbDataAdapter("Select * from [EBU 2 LOB$]", con) but i want to use this Dim Sheet1_EBU as string = "EBU 2 LOB$" so that the code will be something like this i think? Dim da As New OleDbDataAdapter("Select * from [ & Sheet1_EBU &]", con) but i have a error it said could not find the the object [ & Sheet1_EBU &] How can i write it in a appropriate way?