Last seen: Jun 10, 2026
Hi David, I've just seen your 2nd post. Perhaps the issue is that the other workbook is a .xlsm file? Again, without the exact error message it...
Hi David, How exactly does it not work? If you are getting an error you need to tell us what it is. When I try this code it works fine, with so...
Hi Mariya, You could use events to trigger some VBA to insert a row in the table, but I don't know how your barcode scanning works. The event will...
Hi, Do you mean the message states 'The file is locked for editing by another user'? A screenshot would be useful. Who is the other user? Ar...
Hi Robert, The 2nd and 4th conditions are No in both El Docs and UA, so how do we distinguish the difference between them to know that one has a fe...
Hi Kevin, I'm not sure what isn't working for you. Doing as Catalin suggests works fine for me e.g. If TestString Like "*#*" Then Debug.Print...
Hi Don, There's a link at the top of this page to download the course files Phil
You're welcome
no worries 🙂
Hi, I find using SeleniumBasic much easier than using IE. This post walks you through setting it up and how to interact with the website form. ...
Hi Roanne, I've modified the formula in Col J to include a VLOOKUP of some different types, as Mynda described. You can expand the lookup range VL...
Hi Stefi, Creating a name for each column is the way to do it. Try these articles Regards Phil
Hi Roxanne, Please start a new topic when you have anew qs, rather than add to an existing topic on a different subject. I've moved this post here...
Hi, You could just use TAB to move through each column and a new row will be added once you tab out of the last column? Why are you using NOW() ...