Forum

Hi Mynda, Welll, I thought I'd done exactly that! The lesson describes what can happen when, say, merging a table with an external source, but I d...

Hi Mynda, It's taken me a bit of time to link with my Mac-using tester but I finally have a clearer picture of what's happening. I hestitated to p...

Hi Mynda, Thanks for the suggestion and I'll try hard coding the query as you suggest instead of using a parameter table, though it'll severely lim...

Hi Alan, Thanks for a brilliant and detailed post that's gone a long way to helping me understand what I want to do - and you've summarized it perf...

Hi Mynda, Thanks - I was about to go down a rabbit hole and you pulled me back from the brink. I was using Get Data etc as a (misguided) diagnosti...

Hi Mynda, Sorry to have to come back on this one. My Mac-using colleague says he can't reference the .XLSX file. I directed him to Data / Get Dat...

Hi Mynda, Your hint was invaluable and got me a long way down the path. I had a filter on the original data, driven by a selectable value in a par...

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...