473,399 Members | 3,038 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

Macros to run and export multiple reports

Is it possible to create a macro that will open 7 reports at once and
automatically export the results of each report into Excel? Can the
results be exported into the same Excel workbook, or will they be in 7
different workbooks? Can I create a button on the main form of my
database to run this macro?

Also, is it possible to write a macro that can open several *queries*
at once and export them into Excel? If so, will the data labels of the
fields be exported into Excel as well?

Thanks for your assistance with my questions.
Nov 12 '05 #1
0 1509

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Goran Djuranovic | last post by:
Hi everyone, I copied an asp.net project to another machine by using "Copy Project" menu item from "Project" menu in VS.NET 2003 IDE. The project contains Crystal Reports that are being exported...
0
by: Bill Sharp | last post by:
Hi, I have a Stored Procedure that takes about 20 minutes to fill a Dataset, then I bind it to a report and try to export in a PDF format. It works with my smaller reports, but not my biggest -...
0
by: Henry | last post by:
I have written an ASP/VB.Net application via VS 2003 (Crystal V9) that uses MS Access 2000 as its database. I can export reports that have no linked sub reports for printing. However, I'm unable...
7
by: Bilgehan.Balban | last post by:
Hi, In some C code I see a PRIVATE macro corresponding to the static keyword and a PUBLIC macro that has no correspondent. Why do people prefer using such macros rather than using static? Better...
0
by: JayDawg | last post by:
If anyone is willing to provide some consulting pro-bono, or for a very small charge I would really love the asistance. If anyone can fix my problem here online that would be even better. Here...
2
by: neib | last post by:
Hi I am writing a tool to extract form, report, properties to a XML format for further analysis (cross referencing etc) using Python. Reports and Forms can be accessed using AllForms,...
1
by: ellenh | last post by:
I have read postings on the similar subject including the posting from 2003 shown below. This process works fine to display a single page snapshot report in PowerPoint. I need to display...
4
by: forrestgump | last post by:
I want to be able to export multiple access query results to 1 excel worksheet so the results appear under each other. I need this to show the results of headcount, leavers and starters in a cost...
4
by: Mythran | last post by:
Reposted, originally posted in microsoft.public.vb.crystal which is not an MSDN managed newsgroup.... POST BELOW --------------------- We develop our applications and reports using Visual...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.