Using a macro stored in excel's personal workbook

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top