<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Chad Miller
»
Use SQL-DMO and Excel to Quickly Create...
13 posts, Page 2 of 2
««
1
2
Use SQL-DMO and Excel to Quickly Create Reports for Auditors
Rate Topic
Display Mode
Topic Options
Author
Message
Tim Edwards-235208
Tim Edwards-235208
Posted Wednesday, April 23, 2008 1:13 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, January 10, 2013 7:32 AM
Points: 4,
Visits: 366
This was a great article! Only problem is that I get a page saying "Search for any content tagged Miscellaneous & usesqldmoandexceltoquicklycreatereportsforauditors & 2064 & SQLDMO_Macros.xls" and "Sorry, nothing found for this search" when I try to download the spreadsheet. I am anxious to take a look at the spreadsheet and actually provide some much needed reporting to management.
Post #489535
FriedIzLee
FriedIzLee
Posted Thursday, February 18, 2010 7:04 AM
Forum Newbie
Group: General Forum Members
Last Login: Saturday, November 03, 2012 7:13 AM
Points: 1,
Visits: 12
I get a "Run-Time Error '429': ActiveX component can't create object" error when I "Select Server". Can you please tell me why that would happen?
Post #868007
cmille19
cmille19
Posted Thursday, February 18, 2010 5:28 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, June 05, 2013 5:01 AM
Points: 257,
Visits: 674
This is an older article I wrote. The underlying code relies on SQL-DMO which is installed with SQL Server 2000 Client Tools. I suspect you may not have SQL-DMO installed on the machine from which you are running. You can test by attempting to create a DMO object. Save the following text as a vbs file:
Set oServer = CreateObject("SQLDMO.SQLServer")
Next execute cscript.exe c:\pathtoyourfile.vbs
If no errors you have DMO installed. One other thought -- Excel macro behavior has changed in Excel 2007, be sure you're able to execute macros.
Post #868680
« Prev Topic
|
Next Topic »
13 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
