Hi,
In my application VBA Excel opens .txt-files in Word. These are temporary files in a specific folder and when the program starts it must kill all existing .txt-files in the folder. When one of the .txt files is still open an error occurs. Is there a way to close all open .txt files in the folder?
Set WrdApp = CreateObject("Word.Application")
???
Kill (C:\Workshop\Temporary Files\*.txt")
Thank you very much in advance!
In my application VBA Excel opens .txt-files in Word. These are temporary files in a specific folder and when the program starts it must kill all existing .txt-files in the folder. When one of the .txt files is still open an error occurs. Is there a way to close all open .txt files in the folder?
Set WrdApp = CreateObject("Word.Application")
???
Kill (C:\Workshop\Temporary Files\*.txt")
Thank you very much in advance!