Good Day VBA Experts!

I have a "humdinger" for you today: I created a elaborate (recorded) VBA Macro to pre-format a new Excel Worksheet. What I want to do is call this macro from my Delphi 2010 Application and run this marco, so that when the ExcelApplication Interface displays to the User, the newly created worksheet has now been formatted.

I know how to call a Excel VBA Macro from Delphi, example below:

var
LCID : Integer;
XLFile : TFileName;
begin
LCID := GetUserDefaultLCID;
XLFile := 'BOM.xls';

with ExcelApplication1 do
begin
connect;
try
visible[LCID] := true;
Workbooks.Add(EmptyParam,LCID);
Run(XLFile + '!CreateExcelBOM1()');
 finally
Disconnect;
end;
end;
end;

The VBA Macro (severely truncated) looks like this:

[VBA]Sub CreateExcelBOM1()
'
' This Macro will attempt to re-create a simpler version of the Engineering ' Kit-up/ Bill of Materials Header and Detail sections, into which the Bill of Materials System (Engineering)
' will attempt to import BOM Data. This Version = 1.0 (21/02/2011)
'
' Keyboard Shortcut: Ctrl+Shift+B
'
'
'
ActiveWindow.SmallScroll Down:=-99
Windows("Book1").Activate
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "Bill of Materials"
Range("A14").Select
Windows("MAIN BOM TEMPLATE Vs. 1.0.xls").Activate
' And so on and so on...
End Sub[/VBA]

Now consider this: When I create this new workbook/worksheet via Delphi, effectively Excel opens up with an empty workbook/worksheet. There is NO VBA code existing in any of its Modules (yet).

My question: If I saved the previously written macro code into a Text File, can I "inject" this code into an empty Workbook Module? If so, how would I go about it?

I would have imagined that Delphi could expose workbook Modules (which it seemingly does via a XLApplication.Modules()) function. Also, as such, I should have been able to simply write ASCII to this Module in a Text (or similar) type of property...

Any ideas?

Regards from South Africa!
Deyken