Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

shell function

Comment:

Does anyone know how to close a file if it was opened using the shell function? Below is the code I currently have. 'opens file temp = Shell("C:\MSOFFICE\OFFICE11\msaccess.exe C:\Data\Encrypted\TA.mdb") 'initiates DDE channel to MS Access chan = DDEInitiate("MSACCESS.EXE", "C:\Data\Encrypted\TA.mdb") 'runs macro1 Application.DDEExecute dbs1, "Macro1" 'terminates DDE channel Application.DDETerminate chan All I need to do now is close the file TA. temp.Close does not work. I've tried some various other possibilities, but can't seem to figure it out. Any ideas? Thanks, Phil

Name: Shr0Om
Date: March 20, 2007 at 05:47:55 Pacific

Reply:

I dont think you can specify to close a spesific DB with access command line. All you can do is to close access itself (taskkill)

0

JAVA problem

php mail function

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Can anyone tell me how to run an exe, with parameters (eg. C:\cmd.exe p1 3), in VBA for Excel 97. Up until now I've been putting the command into a batch file and using the shell function to run it. ...

Summary: I wanna use a system function to deal with several data. So I use awk variable FILENAME to transfer the file directory to system command, but it does not work. I use a shell function "out_function" ...

Summary: Visual Basic 6.0 using the shell method to execute a program. but how to close it automaticly? doing so by using DDE or is it better to use the SendKeys method?? What's best and how? ...