G
Guest
First off, I would like to say that I'm very new to VB, this is probably
something easy that I'm just missing.
I'm currently using the following line to FTP a spreadsheet to another
computer.
DoCmd.TransferSpreadsheet acExport, , "tablename", _
"ftp://accountassword@computer/" & rstUserInfo(0) & "-" & strFileDate &
"-" & strUpCount & ".xls", False
rstUserInfo(0) = username
strFileDate = current date
strUpCount = upload count
It autocreates a filename like "Sim-1-041006-1.xls" If a file with the same
name already exists it displays a run-time error 3027 stating that the object
is read only. I would instead like it to increment the strUpCount by one and
try again.
How would I go about handling this error?
Thanks,
ToddC
something easy that I'm just missing.
I'm currently using the following line to FTP a spreadsheet to another
computer.
DoCmd.TransferSpreadsheet acExport, , "tablename", _
"ftp://accountassword@computer/" & rstUserInfo(0) & "-" & strFileDate &
"-" & strUpCount & ".xls", False
rstUserInfo(0) = username
strFileDate = current date
strUpCount = upload count
It autocreates a filename like "Sim-1-041006-1.xls" If a file with the same
name already exists it displays a run-time error 3027 stating that the object
is read only. I would instead like it to increment the strUpCount by one and
try again.
How would I go about handling this error?
Thanks,
ToddC