[AccessD] Export to Excel

Does anyone have sample code that will format the data in Excel (thru a
macro, I guess)?
I've never used a macro in Excel, but this sounds promising.

Thanks,
Mark

-----Original Message-----
From: Bryan Carbonnell [mailto:Bryan_Carbonnell at cbc.ca] 
Sent: Monday, February 10, 2003 11:12 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Export to Excel

Mark,

You can use Automation to do the export directly to Excel and format it
without any user interaction, other than the user clicking a button to
start the process.

Bryan Carbonnell
bryan_carbonnell at cbc.ca

>>> MarkBoyd at McBeeAssociates.com 10-Feb-03 10:48:51 AM >>>
John -

Thanks for the reply.

This may be something we can work with.

I'll run it by my boss, but I'm guessing there will be complaints about
too much user interaction.

The thing that drives me crazy is there isn't that much interaction on
the user's part.  They have to move a few fields around, or re-total a
field here and there ... not a big deal if you ask me.

 

Thanks,

Mark

 

-----Original Message-----
From: John W. Colby [mailto:jcolby at colbyconsulting.com] 
Sent: Monday, February 10, 2003 10:28 AM
To: accessd at databaseadvisors.com 
Subject: RE: [AccessD] Export to Excel

 

Mark,

 

I think you are taking the long way around the farm.  I did a lot of
movement of data between Access and Excel down in Mexico for an app
where the users used Excel Analysis on the resulting data.  What we did
is to build queries that got the data that was desired, then exported
that data directly into the spreadsheet.  You can then record a macro on
the spreadsheet as you format the data the way you want it to run.  Save
and name the macro.  Now, whenever you need to run this process, Copy a
"template" spreadsheet that has this macro in it to a new name, export
the data into the new spreadsheet, then run the macro from Access to
format the data the way you want to see it.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

	-----Original Message-----
	From: accessd-admin at databaseadvisors.com 
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Mark Boyd
	Sent: Monday, February 10, 2003 10:18 AM
	To: AccessD at databaseadvisors.com 
	Subject: [AccessD] Export to Excel

	We are having an issue with exporting data from an Access report
to an Excel spreadsheet.

	It seems that whenever there are calculated fields such as
report totals, the data doesn't display properly after exporting.

	Also, some fields are moved way to the right, while others are
way left.

	Does anyone know of 3rd party software that will export an
Access report to Excel as clean as possible?

	 

	Thanks,

	Mark Boyd

	Sr. Systems Analyst

	McBee Associates, Inc.

	 


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com