Forum

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.

Hi, What have you tried that doesn't work? Please supply the workbook and code. What version of Windows are you using? Regards Phil

Hi Bhavesh, So what is it you actually want to do, you haven't really explained? Change $Z$54 to some other cell reference? Please supply the w...