M
Mirom
Dear colleagues,
Is it possible, with VBA, to set the point of Object Type
variable-FileSystemObject, to the file system(ie. drives, folders &
files) of another PC(other then the one which runs that VBA code),
through the simple LAN connection.
Actualy I need to backup some workbooks from, let's say "PC1" to
"PC2", via LAN. The problem is that the full path of backup folder on
"PC2" could change periodicaly(adding/removing hard disks/partitions =
drive letter change). So, before actual backup I need to
search/examine file system(Scripting.FileSystemObject) on "PC2" and
depending of the result of such examination, to aply different backup
option.
Thank You in advance. Regards, Mirom.
Is it possible, with VBA, to set the point of Object Type
variable-FileSystemObject, to the file system(ie. drives, folders &
files) of another PC(other then the one which runs that VBA code),
through the simple LAN connection.
Actualy I need to backup some workbooks from, let's say "PC1" to
"PC2", via LAN. The problem is that the full path of backup folder on
"PC2" could change periodicaly(adding/removing hard disks/partitions =
drive letter change). So, before actual backup I need to
search/examine file system(Scripting.FileSystemObject) on "PC2" and
depending of the result of such examination, to aply different backup
option.
Thank You in advance. Regards, Mirom.