Vba: Difference between revisions
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
= Immediate Window = | = Immediate Window = | ||
* | * [https://www.excelcampus.com/vba/vba-immediate-window-excel/ 5 Ways to Use the VBA Immediate Window in Excel]. | ||
** Pressing '''Ctrl+G''' opens the Immediate Window or View menu > Immediate Window. | |||
** Use the question mark to evaluate an expression immediately. | |||
** Press the Enter key. | |||
{{Pre}} | |||
? "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) & "), " & _ | ||
| Line 26: | Line 28: | ||
= VBA techniques = | = VBA techniques = | ||
[https://www.extendoffice.com/excel.html Tips And Tricks For Excel] from extendoffice.com. | [https://www.extendoffice.com/excel.html Tips And Tricks For Excel] from extendoffice.com. | ||
= Checking If a Workbook is Open Using VBA and Executing from R = | |||
[https://www.r-bloggers.com/2024/08/checking-if-a-workbook-is-open-using-vba-and-executing-from-r/ Checking If a Workbook is Open Using VBA and Executing from R] | |||
Latest revision as of 21:06, 8 August 2024
Keyboard shortcut
Alt + F11
Immediate Window
- 5 Ways to Use the VBA Immediate Window in Excel.
- Pressing Ctrl+G opens the Immediate Window or View menu > Immediate Window.
- Use the question mark to evaluate an expression immediately.
- Press the Enter key.
? "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)
Toolbar
How to Build a Custom Excel Toolbar of VBA Macros
How to merge excel files and sheets
https://www.makeuseof.com/tag/merge-excel-files-sheets/
load DLL from Excel VBA
VBA techniques
Tips And Tricks For Excel from extendoffice.com.
Checking If a Workbook is Open Using VBA and Executing from R
Checking If a Workbook is Open Using VBA and Executing from R