SpreadEveryone: The Fetchland Excel wire
101 watchers
Oct 2022
4:06pm, 12 Oct 2022
6,608 posts
|
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”) |
Oct 2022
5:17pm, 12 Oct 2022
1,833 posts
|
Bowman 🇸🇪
Ah i think you are on to something here, big thanks i'll try with that.
|
|
Oct 2022
5:35pm, 12 Oct 2022
1,834 posts
|
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! |
Oct 2022
5:43pm, 12 Oct 2022
5,202 posts
|
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? |
Oct 2022
6:58pm, 12 Oct 2022
38,513 posts
|
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 |
|
Oct 2022
8:45am, 13 Oct 2022
1,836 posts
|
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... |
|
Oct 2022
9:11am, 13 Oct 2022
6,609 posts
|
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? |
|
Oct 2022
9:47am, 13 Oct 2022
1,839 posts
|
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. |
|
Oct 2022
6:34pm, 13 Oct 2022
1,846 posts
|
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? |
|
Oct 2022
9:38pm, 13 Oct 2022
6,616 posts
|
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 |
Related Threads
-
Excel skills test
Mar 2019
-
Accounting Question
Oct 2017
-
Important excel files deleted - Please Help
Oct 2016
-
download training log to excel
Jan 2024
-
Excel boffins - your needed!
Sep 2018
-
World Cup sweepstake in excel
May 2018
-
HELP! Excel file corrupted and I need it!
Aug 2016
-
Running Club Spreadsheet to track PBs
Apr 2014
-
The Retirement Thread
Jan 2025
-
Any pension experts out there?
Oct 2024
