Hi Mynda, I hadn't got that far in the lessons yet and that's really helpful, thanks. I've sent a series of diagnostic tests to my Mac-using colle...
Hi Mynda, thanks for thst and, yes, they have 365 (fully updated). I know that Dropbox is a web service, but I thought that with the desktop app file...
Thanks for replying - I'm not making myself clear. I don't want to make variables associated with multiple workbooks. I just want to be able to set ...
I try to avoid putting code in event-triggered code such as workbook.open etc as it's then tied to that workbook, so I was looking to find a way to se...
... byt the way, I know that the Mac uses a different fille path structure and have catered for this in my workbook through VBA. I've also read the M...
Thanks Catalin, that works well. However, it ties the code to that particular workbook and I was hoping to be able to export it for use in other case...
OK - after a bit of digging around, it looks as though this can't be done. Just to recap, I want to use VBA programmatically to set whether or not a ...
Hi Catalin, Thanks again. Unfortunately this whole thing started with it looking as though Excel for Mac VBA doesn't support statements like Th...
Hi Catalin, Sorry for the delay in coming back; thanks for taking the trouble to respond and confirming that RefreshAll doesn't take parameters, w...
... I should add that I had also thought about adding some VBA to convert the parameter values to lowercase in the Parameter table and then adding a t...
Hi Phil, Fantastic - very many thanks. It was probably trivial to you but it opened my eyes to more opportunities. I really look forward to the c...