Forum

Hi Amir, If you need to interact with the page then you should consider using Selenium to drive your browser That said, that site looks like i...

Hi Mohith, You asked for the email to be sent when the body of the message is entered in Col H and that is what the code does. But it''s easy to m...

Hi HSAR, You haven't supplied a workbook. That VBA code isn't valid so it can't be giving an accurate result. Did you try the code I linked t...

Hi HSAR, Please supply workbooks when you are referring to data and it will be useful for those helping you. Otherwise we have to type everything ...

Hi Tori, If you can use a formula you should use it. I'd only use VBA when a formula can't do what I need. In this case you can get the data fr...

Hi Mohith, Please see attached file. When the message body is changed on a particular row, and email is sent to the email address on that row. ...

you're welcome

Hi Mohith, Yes this can be done, though I'd caution against triggering an email when the Body of the message in Col H is entered. What if you make...

Hi Pete, When you write a reply in the forum, underneath the area you are typing in is a button named 'Attachments'. Click that, and attach and up...

Sure, Open the VBA editor and modify the last line of the NumToWords function to this NumToWords = Application.Trim(Units & SubUnits) & ...

Hi Peter, If you can attach those sample files we'll take a look at what we can do for you. Regards Phil

Hi Liesl, The first thing that pops out is that you've asked VLOOKUP to return the 4th column but your data is only 1 column wide. Also, I presu...

Hi Salim, Concatenate " only" to result the function returns: =numtowords(A2) & " only" Regards Phil

Hi Pete, We can't give you an accurate answer without seeing your data, please supply the workbook, criteria etc. Do you have Office365? If so ...

Hi Salim, Please read this post and use the code from it Regards Phil