Can you pass parameters tween Access N Excel?

[pdbowling]

When using this,

.Application.Run "fileName.xls!MacroName"

in Access, can any parameters be passed to the macro?

If not is there another method?

Thanks
PB

 

[Shadez]

Your answer is yes and no

No, there is no real way to pass data to excel using the method u discribed. this method only opens up a copy of excel with the file selected.

Yes. In order to edit excel spredsheet from within access u need to open excel using VBA and MSOffice Libraries. Its not that difficult.





ShadeZ

 

[pdbowling]

Thank you

PB