I'm using Excel 2007 and I have some macros that I have exported to .bas files. I would like to import these .bas files into the personal.xls file so that they may be used whenever excel is opened. So far I have attempted to do this using a vbscript. I've got the following script which will open up a new excel workbook and import the .bas files. I just need to figure out how to get them imported into the personal.xls file and not a new excel doc, which doesn't save the macros when excel is opened.
Dim oXL, oBook, oSheet
' Create a new instance of Excel and make it visible.
Set oXL = CreateObject("Excel.Application")
oXL.Visible = True
' Add a new workbook and set a reference to Sheet1.
Set oBook = oXL.Workbooks.Add
Set oSheet = oBook.Sheets(1)
'Import previously created BAS module file