Problem with writing an output to a word File from Excel Userform

Hello everyone and happy holidays if you celebrate,

I am finally trying to retool one of my old userforms, because the old one had become painfully slow (because I was an idiot). It appears that I have one last thing to fix that has been bothering me. I am trying to save my output from a contact logger form to an archive file that is a word document. It opens the file, pastes the output from the contact logger to the word file, saves the word file, and then closes it. Most of the time, it works very well. The only stumbling block for me is if I goof up, and have the file open. The code below was mostly copied from the web of course. I was thinking that moving the "open the file" part up into the error handler would be something to try, but was at a loss for how to set the file to active if it was already open.

Please Login or Register  to view this content.

Any help would be appreciated.

BobR

I would create a function that determines if the file is open and returns a Boolean output. If True, close and perform the subroutine. If false, perform the subroutine.

...I'll see if I can find a function that I used to determine if a workbook is open and you should be able to adapt it from there.

Here is some code I found online that may help:

Please Login or Register  to view this content.

Thank you Joe! I will give that a shot later today.

BobR