Forum

PBI File attached

Chen, There's no attachment. Phil

Try =HYPERLINK("F:Study Material"&C3&"2017" & A3 & ".docx",A3)

Hi Maurizio, Your code is looking for elements with the HTML class name "sunny" but I don't see anything on the page that has that class name. The ...

Please supply the workbook so we don't have to key in the data and recreate everything. If I enter your COUNTIFS formula into the Units column I ge...

Hi Luke, I have no problem with that string either. You haven't supplied the XLSM that generates the codes though so it's impossible to check wh...

Well, if you don't send the email using VBA then you can't test if it has been sent. If you just display it, and then rely on you clicking on SEND ...

Hi Stefi, If there's some relationship or way to identify what you want to sum then you can do this. But looking at the examples in your workboo...

Hi, This is why supplying the actual workbook and thoroughly explaining the expected result is so important. The work I did in my first answer was...

Hi, Please provide a workbook rather than typing data and code so we don't have to recreate everything. You can do what you want with a combinat...

OK so what you want to do is see if an error has occurred when sending an email. You need to know how to handle errors in VBA I've added a new sub...

Hi Stefi, You can't have a formula that takes a value from a cell, and then ignores when that value changes. What I've done is changed the formu...

Hi Mark, You say that other users 'seem to' have the same permissions. Can you confirm this is actually the case? On the face if it, your files...

Dick's 2nd file

Hi Paul, Without your actual file that is giving the errors I can't try to replicate the issues you're having. regards Phil