for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

1 lurker | 102 watchers

um Oct 2022 4:06pm, 12 Oct 2022 6,608 posts	Quote Pin um warning This is all new to me ! But, looking at a few web examples, I suspect you may have to go up and down the directory, eg (from slipstick.com ) & I'm assuming Parent is a defined word in vba, objTargetFolder = objInboxFolder.Parent.Folders("OutlookData").Folders(“callsdaily”)
Bowman 🇸🇪 Oct 2022 5:17pm, 12 Oct 2022 1,833 posts	Quote Pin Bowman 🇸🇪 Ah i think you are on to something here, big thanks i'll try with that.
Bowman 🇸🇪 Oct 2022 5:35pm, 12 Oct 2022 1,834 posts	Quote Pin Bowman 🇸🇪 You solved it, a little knowledge is a dangerous thing, i've built massive stuff in VBA, but when you are not a programmer from the ground up, you get stuck on shit like this. Thanks, you took away a heavy rock from my back UM!
run free Oct 2022 5:43pm, 12 Oct 2022 5,202 posts	Quote Pin run free SPR - PowerPivot can certainly speed up your calculations and you are right you will need to understand a bunch of other Functions and concepts..... So another thought for you is I noticed that you repeat a calculation within your formula INDEX(D_relevant, month). Can you place that in a helper column and then reference it. Also make sure you are not including whole columns in yr array. Finally would MAXIFS be useful?
SPR Oct 2022 6:58pm, 12 Oct 2022 38,513 posts	Quote Pin SPR MAXIFS won't work I need the max of multiple the SUMIFS. You're correct that INDEX(D_relevant month) is there twice, but that will be pretty quick in of itself as all it does is ensure each cell in the range in the index is treated individually it's not actually calculating anything there. I did start with full columns but changed that as soon as I realised it would be fairly slow. It's doing the job for now (I'm not the person actually using it but they are happy with the result as they were struggling to do it at all) and doesn't need to be updated often so if I have some time to investigate power pivot at some point I can update at a later date
Bowman 🇸🇪 Oct 2022 8:45am, 13 Oct 2022 1,836 posts	Quote Pin Bowman 🇸🇪 Ahhhh, it works sometimes UM, but not all the time? Sometimes it runs when an email arrives, sometimes it's not. Sometimes it finds the folder, sometimes it does not, with the same error, folder=nothing.. Strange stuff...
um Oct 2022 9:11am, 13 Oct 2022 6,609 posts	Quote Pin um I think I did see a web page with 'intermittent' problems - I'll check later if I can find it again. And if there was a solve. Is there any chance it's a locking / file access problem rather than a name or 'finding' problem? If Outlook proper has that document or file locked ar some points?
Bowman 🇸🇪 Oct 2022 9:47am, 13 Oct 2022 1,839 posts	Quote Pin Bowman 🇸🇪 Not sure about “locking” It says =nothing in the variable. Like before. I have added a msg box to show me when it runs, and it has stopped running all together. With no other changes. Saved code and restarted outlook but nothing. Strange this.
Bowman 🇸🇪 Oct 2022 6:34pm, 13 Oct 2022 1,846 posts	Quote Pin Bowman 🇸🇪 Um, Still the same, been trying out different things during the day. Even tried different situations and emails, but I see no pattern. It works, until it doesn’t work. And then the folder variable for where to move the right emails is “nothing” That can happen with correct emails and emails that shouldn’t be moved. No pattern.. did you find the webpage talking about intermittent problems?
um Oct 2022 9:38pm, 13 Oct 2022 6,616 posts	Quote Pin um Bowman, I've re-searched and looked back through yesterday's history, but can't see any specific refs to intermittent errors as you describe. There's a few where the starting directory, or route to the end directory is corrupted within a for loop. And some recommendations to rest the chain each time you check/process/move a mail. Also some cases where they set the move to directory in long hand rather than one combined statement. But nothing I can find or send that gives a solve. There's a few coding threads - I thought - but they're not tagged to this one. Maybe failing all esle else open an Outlook VBA thread to poll a wider audience in Fetch? Or scan through these to see if any have components of what you're trying? vboffice.net