Where do I enter ShellWait() ?
Remember, I need it to be in the macro section.
Merch
Last Activity: Aug 6 '10, 03:34 PM
Joined: Aug 3 '10
Location:
-
OK. Summary so far...
I used the batch file approach by using the "RunApp" action. But since Access won't wait for the Shell command to complete, I insterted a MsgBox to manually halt and continue the process. However, I don't want to do this (as I have several similar sequential processes). I need help to weave in the ShellWait() mentioned earlier.Leave a comment:
-
After thinking about it and reading comments posted here and at other sites, I see that the FileCopy command would work well for me.
FileCopy "C:\ABC\*.* " "C:\DEF\*.* "Leave a comment:
-
Yes, please, although my need is only to copy Excel files. As I understand the recommendation written by Steve Kogan, I need to use the RunCode action. But what do I write in Function Name below? I need the details. I am new to VBA.Leave a comment:
-
How can I integrate DOS batch files in MS Access?
I need to transfer entire excel files (not just a range of data) from one directory to another using an Access Macro because I want to intersperse them with my other macros in Access. I want to run one macro that will call other macros. So I am thinking I need to figure out how to run DOS Batch files from Access and incorporate them in my Access dB. I think I have to use Shell / VBA.
If, for example, my batch file was Transfer01in.ba t,...
No activity results to display
Leave a comment: