Displaying 2 results from an estimated 2 matches for "vbnormalfocus".
2010 Apr 18
2
how to use Excel VBA's Shell() to call and execute R file
...el VBA/macro Shell() function to call R and
execute R_test.R file. The syntax is *Shell(pathname*[*,windowstyle*]*)*
I wrote an Excel macro RunRcode like this:
Sub RunRcode()
Dim RetVal
RetVal = "C:\Program Files\R\R-2.10.1\bin\Rgui.exe & C:\R_test\R_test.R”
RetVal = Shell(RetVal, vbNormalFocus)
End Sub
When this macro is run, the R is opened but R_test.R file is ignored.
If I change RetVal = "C:\Program Files\R\R-2.10.1\bin\Rgui.exe &
C:\R_test\R_test.R”
To RetVal = "C:\Program Files\R\R-2.10.1\bin\Rgui.exe&C:\R_test\R_test.R”
(that is, no space before and aft...
2005 Nov 17
0
problem with shell and acccess 97
...; "\informes.mdb"
strCmd = SysCmd(acSysCmdAccessDir) & "\MSAccess.exe " _
& Chr(34) & strDB & Chr(34) & " /wrkgrp " & Chr(34) &
DBEngine.SystemDB & Chr(34) _
& " /Runtime"
Call Shell(strCmd, vbNormalFocus)
DoEvents: DoEvents: DoEvents
Err.Clear ' Borra el objeto Err si se produce un error.
' Establece la variable de objeto para hacer referencia al archivo que
desea ver.
Set MiAccess = GetObject(CaminoAlServidor & "\Informes.mdb")
MiAccess.C...