C
cb
Cannot open a macro I am using in my personal workbook in excel. Error states
the macro cannot be found.
Code:
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.UserControl = True
Set xlBook = xlApp.Workbooks.Open("C:\Documents and
Settings\cb\Desktop\MASTR.xls")
xlApp.Run "personal.xls!removealphas"
xlBook.Save
xlBook.Close
xlApp.Quit
Set xlBook = Nothing
Set xlBook = Nothing
the macro cannot be found.
Code:
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.UserControl = True
Set xlBook = xlApp.Workbooks.Open("C:\Documents and
Settings\cb\Desktop\MASTR.xls")
xlApp.Run "personal.xls!removealphas"
xlBook.Save
xlBook.Close
xlApp.Quit
Set xlBook = Nothing
Set xlBook = Nothing