PC Review


Reply
Thread Tools Rate Thread

Code for exporting to worksheet

 
 
=?Utf-8?B?S0xS?=
Guest
Posts: n/a
 
      5th Apr 2006
I need some code that will allow me to export a query to a specific worksheet
within a workbook.

Can anybody help?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?S2xhdHV1?=
Guest
Posts: n/a
 
      5th Apr 2006
Unless there is more to your question than you are asking, you don't really
need any code. Althought regarding the Range argument, VBA Help says:
"When you export to a spreadsheet, you must leave this argument blank. If
you enter a range, the export will fail."
It is not true. You can use the Range argument for exports.

"KLR" wrote:

> I need some code that will allow me to export a query to a specific worksheet
> within a workbook.
>
> Can anybody help?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get worksheet change code to work on protected worksheet? StargateFan Microsoft Excel Programming 4 16th Feb 2009 02:40 PM
Exporting into a Worksheet Paul Peterson - Velox Consulting, LLC Microsoft Excel Misc 7 22nd Oct 2008 01:47 PM
Altering code to reference the worksheet before the active worksheet KimberlyC Microsoft Excel Programming 8 15th Mar 2005 10:26 PM
Return to previous worksheet after code pastes in another worksheet? Ron Microsoft Excel Programming 4 4th Sep 2004 07:52 PM
Worksheet.Calculate code no longer executes on worksheet launch? Arris Microsoft Excel Worksheet Functions 1 28th Jan 2004 02:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:00 PM.