Vba: Difference between revisions

From 太極
Jump to navigation Jump to search
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
= Keyboard shortcut =
Alt + F11
= Immediate Window =
= Immediate Window =
* http://www.bettersolutions.com/vba/VOK159/YD519120554.htm
* [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.


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) & "), " & _
Line 15: Line 20:
= Toolbar =
= Toolbar =
[http://www.makeuseof.com/tag/custom-excel-toolbar-vba-macros/ How to Build a Custom Excel Toolbar of VBA Macros]
[http://www.makeuseof.com/tag/custom-excel-toolbar-vba-macros/ 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 =
[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

? "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

Retrieved from "https://wiki.taichimd.us/index.php?title=Vba&oldid=39923"