Comments by Member 12081613

Member 12081613 1-Dec-15 7:41am View

Sorry What?

Member 12081613 30-Nov-15 12:13pm View

Tried...Didnt work

Member 12081613 20-Nov-15 2:11am View

OMG string.Format("[{0}]='{1}'", columnY, columnYValue) worked. Thanks a million Matt

Member 12081613 19-Nov-15 16:58pm View

Please, if this isnt right show me how to?

Member 12081613 19-Nov-15 16:55pm View

Yes, it is but I dont get where to use the string.format line

Member 12081613 19-Nov-15 16:51pm View

Both are strings

Member 12081613 19-Nov-15 16:46pm View

I want to select rows where ColumnY=columnYValue.

Member 12081613 19-Nov-15 15:58pm View

My coloumn name here has a space between. if that could be the issue then How to fix it?

Member 12081613 5-Nov-15 0:53am View

Yes it holds the name of the excel sheet. I checked it while debugging

Member 12081613 4-Nov-15 13:10pm View

I did try that now it says filename$ is not a valid name

Member 12081613 4-Nov-15 11:14am View

Now I am getting this error once I put in the file name "The Microsoft Office Access database engine could not find the object" What does it mean?

Member 12081613 4-Nov-15 11:03am View

when I debug I see the whole path to the sheet...isnt that correct? The fill line throws the exception

Comments by Member 12081613 (Top 12 by date)