Never mind, I've solved it like so:
With DBEngine.OpenDatabase( PathName & FileName, False, False, "Excel 8.0;" )
With .OpenRecordset( "SheetName$NamedRange" )
While Not .EOF
|CodeGuru Home||VC++ / MFC / C++||.NET / C#||Visual Basic||VB Forums||Developer.com|
Type: Posts; User: mobiius
Search: Search took 0.02 seconds.
Results 1 to 7 of 7
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.