Search:

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
...

Hello, another problem.

I have VBA code which will open a csv file as a database. This works fine, and is included below:


With DBEngine.OpenDatabase( PathName, False, False, "Text;" )
...

If anyone wants to know, I solved this by brute forcing it.

I used an update query, then an append query. Not elegant but effective.

Hello. I'm creating a database for a reporting system for my work and have a question I'm hoping someone can answer.

First of all, some details.

I'm using Access 2010 for the database, VBA for...

It appears to know about the undocumented StrPtr command, apparently.

Thanks for replying. I believe it does use pointers as the dll needs the strings of data, and the code conversion was passing the array ByReference.

I'll have a look at manual pointers now anyway,...

First of all, Hello!

Righto, I'm writing a program which will be used as a simple debugger app whilst developing/testing various reports at work. I have the debugger finished which listens for...