Please help friends

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • NRB
    #1

    Please help friends

    Dear friends,
    Please help me.I am new to VBA programming in access.I need to open a
    query in MS access database and send those data to a existing excel
    sheet with the formulas.
    Please help me with the code.Can anyone pst a code.I need the data to
    be transferred to the existing excel sheet as that sheet contains many
    formulas.
    Thanks
    Nithin
    Tags: None
    • MGFoster
      #2
      Re: Please help friends

      -----BEGIN PGP SIGNED MESSAGE-----
      Hash: SHA1

      For a more accurate placement in the spreadsheet, use Excel's import
      data (get data) option (under the Data menu).

      If that doesn't work, 'cuz of VBA functions in the Access query, you can
      only export an Access query's results to a separate worksheet. Use the
      TransferSpreads heet method. Read the VBA help function on
      TransferSpreads heet Method.

      --
      MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
      Oakland, CA (USA)

      -----BEGIN PGP SIGNATURE-----
      Version: PGP for Personal Privacy 5.0
      Charset: noconv

      iQA/AwUBQSpmV4echKq OuFEgEQKPaACg6f WpvP1tBWkZ8IDeR 0f2iqg9KssAoJwe
      7C5SLGS+kMGBwxq 50cQmoPvz
      =gZ4Z
      -----END PGP SIGNATURE-----


      NRB wrote:
      [color=blue]
      > Dear friends,
      > Please help me.I am new to VBA programming in access.I need to open a
      > query in MS access database and send those data to a existing excel
      > sheet with the formulas.
      > Please help me with the code.Can anyone pst a code.I need the data to
      > be transferred to the existing excel sheet as that sheet contains many
      > formulas.[/color]

        Comment

        • Pieter Linden
          #3
          Re: Please help friends

          bnithinraj@redi ffmail.com (NRB) wrote in message news:<e4e8807d. 0408230357.60ca 8207@posting.go ogle.com>...[color=blue]
          > Dear friends,
          > Please help me.I am new to VBA programming in access.I need to open a
          > query in MS access database and send those data to a existing excel
          > sheet with the formulas.
          > Please help me with the code.Can anyone pst a code.I need the data to
          > be transferred to the existing excel sheet as that sheet contains many
          > formulas.
          > Thanks
          > Nithin[/color]

          Read this:
          Modules: Transferring Records to Excel with Automation
          http://www.mvps.org/access/modules/mdl0035.htm

            Comment

            Previous template Next
            Working...