Hello,
This is my first post on this forum. I am having difficulty with the Workday function in the Analysis Toolpak.
It's an ideal function for what I wish to achieve, and I can use it effectively in Excel.
For the life of me though, I can't seem to get it operating in VBA. I am attempting to call it from WorksheetFunction, but it doesn't appear in my list of properties, despite having both Toolpaks installed.
***EDIT - Solved. I had to go Tools->References and check the atpvbaen.xla addition. Workday functions now calling properly.
Unsure how to mark topic as solved.****
The task I wish to achieve is simple - add 4 working days to a given date. Presuming the date is in cell A1, the formula =Workday(A1,4) works a treat (disregarding holidays at the moment).
I believe that if the Analysis Toolpak - VBA is installed then Application.WorksheetFunction.WorkDay(arguments) should work - but it doesn't register?
When viewing Tools->AddIns in the VB editor nothing is displayed. Should the Toolpak show on this menu?
My VBA is 'developing'...it's been many years since I fiddled with code (Javascript as a child), and I can't seem to successfully replicate a WorkDay function with VBA. I'm close, but no cigar.
Does anybody have any suggestions? I'm all googled out.
Any help would be greatly appreciated.
Thanks,
Mike
Bookmarks