Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 10, 2026
Topics: 61 / Replies: 1588
Reply
RE: Macro for File save base on today

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...

7 years ago
Forum
Reply
RE: Macro for File save base on today

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...

7 years ago
Forum
Reply
RE: Table Auto Insert New Row with Formula After Hit Enter

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...

7 years ago
Forum
Reply
RE: Excel Vba

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...

7 years ago
Forum
Reply
RE: IF AND Function for 4 outcomes

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...

7 years ago
Reply
RE: Test existence of any number in input string

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...

7 years ago
Forum
Reply
RE: Materials for PowerBI

Hi Don, There's a link at the top of this page to download the course files Phil

7 years ago
Forum
Reply
Reply
Reply
RE: I want to access a website using VBA codes by entering auto login credentials after that i want to go particular page, Please help me

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. ...

7 years ago
Forum
Reply
RE: Pointing to appropriate cells via formula with variables

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...

7 years ago
Reply
RE: Dynamic drop lists

Hi Stefi, Creating a name for each column is the way to do it. Try these articles Regards Phil

7 years ago
Reply
RE: Search string for word from a list

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...

7 years ago
Topic
Reply
RE: Table Auto Insert New Row with Formula After Hit Enter

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() ...

7 years ago
Forum
Page 87 / 110
0