By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,701 Members | 1,928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,701 IT Pros & Developers. It's quick & easy.

Please help friends

P: n/a
NRB
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
-----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
TransferSpreadsheet method. Read the VBA help function on
TransferSpreadsheet Method.

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

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

iQA/AwUBQSpmV4echKqOuFEgEQKPaACg6fWpvP1tBWkZ8IDeR0f2iq g9KssAoJwe
7C5SLGS+kMGBwxq50cQmoPvz
=gZ4Z
-----END PGP SIGNATURE-----
NRB wrote:
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.


Nov 13 '05 #2

P: n/a
bn********@rediffmail.com (NRB) wrote in message news:<e4**************************@posting.google. com>...
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


Read this:
http://www.mvps.org/access/modules/mdl0035.htm
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.