To the best of my knowledge, nothing in OPENROWSET can be a variable. It either needs to be hard-coded or be dynamic SQL. As previously suggested, be careful to ensure that your dynamic SQL is bullet proof when it comes to SQL Injection.
--Jeff Moden
Change is inevitable... Change for the better is not.