Vba: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 12: | Line 12: | ||
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) | 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) | ||
</pre> | </pre> | ||
= Toolbar = | |||
[http://www.makeuseof.com/tag/custom-excel-toolbar-vba-macros/ How to Build a Custom Excel Toolbar of VBA Macros] | |||
Revision as of 14:22, 31 July 2017
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)