HTCondorWiki: Excel Jobs

 {subsection: Introduction}
 
+There are two approaches to running Excel in Condor jobs, one involving the Windows Scripting Host and the other involving embedded VBA code in the Excel workbooks.  The following are examples for either approach.
+
+{subsection: COM Automation}
+
 Condor can be used to run COM automation jobs using the Windows Scripting Host (WSH).  This means, for example, Condor can run jobs that automate Microsoft Excel.  What follows is a step-by-step introduction to running Excel 'jobs' in Condor.
 
 {subsection: Configuration}
@@ -96,3 +100,49 @@
   Document Saved
   Document Closed
   Done
+
+{subsection: Embedded VBA}
+
+The embedded VBA is in the actual workbook so instead of calling a script to execute Excel, Condor directly calls it.
+
+
+{subsection: Example}
+
+====
+
+*: =excel.embeddedvba.sub=:
+
+  universe     = vanilla
+  executable   = excel
+  log          = excel.embeddedvba.log.txt
+  error        = excel.embeddedvba.err.txt
+  output       = excel.embeddedvba.out.txt
+  load_profile = true
+  arguments    = /e filelocation
+  queue 1
+
+====
+
+*: =Embedded VBA Code=:
+
+Option Explicit
+On Error Resume Next
+
+Dim notCondor as Boolean
+
+Private Sub Workbook_Open()
+
+  If ActiveWorkbook.ForceFullCalculation Then
+
+    ActiveWorkbook.ForceFullCalculation = False
+    ActiveWorkbook.RefreshAll
+    ActiveWorkbook.Save
+    Application.Quit
+
+  Else
+
+    notCondor = True
+
+  End If
+
+End Sub