Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Meenachi Suppiah   on Aug 24 In MS Office Category.

HOW TO RUN OTHER APPLICATIONS OR BACK_UP BATCH FILE FROM EXCEL


  
Question Answered By: Jet Brown   on Aug 24

You really should consider using the VBA version of this.
It runs faster, and it allows for error  handling (if necessary).

try:
Sub Button1_Click()
dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
fso.copyfile "C:\Tally\*.*", "D:\Tally\", True
End Sub

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 


Tagged: