Yes, I do regular scans for malare and none are found. At one point, I would open up older worksheets, select a macro, and try to edit it so I could see what is did, and EXCEL kept crashing after giving a message like "Excel is trying to recover". It was behaving as though I was trying to click on References while the debugger was running, but it was not. ![]() The references are there now, and I selected both. SearchString = "Parent" 'Change to your search termÄebug.Print wb.Name 'Workbooks with the search term will appear in the Immediate window Set VBComp = wb.VBProject.VBComponents("Module1") 'Searches Module1's only On Error Resume Next 'Not having a Module1 will throw an error If Right(wb.Name, 4) "xlsm" Then GoTo lupe Set wb = Workbooks.Open(Filename:=MyFolder & MyFile) ![]() With Application.FileDialog(msoFileDialogFolderPicker) ' set a reference to Microsoft Visual Basic for Applications Extensibility 5.3 ' set a reference to Microsoft Scripting Runtime
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |