CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: mobiius

Search: Search took 0.06 seconds.

  1. Replies
    1
    Views
    548

    Re: Open excel spreadsheet as database

    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
    ...
  2. Replies
    1
    Views
    548

    Open excel spreadsheet as database

    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;" )
    ...
  3. Replies
    1
    Views
    511

    Re: Updating table data from another table

    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.
  4. Replies
    1
    Views
    511

    Updating table data from another table

    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...
  5. Replies
    5
    Views
    13,569

    Re: Send UDP Packets in VBA

    It appears to know about the undocumented StrPtr command, apparently.
  6. Replies
    5
    Views
    13,569

    Re: Send UDP Packets in VBA

    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,...
  7. Replies
    5
    Views
    13,569

    Send UDP Packets in VBA

    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...
Results 1 to 7 of 7





Click Here to Expand Forum to Full Width

Featured