|
|
 |
| |
Windows API/Global Declarations: Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
|
'**************************************
'Windows API/Global Declarations for :[H
' ME] ADO Recordset Export Class (CSV, HTM
' L, Excel)
'**************************************
'API used for custom DoEvents Function
Private Declare Function GetQueueStatus Lib "user32" (ByVal qsFlags As Long) As Long |
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.
Virus note:All files are scanned once-a-day by Planet Source Code for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1)Re-scan downloaded files using your personal virus checker before using it.
2)NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
3)Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
|
|
Other 1 submission(s) by this author
|
|
| |
 Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
 2/12/2005 11:02:00 AM: Hussain Mohd. Elius
345 views no comments and no votes (at this time of writing). Keep it up and you will scare all the newbies to PSC this way (I am not joking).
(If this comment was disrespectful, please report it.)
|
2/12/2005 4:56:44 PM: Capp00
I agree. I have posted a few times on here only to be flamed for doing it one way instead of the other. I think what you posted is very useful and I am tired of people only commenting when they have something bad to say. There is such a thing as "positive criticism". Would be so hard as to say something like..."Very good, Have you ever thought about trying xyz, etc.."
I don't post on here very often because, even though it has been viewed over 1000 times, nobody comments other than to complain that I didn't put a screenshot or I chose one method over another. Get a grip people. Not everyone has been programming for 20 years and you could Help them instead of degrading them. Enough of my 2 cents.
Very good I think :)
(If this comment was disrespectful, please report it.)
|
2/13/2005 12:56:37 AM: Abdul Rasheed
sometimes it happens. this is ur first submit i think. i can see the framework u have done just to upload it here. good job. i like this kind of techie job. worth to vote.
(If this comment was disrespectful, please report it.)
|
2/13/2005 5:55:29 AM: Paul Turcksin
Very useful and extremely well written and commented code. It reads (almost) like a book. Thanks for sharing, and a big fiver from me.
(If this comment was disrespectful, please report it.)
|
2/13/2005 9:04:59 PM: Hussain Mohd. Elius
This is the best I can do, being a ninth grader, and entirely self taught. It gets a little discouraging if you do not recieve comments or votes in your first submission ever. Thanks for the feedbacks everyone ;)
(If this comment was disrespectful, please report it.)
|
2/16/2005 10:33:15 AM:
Thjanks, I found very useful, expecially the HTML part, too bad about the null values, I'll work on it and let you know
(If this comment was disrespectful, please report it.)
|
2/17/2005 12:07:57 PM:
Hi Hussain Mohd. Elius,
I am trying to export the oracle data though vb recordset. Do you have any idea. I try your this code but it keep asking for Microsoft Excel 10.0 Object Library but i have 9.0.
Thanks in advance
Raj
(If this comment was disrespectful, please report it.)
|
2/22/2005 6:02:17 AM: Hussain Mohd. Elius
First of all remove the reference from Excel in the Project -> Reference and remove all the references to ExportToExcel, perhaps even delete ExportToExcel subroutine. Run it! The only time it requires Excel is when Exporting To Excel. But you can modify it a little and then run it from 9.0 if you wish. CSV and HTML exporting does not use Excel.
(If this comment was disrespectful, please report it.)
|
3/8/2005 6:34:19 AM: whoknows
clean
(If this comment was disrespectful, please report it.)
|
3/8/2005 10:59:15 PM: angeleye1963
Thanks for the code, I used your older one before this updat and had to add the refrence, but evrything is working great.Thanks good app and code.
(If this comment was disrespectful, please report it.)
|
4/1/2005 8:07:33 PM: Kevin Precht
I just downloaded your code, and haven't had the time to really look it over, but I have to say that your code is very clean, and for a self-taught 9th-grader, I think it's d@mned (had to change the word because of the offensive word filter lol) impressive. 5* from me.
(If this comment was disrespectful, please report it.)
|
8/17/2005 2:27:02 AM: Xiaosu
it's useful to my project.~~ thanks
(If this comment was disrespectful, please report it.)
|
10/6/2005 12:10:27 AM: onkelz
i'm trying to find how this work. Thanks man..
got anysite to visit ? maybe i can have more codes from u.. :-)
anw,having bad comments is a usual thing in psc. but dont give up,coz not all people does that..
Keep Up the good Work man !
(If this comment was disrespectful, please report it.)
|
10/6/2005 4:32:24 AM: Hussain Mohd. Elius
No website yet ;( but working on it... Let you all know when I'm done
(If this comment was disrespectful, please report it.)
|
11/12/2005 8:46:38 AM:
737737
(If this comment was disrespectful, please report it.)
|
11/28/2005 11:21:21 PM: rmoon
Great Job, thanks for teaching me a thing or two. 5 from me.
(If this comment was disrespectful, please report it.)
|
3/16/2006 2:19:17 AM: rizal
great job,thank for teaching me
(If this comment was disrespectful, please report it.)
|
5/10/2006 9:35:59 AM: Budi
Thanks for sharing your knowledge
(If this comment was disrespectful, please report it.)
|
5/23/2006 6:33:43 AM: Pradeep Kumar
It's a perfect way to export the recordset into csv and performance is good
(If this comment was disrespectful, please report it.)
|
2/22/2007 7:12:45 AM: AndyZa
When I try to run it it moans about a "Compile Error: Can't find project or library" on this line:
Private Progress As ProgressBar
Which Reference must I enable in VB to get it to work?
(If this comment was disrespectful, please report it.)
|
2/22/2007 8:34:14 AM: Elvis
Windows Common Control :P
(If this comment was disrespectful, please report it.)
|
9/2/2007 11:37:17 PM: ary
amazing......
(If this comment was disrespectful, please report it.)
|
7/6/2008 8:31:23 AM: Anatoly Guaniezo
eXcElLeNt! Up!
(If this comment was disrespectful, please report it.)
|
10/1/2008 10:25:46 PM:
Thanks for your good sharing! Cannot be better.
(If this comment was disrespectful, please report it.)
|
|
|
Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author from the email account you registered on the site, so you can correspond directly.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
|
To post feedback, first please login.
|
By 35 Users