Results 1 to 3 of 3

Thread: Export2Exl

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Export2Exl

    I could develop such a Calender in a report format, is there any way export it to EXCEL
    Attached Thumbnails Attached Thumbnails uk.jpg  

  2. #2
    Join Date
    Aug 2003
    Posts
    106
    I have been having similar problems with Excel based documents. There is a way of exporting reports but they lose a lot of their formatting with the export.

    It is far better (although a little more complicated) to actually create the spreadsheet in code from Access.

    Dim Excel as Object

    Set Excel = CreateObject("Excel.Application")
    Excel.Application.Visible = True '(true or false)


    From this point you can use any code that you would be able to use in Excel VBA, for example: Excel.Application.Open Workbooks:="C:\myWorkbook.xls"

  3. #3
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: Export2Exl

    Originally posted by hammbakka
    I could develop such a Calender in a report format, is there any way export it to EXCEL
    Sorry, no advice. But it looks neat though.

    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •