Hi all,
I have an ASP process that creates 'reports'. At the moment these reports
are output to a semi-comma delimmeted text file that I open in XLS. I then
run a macro that formats the page correctly for printing.
What I would really like to happen is the ASP page creates either an XLS of
..DOC file that would open in excel (or word) with the contents pre-formatted
ready to print.
I have been looking, but have been unable to find anything suitable on this.
Could someone out there point me in the right direction.
Many thanks in advance,
Bill. 6 1797
How about Reporting Services? http://www.microsoft.com/sql/reporting/default.asp
-- http://www.aspfaq.com/
(Reverse address to reply.)
"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eI**************@tk2msftngp13.phx.gbl... Hi all,
I have an ASP process that creates 'reports'. At the moment these reports are output to a semi-comma delimmeted text file that I open in XLS. I then run a macro that formats the page correctly for printing.
What I would really like to happen is the ASP page creates either an XLS
of .DOC file that would open in excel (or word) with the contents
pre-formatted ready to print.
I have been looking, but have been unable to find anything suitable on
this. Could someone out there point me in the right direction.
Many thanks in advance,
Bill.
Thanks Araron,
I'm not using SQL server, just access and can only use technology 'freely'
available, unfortunately.
Bill.
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:eW**************@TK2MSFTNGP12.phx.gbl... How about Reporting Services? http://www.microsoft.com/sql/reporting/default.asp
-- http://www.aspfaq.com/ (Reverse address to reply.)
"William E Hatto" <xx***********@bigpond.net.au> wrote in message news:eI**************@tk2msftngp13.phx.gbl... Hi all,
I have an ASP process that creates 'reports'. At the moment these
reports are output to a semi-comma delimmeted text file that I open in XLS. I
then run a macro that formats the page correctly for printing.
What I would really like to happen is the ASP page creates either an XLS of .DOC file that would open in excel (or word) with the contents pre-formatted ready to print.
I have been looking, but have been unable to find anything suitable on this. Could someone out there point me in the right direction.
Many thanks in advance,
Bill.
"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eI**************@tk2msftngp13.phx.gbl... Hi all,
I have an ASP process that creates 'reports'. At the moment these reports are output to a semi-comma delimmeted text file that I open in XLS. I then run a macro that formats the page correctly for printing.
What I would really like to happen is the ASP page creates either an XLS
of .DOC file that would open in excel (or word) with the contents
pre-formatted ready to print.
I have been looking, but have been unable to find anything suitable on
this. Could someone out there point me in the right direction.
Put the data into an HTML table instead: http://support.microsoft.com/?kbid=301044
To get the formatting right, create an Excel sheet the way you want it to
look and save it as HTML - then "reverse engineer" the resulting HTML code
into your ASP.
--
Tom Kaminski IIS MVP http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS http://mvp.support.microsoft.com/ http://www.microsoft.com/windowsserv...y/centers/iis/
Thanks Tom,
Funny you said that, I was just looking at that this very moment. My god
there is some extra data to put into the file to get the desired result.
Cheers, Bill.
"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:c9*********@kcweb01.netnews.att.com... "William E Hatto" <xx***********@bigpond.net.au> wrote in message news:eI**************@tk2msftngp13.phx.gbl... Hi all,
I have an ASP process that creates 'reports'. At the moment these
reports are output to a semi-comma delimmeted text file that I open in XLS. I
then run a macro that formats the page correctly for printing.
What I would really like to happen is the ASP page creates either an XLS of .DOC file that would open in excel (or word) with the contents pre-formatted ready to print.
I have been looking, but have been unable to find anything suitable on this. Could someone out there point me in the right direction.
Put the data into an HTML table instead: http://support.microsoft.com/?kbid=301044
To get the formatting right, create an Excel sheet the way you want it to look and save it as HTML - then "reverse engineer" the resulting HTML code into your ASP.
-- Tom Kaminski IIS MVP http://www.iistoolshed.com/ - tools, scripts, and utilities for running
IIS http://mvp.support.microsoft.com/ http://www.microsoft.com/windowsserv...y/centers/iis/
update your knowledge about 'free' databases then :) http://www.microsoft.com/sql/msde/default.asp
And while this msde is a stripped down SQL server, you -still- have -much-
better performance and reliability than when you use Access.
--
compatible web farm Session replacement for Asp and Asp.Net http://www.nieropwebconsult.nl/asp_session_manager.htm
"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eV**************@TK2MSFTNGP09.phx.gbl... Thanks Araron,
I'm not using SQL server, just access and can only use technology 'freely' available, unfortunately.
Bill.
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message news:eW**************@TK2MSFTNGP12.phx.gbl... How about Reporting Services? http://www.microsoft.com/sql/reporting/default.asp
-- http://www.aspfaq.com/ (Reverse address to reply.)
"William E Hatto" <xx***********@bigpond.net.au> wrote in message news:eI**************@tk2msftngp13.phx.gbl... Hi all,
I have an ASP process that creates 'reports'. At the moment these reports are output to a semi-comma delimmeted text file that I open in XLS. I then run a macro that formats the page correctly for printing.
What I would really like to happen is the ASP page creates either an
XLS of .DOC file that would open in excel (or word) with the contents pre-formatted ready to print.
I have been looking, but have been unable to find anything suitable on this. Could someone out there point me in the right direction.
Many thanks in advance,
Bill.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Frank Millman |
last post by:
Hi all
I need to generate potentially large reports from a database, and I
want to offer the option of print preview before actually printing
(using wxPython). I figure that the best way to...
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I...
|
by: I_AM_DON_AND_YOU? |
last post by:
There is one more problem I am facing but didn't get the solution. In my
Setup Program I am not been able to create 2 things (when the program is
intalled on the client machine ) : (1) create...
|
by: Michael Sperlle |
last post by:
Is it possible? Bestcrypt can supposedly be set up on linux, but it seems
to need changes to the kernel before it can be installed, and I have no
intention of going through whatever hell that would...
|
by: barb |
last post by:
So that the world at large benefits from our efforts, here is one fully
documented way to use Windows Irfanview freeware to create thumbnail web
galleries (http://www.irfanview.com).
STEP 1:...
|
by: sandy |
last post by:
I need (okay, I want) to make a dynamic array of my class 'Directory',
within my class Directory (Can you already smell disaster?)
Each Directory can have subdirectories so I thought to put these...
|
by: Vlad |
last post by:
I am having problems using the file.create method within a function
that is called when looping through an array of filepaths.
If I call my function with a hardcoded file path --C:\Temp.txt the...
|
by: sanghavi |
last post by:
how to create a set up project in vb.net..how to run an application on a different machine
|
by: brook |
last post by:
hey all - i´m new to php and having trouble writing a simple code
which should create a file. here is the most simplified version:
<?php
$content = "my content";
$path = "test.txt";...
|
by: lxyone |
last post by:
Using a flat file containing table names, fields, values whats the
best way of creating html pages?
I want control over the html pages ie
1. layout
2. what data to show
3. what controls to...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
| |