Vba: Difference between revisions

From 太極
Jump to navigation Jump to search
(Created page with "= Immediate Window = * http://www.bettersolutions.com/vba/VOK159/YD519120554.htm Use the question mark to evaluate an expression immediately. <pre> ? "cat(" & Chr(34) & Drive...")
 
Line 3: Line 3:


Use the question mark to evaluate an expression immediately.
Use the question mark to evaluate an expression immediately.
<pre>
<pre style="white-space: pre-wrap; /* CSS 3 */ white-space: -moz-pre-wrap; /* Mozilla, since 1999 */ white-space: -pre-wrap; /* Opera 4-6 */ white-space: -o-pre-wrap; /* Opera 7 */ word-wrap: break-word; /* IE 5.5+ */ " >
? "cat(" & Chr(34) & DriveLetter & Chr(34) & _
? "cat(" & Chr(34) & DriveLetter & Chr(34) & _
     ", paste(" & Chr(34) & "cd" & Chr(34) & "," & Chr(34) & RelativePath & Chr(34) & "), " & _
     ", paste(" & Chr(34) & "cd" & Chr(34) & "," & Chr(34) & RelativePath & Chr(34) & "), " & _

Revision as of 13:42, 31 August 2015

Immediate Window

Use the question mark to evaluate an expression immediately.

? "cat(" & Chr(34) & DriveLetter & Chr(34) & _
    ", paste(" & Chr(34) & "cd" & Chr(34) & "," & Chr(34) & RelativePath & Chr(34) & "), " & _
     Chr(34) & EisenExeCommand & Chr(34) & _
    ", file=" & Chr(34) & ReplaceBackSlashesWithForwardSlashes(CStr(rgEisenCluster(7, 2))) & "RunEisenCluster.bat" & Chr(34) & _
    ", sep=" & Chr(34) & "\n" & Chr(34) & ", append=F)"

cat("C:", paste("cd","\"\\ArrayTools\\Sample datasets\\Brca\\BRCA -Project\\Output\\EisenCluster\\\""), "\"C:\\ArrayTools\\Excel\\..\\Cluster2\\Cluster 3.0\\clusterLG.exe\"", file="C:/ArrayTools/Sample datasets/Brca/BRCA -Project/Output/EisenCluster/RunEisenCluster.bat", sep="\n", append=F)