UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Worksheet Name, Office 2003    
 
   
Teddy B
post Jul 9 2010, 02:41 PM
Post #1

UtterAccess Addict
Posts: 198
is there a way(VBA code or Macro) to change the name of a query upon export to an excel file using Transferspreadsheet? The purpose being I don't want to result tab name to be the same as my query name.

Example: I want to export the query (qry_001_002) to the file (c:file/export.xls) but want the resulting tab name to say (Summary).

Go to the top of the page
 
+
vtd
post Jul 10 2010, 04:34 AM
Post #2

Retired Moderator
Posts: 19,667
Properly, I think you need to automate Excel by code, open the export file and change Worksheet name.

A lazy work-around is to copy the Query to the required name "Summary", then use the Query "Summary" for the TransferSpreadsheet then delete the Query "Summary". But then, you can simply rename the Query to "Summary" permanently and not to bother with copying every time?
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 09:21 PM