Forum

Hi Natasha, there's no attached workbook. Regards Phil

Hi Austin, I don't know what range you want to select, but if you want to select A1:A2 you can use this in your Workbook_Open() sub to replace the ...

No worries 🙂

Got it. When you prompt the user for input for the value of Payperdate, it's in the format xx/xx/xx The / are causing the issues because / isn't...

No worries Bob. I don't find anything logically wrong with your code, it doesn't generate an error on me. However, the value for Payperdate is emp...

Hi Bob, Without seeing all your code I can't be sure, and I can't run it to test it and see exactly what error messages you are getting, always bes...

Hi Austin, Event code must go in the container for the particular event you want. So for Workbook events the code must go in the ThisWorkbook modu...

No worries Ken, glad to help. Regards Phil

Hi Ken, Are you sure the workbook from email is Workbook(2)? When you specify the workbook by number you have to be sure it is what you think it...

Hi Ehab, I think you would benefit from some VBA training. We can't always be doing everything for you 🙂 Better you learn so that you can do wha...

You're still going to have to go through the results by hand to make sure they are correct. Try this attachment. Phil

Hi Ravikiran Not quite sure what you mean but there are a few things you need to change You've declared r as as range but you are using rng Y...

Hi nuel, It isn't practical to do this as it requires the macro to be running constantly in order that it can check the time. What exactly is th...

Hi Claude, So you want to open a file in Excel desktop from OneDrive, using VBA to open it? I'm not aware of a way to do this. But you could do...

Hi Ehab, This is where it gets difficult. To answer your first qs, as the macro is only looking for the string "facebook" in links, it will find an...