[Excel VBA] Opening and running functions over network

[iceangel89]

if i have a macro from a local excel file call a function from another excel file over the network will it work? and will it increase network traffic?

i am thinking it will be ok right? cos i will be using workbooks.open() to open the file over network then call the function?

[rendrag]

it should work no problem (assuming the path is correct). It will increase traffic as much as opening an excel workbook would generate

[iceangel89]

ok thanks