Re: Object required for (Wscript.sleep 15000)

benazir wrote:
> Dear Howard,
>
> I got your backup code from the Dizwell web site.

In which case, perhaps you could have followed the advice on that site as to how to contact me? I'm not sure everyone else here wants to go through a discussion like this.

> It seems a very good way to perform backup via macro but it may
> contains some bug,which one can found initially when it run through
> the Excel.

Well, the bug would be running it through Excel! The site says nothing about doing that. It wasn't written for that. And I never intended it should be run like that (performing a database backup via a spreadsheet seems a curious way to go about things, to say the least).

> For Example:
> When we run the following macro in Excel, we got errors like:

Sorry. The bit about running a "macro in Excel" rules the whole thing moot. Save it as a .vbs file on the desktop of the Windows server hosting the databaase, and double-click it as asked. It runs just fine.

> 1. Object required for (Wscript.sleep 15000)

See, that's a perfectly standard bit of Windows Scripting (This is WINDOWS scripting, not VB Scripting). It just pauses the code for 15 seconds.

> Could you please suggest about it?

Yes. Understand that Windows Scripting Host is not quite the same thing as VB Script. Try and follow the instructions on the website as to how to run it (it mentions Excel not once!). And if you have any further difficulties, try contacting me at my email address, not in a public forum that is designed for other matters (this isn't a Windows Scripting group, for example).

Regards
HJR Received on Wed May 05 2004 - 02:58:32 CDT