Jump to content
Sign in to follow this  
Knut_F

Importere fra et excel regneark (vba)

Recommended Posts

Public Sub import(filnavn As String)
Dim db As DAO.Database, rs As DAO.Recordset
Set db = OpenDatabase(filnavn, False, True, _
       "Excel 8.0;HDR=Yes;")
Set rs = db.OpenRecordset("SELECT * FROM [Ark1$]")
End Sub

 

Det jeg prøver på er å importere noe som står i et excel regneark, men programmet bryter sammen etter denne linja " Set rs = db.OpenRecordset("SELECT * FROM [Ark1$]") "

Noen som har en idee om hva som er feilen?! :D

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...