Recent content by AnnePep

  1. A

    Paste Image stored in Access Table into Excel?

    Hi, I have an image stored as an OLE Object in a table in access. (Our company Logo - bitmap file) I currently have code that creates an invoice in excel using vba, and I would like to insert our logo from the table in access, into excel. Has anyone had any experience with this? We are trying...
  2. A

    Transferspreadsheet question

    Hi, I am working on a program that will import a spreadsheet of billing information that is emailed to us monthly. I have code so that the user just clicks "Import Billing data" and they are prompted for the path and filename. I then use the Transferspreadsheet method to place the data in a...
  3. A

    Run time error 9 subscript out of range

    nah - not a genius, just wrote some bad code...;) I do a lot of excel automation and have run into this error before. Glad I could help! Anne
  4. A

    Run time error 9 subscript out of range

    I tried it out - you need to change: Set objxlwrksht = objxlwrkbk.Worksheets("sheet1") to Set objxlwrksht = objxlwrkbk.Worksheets("null") It seems that when creating the new workbook, excel will name the worksheet after the object your are outputting. (Just curious - do you have a table...
  5. A

    Run time error 9 subscript out of range

    Check that you have a worksheet called "sheet1". If it isnt there, you will get that error. HTH Anne
See more
Back
Top Bottom