View Full Version : Solved: Call a macro stored in Personal.xls
Marcster
02-08-2006, 03:14 AM
Hi people,
How do I call a macro via VBA which is held in Personal.xls?
Tried the usual:
Call ThisIsInPersonal
but errors with:
Sub or Function not defined.
Thanks,
Marcster.
Marcster
02-08-2006, 03:23 AM
I've sorted it now.
Run ("PERSONAL.XLS!ThisIsInPersonal")
Thanks,
Marcster.
Cyberdude
02-08-2006, 09:00 PM
Hey, Marcster, I don't quite understand what you are trying to do. Referring to a macro should result in an automatic search in all your references including Personal.xls. You shouldn't have to qualify it in any way. That's why Personal is such a handy place to put common macros.
Bob Phillips
02-09-2006, 01:56 AM
Hey, Marcster, I don't quite understand what you are trying to do. Referring to a macro should result in an automatic search in all your references including Personal.xls. You shouldn't have to qualify it in any way. That's why Personal is such a handy place to put common macros.
That is not correct. You either have to use Run to call a macro in another workbook, or you need to set a reference to that project.
Marcster
02-09-2006, 02:30 AM
Hi Guys,
Sorry :o: ,
I should of posted:
Run "PERSONAL.XLS!ThisIsInPersonal", msg
As in (in workbook:)
Sub testDisplayMessageInPersonal()
Dim msg As String
msg = "Heres some text"
Run "PERSONAL.XLS!ThisIsInPersonal", msg
End Sub
In PERSONAL.XLS:
Sub ThisIsInPersonal(strMsg As String)
MsgBox strMsg
End Sub
Marcster.
Zack Barresse
02-09-2006, 08:14 AM
Fwiw, I generally recommend staying away from setting a reference to another workbook. I think it's bad habit and it can create an error-prone environment which can be hassling to the user(s).
Cyberdude
02-10-2006, 04:00 PM
xld and maracster, sorry for the bum recommendation. I've had Personal referenced to all my workbooks for so long that I forgot I did it. I was thinking that you get that reference for free, so to speak. I guess it isn't automatic after all.footinmout
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.