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

Corss-Post
http://www.mrexcel.com/forum/excel-q...e-network.html


thank you!

[hafizimran]

Why don't you use the PasteSpecial-->Paste Link feature?
However, with the help of VBA you may use this code after opening both workbooks and activating the Sheet1 of local.xls...

Please Login or Register  to view this content.

[marreco]

Hi.
your code is opening the dialog box every time you inserted the formula!

[hafizimran]

Hi.
your code is opening the dialog box every time you inserted the formula!

Provide the path to network.xlsm in code:

'Z:\\SharedFolder\[network.xlsm]Rede_A' or as it is on your network and enclose in single quotes:

Please Login or Register  to view this content.

[marreco]

Hi
how do I get the value and not the formula?

Please Login or Register  to view this content.

[hafizimran]

Please Login or Register  to view this content.