Thank you for the help. I have a question. When I try this with the On-Call list open, I get an error that states "Run Time Error "1004": Cannot access the read-only document On-Call List2.xlsx". When I use it with the on-call list not open, it writes the information, but if I use the button again, it over-writes the just updated file (well, offers to replace). Can this be done in a manner that updates the existing file, rather than replacing it (and the information I entered before)?
|