N
nintendomasta811
Does anyone know if code exists to make an excel spreadsheet shared
from within Access? Basically, I need to overwrite an excel .XLS file
from access on a regular basis. I'm doing this using the docmd.outputTo
method since docmd.transferspreadsheet was horribly problematic. It
works, however, once the file is overwritten I can't overwrite it
again; the new .XLS file defaults back to not being shared so I can't
overwrite it. Is there some code I can use after docmd.outputTo in
order to make the spreadsheet shared again?
Thanks in advance.
from within Access? Basically, I need to overwrite an excel .XLS file
from access on a regular basis. I'm doing this using the docmd.outputTo
method since docmd.transferspreadsheet was horribly problematic. It
works, however, once the file is overwritten I can't overwrite it
again; the new .XLS file defaults back to not being shared so I can't
overwrite it. Is there some code I can use after docmd.outputTo in
order to make the spreadsheet shared again?
Thanks in advance.