• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

problem with Create Monthly Totals

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
0
JaseSt
Asked:
JaseSt
  • 7
  • 7
1 Solution
 
gowflowCommented:
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
0
 
JaseStAuthor Commented:
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
0
 
gowflowCommented:
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
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
JaseStAuthor Commented:
no the mc work book created the file. My date is correct on the computer
0
 
gowflowCommented:
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
0
 
gowflowCommented:
Did it work for you ?
gowflow
0
 
JaseStAuthor Commented:
Not really. Please see attached. Errors from MC run.error 1error2
0
 
JaseStAuthor Commented:
well, ran it again and it worked.
0
 
gowflowCommented:
so bottom line is what now ? worked or did not work ?
gowflow
0
 
JaseStAuthor Commented:
it worked for December. I'll try it again in February for January.
0
 
JaseStAuthor Commented:
Thanks again, gowflow.
0
 
gowflowCommented:
Glad we fixed this old issue. Pls let me know any other issue you may need help with.
gowflow
0
 
gowflowCommented:
Any news ?
gowflow
0
 
JaseStAuthor Commented:
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
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 7
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now