Forum

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

Hi Hans, I couldn't execute your code as-is because it's not complete - I don't have the variables you are using set to any values. But if I jus...

Hi Dorsa, You start working out the factorial using an uninitialized variable 'Factorial' which has a default value of 0. So your function result ...

Hi Aye, I'm sorry but we have to impose some restriction on the size of files uploaded to the site. We don't have unlimited storage space. You ...

Hi Maurizio, Firstly, please don't tun off error handling with ON ERROR RESUME NEXT without using your own error handlers. I think I've mentioned t...

Hi Mehdi, SUBSTITUTE allows you to: 1.Replace all occurrences of a substring in a string 2. Replace a particular instance of a substring wit...

You're welcome.