Filename = "FormHelp.frm"
FName = cPath & Filename
ThisWorkbook.VBProject.VBComponents.Import FName
Even though this is open for only a few seconds to import the file located on a server, it is still possible that it is in use while someone else opens up a new spreadsheet, is there a way either to have it not locked, so that multiple people could access the file at once. OR option two,
I was thinking about looping, if on error, put in a wait delay, and check after 5 seconds and loop that a few times until the file becomes available.
Any ideas? Code really helps thanks.
Bookmarks