# Posts by HowardC

• ## Formula to compute ageing on Statement

I have a customer statement which I have set up. The payments received will reduce the oldest balance outstanding first

I would like a formula to compute outstanding amount owing by the ageing showing current (current months items) 30 days, 60 days, 90 days + as well as last payment made

It would be appreciated if someone can kindly assist me with a formula to do the above

• ## Removing Blue Border and color

Re: Removing Blue Border and color

I did not realize what was causing the problem

• ## Removing Blue Border and color

I have attached a sample workbook, where there is a blue border on sheet1 See Col G and a grey background from Col H onwards

It would ne appreciated if someone would please advise me how I can get remove these

• ## Macro to zip files in folder and sub-folder

Re: Macro to zip files in folder and sub-folder

Thanks for the attachment and your detailed explanation

This is very much appreciated

• ## Macro to zip files in folder and sub-folder

Re: Macro to zip files in folder and sub-folder

Thanks for the info, much appreciated

• ## Macro to zip files in folder and sub-folder

Re: Macro to zip files in folder and sub-folder

Hi Cytop

It would be appreciated if you would kindly assist me if you can in resolving the issue

• ## Macro to zip files in folder and sub-folder

Re: Macro to zip files in folder and sub-folder

My apologies -I forgot to mention this I had amended my code as per my last post

• ## Macro to zip files in folder and sub-folder

Re: Macro to zip files in folder and sub-folder

Hi Cytop

Code
``Open sPath For Output As #1 [/COLOR]``

is included in the code under the macro below

Code
``Sub NewZip(sPath)``

• ## Unable to Calculate the Reduction Percentage

Re: Unable to Calculate the Reduction Percentage

- In the baseline row 18, arethe number or incidents per quarter? Since for monthly average, he just takesthe number of incidents and divides by 4.
- In the baseline, you do not relate the number of incidentsto the number of servers (e.g. average incidents per server, or something likethat), yet in the main section, your reduction % is showing the percentage ofservers without incidents as far as I can see (except shown as a negative %).Surely the baseline needs to be comparable to the main section otherwise it'snot very useful?
Again, I might just not be understanding the aim properly

I guess the main issue for me is what the reduction % shouldbe showing?
Because intuitively I would think that this would show the reduction in thenumber of incidents per server compared to the previous month, or the baseline.

Based on what it currentlycalculates, I would guess maybe it's trying to show the reduction in serverutility caused by incidents?

[FONT="Times New Roman"]Hope I can help a bit once I understand whatyou are actually trying to do

[/FONT]

• ## Macro to zip files in folder and sub-folder

Re: Macro to zip files in folder and sub-folder

I have tried to adapt the code provided by Ron De Bruin, so that it only zips .xls workbooks containing text (P) in the name for eg PE_Accnts (P).xls

I get bad file name or number and the following code is highlighted

Code
``Open sPath For Output As #1``

I have attached my workbook containing the code

Kindly test and make any changes you deem necessary

• ## Unable to Calculate the Reduction Percentage

Re: Unable to Calculate the Reduction Percentage

Will have a look at this over the weekend to see whether I can assist

• ## Unable to Calculate the Reduction Percentage

Re: Unable to Calculate the Reduction Percentage

Hi

Not sure if this is what you are looking for. See attached file

• ## Macro to zip files in folder and sub-folder

I would like to zip all .xls workbooks in folder C:\test1 and in the sub-folders of test1 starting containing (P) in the text for eg BR1_Accnts (P).xls, PE_Accnts (P).xls etc

I have code to do this which I have tried to adapt, but get a compile error: syntax error

I do not want to have to select the files to zip as I have several subfolders within C:\test1. All the workbooks in this folder and sub-folder containing (P) in the text for eg BR1_Accnts (P).xls, PE_Accnts (P).xls etc are to be zipped

I have both WinRAR and 7-zip installed on my Laptop

It would be appreciated if someone could kindly help me to resolve this

• ## Problem with macro to attach file in Outlook

Re: Problem with macro to attach file in Outlook

It would be appreciated if you would kindly amend the code to attached .zip files in the sub-folders as well

• ## Problem with macro to attach file in Outlook

Re: Problem with macro to attach file in Outlook

Thanks very much for the help

Macro now works perfectly

• ## Problem with macro to attach file in Outlook

I have the following macro below, but for some unknown reason, the files with ,zip extensions in my folder C:\downloads as well as the sub-folders are not being attached

It would be appreciated if someone can kindly assist me in resolving the issue at stake

• ## Forcasting Subscriptions

Re: Forcasting Subscriptions

Thanks- I realized that it should have been I3=((C2/A3)^(1/H2))-1

• ## Forcasting Subscriptions

Re: Forcasting Subscriptions

Thanks for the help, much appreciated

• ## Forcasting Subscriptions

Re: Forcasting Subscriptions

Sorry for the confusion

I have two subscription categories

Category A MEMBER - currently being charged \$ 3950 per Annum
Category B MEMBER currently being charged \$ 3150 per annum

I would like to know that if I charged the Category A member 5% per annum for the next 6 years, what Interest rate would I need to charge the category B member for the next 6 years, so that the subscriptions are exactly the same after 6 years

It would be appreciated if you could kindly assist me in resolving this

Regards