Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 31st, 2006, 12:33 PM
kfs kfs is offline
Registered User
 
Join Date: Jul 2006
Location: Everett, WA, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Exporting to Existing Excel Worksheet from Access

I have existing Excel workbook containing numerous wkshts and charts. I want to be able to update the existing worksheets with a different Access datasource. This way I do not have to create duplicate charts. The reasons for the different datasource is I Need to display data for "All" selection that summarizes the data and 1 that is based on the selection criteria which is summarized differently. The Column numbers do not change just the rows.

Is there a way to export from Access to Excel with named ranges or to a specified worksheet.



Thanks,

Kfs
 
Old August 3rd, 2006, 09:35 AM
pjm pjm is offline
Authorized User
 
Join Date: Jul 2006
Location: Boston, MA, USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you export a query to your pre-existing Excel file it will add a worksheet having the same name as the query.

-Phil-
 
Old August 3rd, 2006, 10:56 AM
kfs kfs is offline
Registered User
 
Join Date: Jul 2006
Location: Everett, WA, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for your input, and that is the problem- Is there a work around.

K

Thanks,

Kfs




Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting From Access To Excel jimnich Access VBA 17 February 8th, 2008 07:23 AM
problem querying access, exporting to Excel neversummer84 Access ASP 1 November 22nd, 2006 12:54 AM
Accessing a Pre-existing Shape on a Worksheet excelthoughts C# 0 June 21st, 2006 02:00 AM
exporting a workbook from excel to access zisko3 Access 1 February 3rd, 2004 12:05 PM
Exporting access database to Excel .xls Squall Leonhart Classic ASP Databases 5 December 2nd, 2003 07:42 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.