software

Hi,

My problem is as follows:

I need to take out MISs on daily basis for client. I export data from Access
to an Excell file. Then I need to do some tunings like Subtotals, adjusting
column widths, marking some rows bold and finally changing the fonts.

How can I achieve this thru macros? Any support will be well appreciated.
Thanks
--
Nabeel

Here's a general outline of the approach I take to similar goals:
1) Create an Auto_Open macro in Excel and invoke the Excel file as a Windows
Scheduled Task.
2) That macro has a list of 'temp' files to delete.
3) It then invokes Access, opening a database and running an Access macro,
which uses a series of 'Output To' statements to create my raw Excel data
files; the Access macro ends with Quit to shut down Access. (Step 2 was to
avoid a bunch of warnings from Access about overwriting existing files).
4) Back in my Excel macro, I know I've got all my data files, so I open them
up, format, print, email, etc.
5) Be sure not to email anything til, say 7:45am. When your emails go out
at 4am, they know you're up to something ;-)
(You could certainly replace the Access piece with ODBC, but I find I'm able
to do more complex queries, more easily, w/in Access).
My two cents. --Bruce

quot;Nabeelquot; wrote:

gt; Hi,
gt;
gt; My problem is as follows:
gt;
gt; I need to take out MISs on daily basis for client. I export data from Access
gt; to an Excell file. Then I need to do some tunings like Subtotals, adjusting
gt; column widths, marking some rows bold and finally changing the fonts.
gt;
gt; How can I achieve this thru macros? Any support will be well appreciated.
gt; Thanks
gt; --
gt; Nabeel

Hey Bruce,

Thanks for the perfect advice. You take care.
--
Nabeelquot;bpeltzerquot; wrote:

gt; Here's a general outline of the approach I take to similar goals:
gt; 1) Create an Auto_Open macro in Excel and invoke the Excel file as a Windows
gt; Scheduled Task.
gt; 2) That macro has a list of 'temp' files to delete.
gt; 3) It then invokes Access, opening a database and running an Access macro,
gt; which uses a series of 'Output To' statements to create my raw Excel data
gt; files; the Access macro ends with Quit to shut down Access. (Step 2 was to
gt; avoid a bunch of warnings from Access about overwriting existing files).
gt; 4) Back in my Excel macro, I know I've got all my data files, so I open them
gt; up, format, print, email, etc.
gt; 5) Be sure not to email anything til, say 7:45am. When your emails go out
gt; at 4am, they know you're up to something ;-)
gt; (You could certainly replace the Access piece with ODBC, but I find I'm able
gt; to do more complex queries, more easily, w/in Access).
gt; My two cents. --Bruce
gt;
gt; quot;Nabeelquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; My problem is as follows:
gt; gt;
gt; gt; I need to take out MISs on daily basis for client. I export data from Access
gt; gt; to an Excell file. Then I need to do some tunings like Subtotals, adjusting
gt; gt; column widths, marking some rows bold and finally changing the fonts.
gt; gt;
gt; gt; How can I achieve this thru macros? Any support will be well appreciated.
gt; gt; Thanks
gt; gt; --
gt; gt; Nabeel