Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch
or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

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”)
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.
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!
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
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?
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.
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

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...
  • Show full description...

Related Threads

  • excel
  • support
  • tech
  • work

Report This Content

You can report any content you believe to be unsafe. Please let me know why you believe this content is unsafe by choosing a category below.



Thank you for your report. The content will be assessed as soon as possible.










Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 114,486 Fetchies!
Already a Fetchie? Sign in here