Hi, I'm just learning VBA, but also must deal with one thing. I must make solution to remotely change excel file value / make it useless by changing it. I was thinking about the following solution: one excel file (let's say file_A.xlsm) must take value from second file (file_B.xlsx, Sheet "verification", cell A1) and write it in it own sheet ("calculations", cell B1). and the tricky part: file_A is on local hard drive, and file_B is on ftp server value from file_B should be checked "on-line": not only on file open, but also after (with some intervals or not) It's possible ? Or maybe there is easier solution ?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

How to remotely change values in excel file ?

Thread starter Xianter
Start date May 14, 2021
Tags

ftp vba

Xianter

New Member

May 14, 2021

Hi,

I'm just learning VBA, but also must deal with one thing.
I must make solution to remotely change excel file value / make it useless by changing it.
I was thinking about the following solution:

one excel file (let's say file_A.xlsm) must take value from second file (file_B.xlsx, Sheet "verification", cell A1) and write it in it own sheet ("calculations", cell B1).
and the tricky part:
- file_A is on local hard drive, and file_B is on ftp server
- value from file_B should be checked "on-line": not only on file open, but also after (with some intervals or not)

It's possible ?
Or maybe there is easier solution ?