Forum

Hi, Please attach all the files you are working with so I don't have to recreate them. Thanks Phil

No worries. The code works through all hyperlinks in the sheet and if they are all listed in Column A then it already does what you are asking. ...

Hi Andy, I've run that code loads of times without error. Have you tried stepping through the code to see where it is generating the error? T...

Hi Daniel, 1 - Right click on one of the dates in the PT 2 - Click on Group in the pop-up menu 3 - In the Grouping dialog box click on Days -...

Hi Pa, Without your workbook working this out took a lot longer than it could have. I'm still not sure if this is what you want. =SUMPRODUCT(--...

Hi Andy, no workbook attached. Regards Phil

Hi Rajsha, This 'kind-of' works but as you haven't supplied the workbook where you are running it, I don't know if it's actually doing what you wan...

Hi Rajsha, the code will work with any file type. Just specify the URL for the file in Col A. Are you trying to say that you want to get any/al...

Ahh, you're using a Mac 🙁 Can't use this method to send email on a Mac I'm afraid. Mac's do not support this. I do not have a Mac nor have I eve...

Hi Rajsha, The attached workbook does what you ask. You only need to specify the save folder once in cell C2 - change this to suit your PC. I...

No worries Andy. That code works fine for me but I'm running it out of the context of your environment. So I'll need your workbook to test it prop...

Yes, merged cells are evil!

Hi Alec, Please supply your workbook, hard to debug this without your data. Phil

Hi Rajsha, Please supply your workbook with code. Regards Phil

No worries Rob. I don't have a Mac so that makes it interesting. It does appear that Mac's do not support Application.FileDialog which is being us...