PDA

View Full Version : [SOLVED] Pass value to sub in .xla



mdmackillop
06-08-2005, 09:31 AM
Can I pass a value to a sub routine in a .xla file?
I've tried

Application.Run "Valbook.xla!PageStart 40"
with no success.

JKwan
06-08-2005, 11:59 AM
I think you should be able to pass values to an XLA. I referenced my xla then call it by MyFunction.Procedure (xxx)

That worked for me

for you may be Valbook.PageStart (40)?

mvidas
06-08-2005, 12:04 PM
Malcolm,
Have you tried

Application.Run "Valbook.xla!PageStart", 40
Seems like one of those silly syntax moments :doh:
Matt

mdmackillop
06-08-2005, 03:30 PM
Thanks Matt and JKwan. I missed the comma!:banghead: