Forum

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

Mariya, Are you actually uploading the file from your PC or are you providing the URL to Dropbox when trying to load the file to the forum? I hav...

Hi, See attached workbook for a good start on this. The code in the workbook will load a page and then parse the HTML for any links. It will p...

You're welcome

Hi, There isn't any consistent pattern to be able to match. The first line is the name Adam Moore and you are looking for the pattern adam.p.moore...

Thanks for letting us know you worked this out. Phil