PDA

View Full Version : Solved: referencing a sheet and cell



chungtinhlak
01-16-2009, 05:46 PM
Hi, my file path is located in cell E1 and my file name is located in cell E2, what is wrong witht the code below?

thanks


Set wkbcognos = Application.Open(Sheets("Column Header").Range("E1").Value & Sheets("Column Header").Range("E2").Value)

chungtinhlak
01-16-2009, 05:48 PM
sorry, stupid me, i look at it over and over but didn't see it until now. i forgot workbooks between application and open. :(

sorry

Aussiebear
01-17-2009, 07:45 PM
No problem chungtinhlak, we all do this sort of thing from time to time