Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FORMAT & SAVE MULTITAB WORKSHEET USING QUERYMAN

Status
Not open for further replies.
Queryman

Queryman

Programmer
Nov 4, 2002
243
US
Is there a way to kick off a process using Queryman that when the user executes a query will save the file/results automatically to excel but at the same time kick off an excel macro that will format the file for the user. And if that is possible, is there a way to store the excel macro on the server side or as part of the query/stored procedure/macro etc instead of in the user's computer?
And if all the above are possible can the formatted excel file be saved as a multitab worksheet?
Replies would be greatly appreciated.

QueryMan

 
Sort by date Sort by votes
I have not set up a process, but Excel uses Microsoft Query with an ODBC data source, why don't you skip Queryman and create the table/job directly in Excel ?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
182
Teamalone
Teamalone
tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
139
tmcrouse
tmcrouse
2009luca
  • Locked
  • Question
date format
Replies
0
Views
104
2009luca
2009luca
2009luca
  • Locked
  • Question
very hard prob with password teradata in VB& code
Replies
0
Views
70
2009luca
2009luca
larun1616
  • Locked
  • Question
USING YYYYMMDD INSIDE DBC.SYSEXECSQL() in Stored Procedure
Replies
0
Views
67
larun1616
larun1616

Part and Inventory Search

Sponsor

Back
Top