formula via VBA within another file on the network

[marreco]

Hi.

I have a file name like (network.xlsm) on the network where I work.


and I'm using another file (local.xls), I would like to use VBA to put a formula in workbook (local.xls) guide ("Sheet1"). [B1: Q300]


Within the workbook file (local.xls) guide ("Sheet1"). [B1: Q300]
From B1 to Q300
= [network.xlsx] Rede_A! B1
= [network.xlsx] Rede_A! B2
= [network.xlsx] Rede_A! B3
= [network.xlsx] Rede_A! B4
= [network.xlsx] Rede_A! B5




thank you!

 

[marreco]

Hi
Any idea?

Thank you!!

 

[marreco]

Hi
Any idea?

Thank you!!

 

[marreco]

Hi
Any idea?

Thank you!!

 

[marreco]

Hi

Cross-Post
formula via VBA within another file on the network