Forum

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

Hi Kevin, Seems that since 2013 you can't choose which programs to install, at install time. However you can use the Office Deployment Tool to con...

Hi Kevin, Microsoft don't recommend it, however I have had more than one version of Office installed on a PC - but generally run into some problems...

Hi, Please check this post Regards Phil

Hi Irfan, So you want to display a form whilst Sheet1 is active, but the form loads data from a sheet called Data? It doesn't matter what sheet ...

Hi Peter, When you say Excel can't 'see' the certificate what exactly do you mean? When you try to add the cert in the VBA editor are you gettin...

Hi Irfan, Please supply the workbook with code+form so it is easier to help you. Regards Phil