Forum

Hi Maurizio, You can use this rather than VBA to get the day name in B2 =TEXT(A2,"DDDD") Regards Phil

Hi Hope, As Anders said, it's always better to supply a workbook with the data to make out lives easier to help you 🙂 But, try this =IF(ISER...

Hi Giannis, It depends on what you want the combined Subs to do. For example, you have If Target.Count > 1 Then Exit Sub in one Sub, do you w...

Hi David, There's nothing to prevent you uploading an image or Word doc to this post, it would be better to provide an Excel workbook though. Tr...

Hi Aye, Not sure exactly what you mean by 'export to' ? If you are using Teams then everyone should have access to One Drive and Sharepoint? ...

Hi Anne, Have you tried Kaggle? Regards Phil

Hi Maurizio, Because there are a finite number of images I wouldn't bother writing a VBA routine to get them from the web and then save to a folder...

Hi, Why do you need a macro for that? If you can explain in detail what you need and provide a workbook with an example of what you want to happen...

No worries Maurizio.

Hi Hans, Unfortunately things like this do occur. Only yesterday I had to rewrite code that had worked previously for embedding workbooks in a web...

Hi Hans, Neither of these functions work as-is because Captiontxt is not defined, neither is the FileExists function. If you could supply the actu...

Your appointments do not have that particular property. Edit/Remove/Comment Out those lines. You can read up on Appointment Items here Regards ...

Hi Maurizio, the point is it's not practical to load the images into the sheet and then save them out to a folder - but the attached file has a rou...

Hi, Attached is some code to get your most of the way there. I don't have a folder full of appointments to test this with so try it with yours and...

Hi Prasenjit, You can do this with Power Query - see attached file. Phil