Hello all,
im kinda new with VBA, but need to resolve one issue - quite hard for me
Normally if I have both files on my hard drive it would be quite easy, but i have no idea how to conntect with file on FTP server
Is there any (preferable not very complicated...) way of implementing Excel VBA code, that could do the following things:
Macro_1 - button in file_1
File_1 (local) - let's say A1 cell
copying value from A1 to another workbook (file_2, on FTP server) to cell B2
Macro_2 - button in file_1
copying value from file_2 (FTP) let's say cell B4 to our local file_1 , to cell A6
File_1 could have diffenet names / be in different locations, so we should operate as active workbbok ?
Any help would be much appreciated
im kinda new with VBA, but need to resolve one issue - quite hard for me
Normally if I have both files on my hard drive it would be quite easy, but i have no idea how to conntect with file on FTP server
Is there any (preferable not very complicated...) way of implementing Excel VBA code, that could do the following things:
Macro_1 - button in file_1
File_1 (local) - let's say A1 cell
copying value from A1 to another workbook (file_2, on FTP server) to cell B2
Macro_2 - button in file_1
copying value from file_2 (FTP) let's say cell B4 to our local file_1 , to cell A6
File_1 could have diffenet names / be in different locations, so we should operate as active workbbok ?
Any help would be much appreciated