473,385 Members | 1,487 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,385 software developers and data experts.

Create excel spreadsheet from recordset

Hello.

Is it possible, using code, to create a spreadsheet in excel format, with
cells containing constant text and formulae and inserting data from a
recordset in specific cells?

If so, could someone point me to an information page with details on how to
achieve this?

Many thanks

PeterW
Apr 15 '06 #1
4 8117
"PeterW" <pw****@btinternet.com> wrote in
news:ZM********************@bt.com:
Hello.

Is it possible, using code, to create a spreadsheet in excel
format, with cells containing constant text and formulae and
inserting data from a recordset in specific cells?

If so, could someone point me to an information page with
details on how to achieve this?

Many thanks

PeterW

start with these:
http://www.mvps.org/access/modules/mdl0006.htm
http://www.mvps.org/access/modules/mdl0035.htm
Note to PCD: Don't go away mad, just go away.
--
Bob Quintal

PA is y I've altered my email address.
Apr 15 '06 #2
Just what I was looking for.

Many thanks.
Peterw
Apr 15 '06 #3
I am SURPRISED!!!

You did not recommend your procedure to export records to Excel that takes
hours to run!!! Since ot works, you said that it is the correct way to do
it.
"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135...
"PeterW" <pw****@btinternet.com> wrote in
news:ZM********************@bt.com:
Hello.

Is it possible, using code, to create a spreadsheet in excel
format, with cells containing constant text and formulae and
inserting data from a recordset in specific cells?

If so, could someone point me to an information page with
details on how to achieve this?

Many thanks

PeterW

start with these:
http://www.mvps.org/access/modules/mdl0006.htm
http://www.mvps.org/access/modules/mdl0035.htm
Note to PCD: Don't go away mad, just go away.
--
Bob Quintal

PA is y I've altered my email address.

Apr 15 '06 #4
I would use ole autom only for occasional work and small dataset (every
time I tried it took ages, especially if you have complex cell
formatting).

I would rather look for XML

for instance (there are several refs on the web):
http://blogs.msdn.com/brian_jones/ar...27/433152.aspx

-tom

Apr 15 '06 #5

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

Similar topics

0
by: ImraneA | last post by:
Hi there Many thanks to those people who contributed to this group, helped me greatly. Enclose, my code, hope it helps others :- Public Function Export_Excel_9(tbx1 As Variant, tbx2 As...
0
by: ImraneA | last post by:
Hi there Hope this helps others Public Function Export_Excel_10(dblocation As Variant) On Error GoTo Err_Export_Excel_10 Dim x1 As Excel.Application Dim excelwbkXL As Object
11
by: Mr. Smith | last post by:
Hello all, My code can successfully open, write to, format and save several worksheets in a workbook then save it by a given name, close and quit excel. My problem is that if I try and do it...
0
by: ImraneA | last post by:
Hi there Have a database, where front-end interface allows user to select a ms access database. From there, standard tables are linked. Routine, that creates a spreadsheet, for each table a...
3
by: acuttitta | last post by:
I ran into something really bizzaro today. A team member had me look into some export code for some data he was outputting. The data looks at shipping containers and attempts to look at how...
1
by: garry.oxnard | last post by:
Can anyone help me to solve a problem which involves switching from Access to Excel (then back to Access) programatically please? I have an Excel template which, on open, also opens an Access...
7
by: semijoyful | last post by:
OS: Win XP SP2 Access version: 2003 Excel version: 2003 I am new at this, as I am sure you have gathered from this post title:) I am working on a form where users can input data in Access and...
0
by: DrewYK | last post by:
I have the project that may never end in front of me. I am creating a routine that will take SpreadSheets from Excel and bring them into Access. I am not using any "DoCmd"s because the goal...
14
by: fkbodley | last post by:
I am trying to upload a filtered form to excel. Using code someone posted to me I tried to make this work. But like all great code for a newbee.. IT DOSENT WORK! Can some one help me out. Code:...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.