Results 1 to 2 of 2

Thread: ASP Excel

  1. #1
    Join Date
    Sep 2006
    Posts
    8

    Unanswered: ASP Excel

    I want to move some data coming from 1-2 queries i use in one .asp page to an excel sheet file?
    How can I manage this ???

  2. #2
    Join Date
    Sep 2006
    Posts
    8

    Never

    NEver mind I figured it out.

    Using...

    set fso = createobject("scripting.filesystemobject")
    Set act = fso.CreateTextFile(server.mappath(""&g_filename & "-"& month(date())& day(date())& year(date()) &".xls"), true)

    act.WriteLine "<html xmlns:x=""urn:schemas-microsoft-comffice:excel"">"
    act.WriteLine "<head>"


    I replied to myself !!!

Posting Permissions

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