PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
5 days, 16 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
problem with Create Monthly Totals
Posted on 2013-01-04
gowflow, not sure why but I'm not getting any results for the December Create Monthly Totals function. Attached is the December sheet. Let me know if you need anything more from me to figure it out.
As you can see it saved it as December 2011 not December 2012. Strange.December-2011.xls
As you can see it saved it as December 2011 not December 2012. Strange.December-2011.xls
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
7-
7
14 Comments
Active today
What workbbok give this problem like you started December with what workbook Visa or MC ? it would help troubleshoot. As the first one that create the month is the one that give the filename.
gowflwo
gowflwo
I first tried it with the MasterCard workbook and it gave me an error so I closed it down restarted it and did the visa also. Upon restarting it did not give me an error message but it gave me the results in the spreadsheet
Active today
So the visa created the file ?? Are you sure that you date on your pc is the correct date (sometimes we move the date back to print some report especially at end year) hv u done something like this and forgot the old date ???
gowflow
gowflow
Active today
OOOOPS !!!!!
My truly big mistake .... and seems you never tested this routine in january !!!! as this routine was done some ... ages ago. Well you have this issue in both MC and Visa file and will address it now. I will give you the couple of line you will need to replace in both files.
Both MC and Visa file the routine concerned is CreateMonthlyTotals
Start with MC and save it under a new name (just in case, for additional safety) open module1 click on CreateMonthlyTotals and goto the following lines it should be around the beginging of the file just after declaration
REPLACE ALL THESE LINES
======================
'---> Setup Last Month Date
If Month(Now) = 1 Then
SDate = DateSerial(Year(Now) - 1, Month(Now) - 1, 1)
Else
SDate = DateSerial(Year(Now), Month(Now) - 1, 1)
End If
======================
BY THESE LINES
======================
'---> Setup Last Month Date
If Month(Now) = 1 Then
SDate = DateSerial(Year(Now) - 1, 12, 1)
Else
SDate = DateSerial(Year(Now), Month(Now) - 1, 1)
End If
=======================
Save the workbook and do the same with the VISA file
Let me know if the issue get fixed.
gowflow
My truly big mistake .... and seems you never tested this routine in january !!!! as this routine was done some ... ages ago. Well you have this issue in both MC and Visa file and will address it now. I will give you the couple of line you will need to replace in both files.
Both MC and Visa file the routine concerned is CreateMonthlyTotals
Start with MC and save it under a new name (just in case, for additional safety) open module1 click on CreateMonthlyTotals and goto the following lines it should be around the beginging of the file just after declaration
REPLACE ALL THESE LINES
======================
'---> Setup Last Month Date
If Month(Now) = 1 Then
SDate = DateSerial(Year(Now) - 1, Month(Now) - 1, 1)
Else
SDate = DateSerial(Year(Now), Month(Now) - 1, 1)
End If
======================
BY THESE LINES
======================
'---> Setup Last Month Date
If Month(Now) = 1 Then
SDate = DateSerial(Year(Now) - 1, 12, 1)
Else
SDate = DateSerial(Year(Now), Month(Now) - 1, 1)
End If
=======================
Save the workbook and do the same with the VISA file
Let me know if the issue get fixed.
gowflow
Active today
Glad we fixed this old issue. Pls let me know any other issue you may need help with.
gowflow
gowflow
Yes, I have at least a few more to look at, but they take time to explain. I guess I can start with a couple relatively easy ones. Here's the first:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27989319.html
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27989319.html
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Suggested Courses
Course of the Month5 days, 16 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.