W
windsurferLA
I have structured an Excel97 file located on a server so that it is
accessible to multiple individuals. The Excel file on a server can be
opened merely by placing the location of the file in a browser window
and selecting it. The Excel file can be saved to a server using the
SaveAs window. Furthermore, a Visual Basic Command of the form shown
below (with the appropriate IP address) can be used to mechanize the
Save process.
ActiveWorkbook.SaveAs FileName:= _
"ftp://70.86.210.194/public_html/Actions/FTP-test-0.xls", _
FileFormat:=xlNormal, Password:="larents", writeResPassword:
="6821loubet", _
ReadOnlyRecommended:=False, CreateBackup:=False
The problem with this simple approach is that if two people try editing
the file at the same time, the changes implemented by the first one to
save the file to the server will be lost when the last one to save saves
the file to the server. Conceptually, the problem can be avoided by the
following procedure:
Open File A from server directory.
Use File A;s Aut
pen macro to Save File A as File B in Local
Directory “B“
AND to Open File C in Directory “A” where File C has the same name as
File A, but File C has a notice alerting anyone opening it that it is a
flag.
AND to save File C as File A into the server directory.
I expect there Is a macro command that will enable me to open another
workbook, is there also a macro command that will allow me to save a
workbook that is not the active workbook? Alternatively, how can one
initiate a macro in another workbook, so as to have the macro procedure
jump from one workbook to another.
accessible to multiple individuals. The Excel file on a server can be
opened merely by placing the location of the file in a browser window
and selecting it. The Excel file can be saved to a server using the
SaveAs window. Furthermore, a Visual Basic Command of the form shown
below (with the appropriate IP address) can be used to mechanize the
Save process.
ActiveWorkbook.SaveAs FileName:= _
"ftp://70.86.210.194/public_html/Actions/FTP-test-0.xls", _
FileFormat:=xlNormal, Password:="larents", writeResPassword:
="6821loubet", _
ReadOnlyRecommended:=False, CreateBackup:=False
The problem with this simple approach is that if two people try editing
the file at the same time, the changes implemented by the first one to
save the file to the server will be lost when the last one to save saves
the file to the server. Conceptually, the problem can be avoided by the
following procedure:
Open File A from server directory.
Use File A;s Aut
pen macro to Save File A as File B in LocalDirectory “B“
AND to Open File C in Directory “A” where File C has the same name as
File A, but File C has a notice alerting anyone opening it that it is a
flag.
AND to save File C as File A into the server directory.
I expect there Is a macro command that will enable me to open another
workbook, is there also a macro command that will allow me to save a
workbook that is not the active workbook? Alternatively, how can one
initiate a macro in another workbook, so as to have the macro procedure
jump from one workbook to another.