Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Pat is offline
external usenet poster
 
Posts: 210
Default Remove Access query name title from Excel spreadsheet

I often export Access queries into Excel format and then do further work on
them in Excel. When I print the resulting Excel files, they retain the
Access query name as a title. How do I get rid of the Access title?

Thanks,
Pat
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default Remove Access query name title from Excel spreadsheet

You can do one of the following:

1. Rename the worksheet tab, which automatically is assigned the query name
2. Name the Access query the name you want the workbook to use when printing
--
Kevin Backmann


"Pat" wrote:

I often export Access queries into Excel format and then do further work on
them in Excel. When I print the resulting Excel files, they retain the
Access query name as a title. How do I get rid of the Access title?

Thanks,
Pat

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I use MS Query in Excel like an Append Query in Access Sam Wardill Excel Discussion (Misc queries) 0 April 11th 06 02:41 PM
Renaming Access Query used by Excel UEUC2 Excel Discussion (Misc queries) 1 December 13th 05 05:19 PM
Running Access Query from Spreadsheet Bean123r Excel Discussion (Misc queries) 0 June 13th 05 04:21 PM
Microsoft Query rejects "nz" function in Access Query Vaughan Excel Discussion (Misc queries) 0 May 4th 05 05:20 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"