Log in
Register
Menu
Log in
Register
Home
What's new
Latest activity
Authors
Forums
New posts
Search forums
What's new
New posts
Latest activity
Members
Current visitors
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Miscellaneous Sections
Tech Head - The Technology Section
Computer Discussion
Windows BackUp
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="w hole" data-source="post: 13633" data-attributes="member: 175048"><p>Hello Jimbo</p><p></p><p>Yes it seems to work OK.</p><p></p><p>I haven't confirmed the Scheduled Task yet, but the .vba runs and loads Backup.exe and runs it.</p><p></p><p>It doesn't close it at the end, but for me the main thing is that it has run.</p><p></p><p>Below is a copy of the actual .vba I made, in case there are any clues there for you.</p><p></p><p>The mistake I made was to copy the path to msbacup.exe from Explorer, but this wouldn't work because this operation needs DOS commands and the tilda descriptions in the path</p><p></p><p>Kind regards</p><p></p><p>W.H.</p><p></p><p>Dim ss</p><p>Dim starttime,waittime,currenttime</p><p>waittime = 5</p><p>Set ss = CreateObject("WScript.Shell")</p><p>ss.run "C:\PROGRA~1\ACCESS~1\BACKUP\MSBACKUP.EXE",1</p><p>starttime = Timer()</p><p>currenttime = starttime</p><p>Do Until currenttime-starttime > waittime</p><p>'Do nothing</p><p>currenttime = Timer()</p><p>Loop</p><p>ss.SendKeys "C%JODaily{Enter}%S"</p><p>Set ss = nothing</p></blockquote><p></p>
[QUOTE="w hole, post: 13633, member: 175048"] Hello Jimbo Yes it seems to work OK. I haven't confirmed the Scheduled Task yet, but the .vba runs and loads Backup.exe and runs it. It doesn't close it at the end, but for me the main thing is that it has run. Below is a copy of the actual .vba I made, in case there are any clues there for you. The mistake I made was to copy the path to msbacup.exe from Explorer, but this wouldn't work because this operation needs DOS commands and the tilda descriptions in the path Kind regards W.H. Dim ss Dim starttime,waittime,currenttime waittime = 5 Set ss = CreateObject("WScript.Shell") ss.run "C:\PROGRA~1\ACCESS~1\BACKUP\MSBACKUP.EXE",1 starttime = Timer() currenttime = starttime Do Until currenttime-starttime > waittime 'Do nothing currenttime = Timer() Loop ss.SendKeys "C%JODaily{Enter}%S" Set ss = nothing [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Miscellaneous Sections
Tech Head - The Technology Section
Computer Discussion
Windows BackUp
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top