marreco
Well-known Member
- Joined
- Jan 1, 2011
- Messages
- 609
- Office Version
- 2010
- Platform
- Windows
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!
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!