Replies

That’s is it – I thought my explanation was adequate. Seems not – it is a luxury to be understood! {8;-))

Hans, The divisor is the number of weeks in the quarter for which data has been entered. Week 37 is the 11th week of the quarter. Hence the weekly average is the total of weeks 27 to 37 divided by 11. And 11 is entered manually.

When week 28 data is entered the divisor becomes 12 & at present this is done manually. I want to make that change automatic.

I hope that answers your question.

Hans, The divisor is the number of weeks in the quarter for which data has been entered. Week 37 is the 11th week of the quarter. Hence the weekly average is the total of weeks 27 to 37 divided by 11. And 11 is entered manually.

When week 28 data is entered the divisor becomes 12 & at present this is done manually. I want to make that change automatic.

I hope that answers your question.

Hans,

A belated but sincere thank you.

Malcolm

Hans,

A belated but sincere thank you.

Malcolm

Thank you for your reply. I doubt there are any data files but I’ll arrange for compacting to be done.

Thank you for your reply. I doubt there are any data files but I’ll arrange for compacting to be done.

Steve,

Not to take any more of your time but with an exchange of messages with Hans all is now well & I can display my default worksheet when opening Excel.

I am very grateful for your interest in my enquiry. Thank you.

Steve,

Not to take any more of your time but with an exchange of messages with Hans all is now well & I can display my default worksheet when opening Excel.

I am very grateful for your interest in my enquiry. Thank you.

Thank you Hans. All is now well & my default template is displayed with no error messages!

Thank you Hans. All is now well & my default template is displayed with no error messages!

Hello Hans,

You are quite right about my system & the os & applications I am using. I have confirmed the details in my message to Steve sent a few moments ago.

However doing what you say in your message to Steve has produced a VB error on my computer when opening & closing Excel. The details are again in my message to Steve if you would be kind enough to have a look at it.

Hello Hans,

You are quite right about my system & the os & applications I am using. I have confirmed the details in my message to Steve sent a few moments ago.

However doing what you say in your message to Steve has produced a VB error on my computer when opening & closing Excel. The details are again in my message to Steve if you would be kind enough to have a look at it.

Thank you for your reply Steve & for clarifying why my search for a default Excel template was fruitless! And I can confirm that my operating system (Windows XP Home) is on the C: drive, that my applications (including MS Office 2000) are are on the D: drive & my data is on the E: drive. I do not have a folder C:Program FilesMicrosoft OfficeOfficeXLStart. I do have a folder D:Microsoft OfficeOfficeXLStart.

I put two copies of the worksheet I want as Excel’s default template into that XLStart folder; one named Book.xlt & the other Sheet.xlt. When I opened Excel a dialogue was displayed:

Microsoft Visual Basic
Compile Error in hidden module: AutoExecNew
OK Help

By clicking OK Excel displayed my new default worksheet. When closing Excel another dialogue was displayed:

Microsoft Visual Basic
Compile Error in hidden module: DistMon
OK Help

By clicking OK Excel closes. I have deleted Book.xlt & Sheet.xlt from the XLStart folder & Excel continues to display the same dialogues when it is opened & closed.

I seem to have damaged Excel by putting the my templates into the XLStart folder.

Thank you for your reply Steve & for clarifying why my search for a default Excel template was fruitless! And I can confirm that my operating system (Windows XP Home) is on the C: drive, that my applications (including MS Office 2000) are are on the D: drive & my data is on the E: drive. I do not have a folder C:Program FilesMicrosoft OfficeOfficeXLStart. I do have a folder D:Microsoft OfficeOfficeXLStart.

I put two copies of the worksheet I want as Excel’s default template into that XLStart folder; one named Book.xlt & the other Sheet.xlt. When I opened Excel a dialogue was displayed:

Microsoft Visual Basic
Compile Error in hidden module: AutoExecNew
OK Help

By clicking OK Excel displayed my new default worksheet. When closing Excel another dialogue was displayed:

Microsoft Visual Basic
Compile Error in hidden module: DistMon
OK Help

By clicking OK Excel closes. I have deleted Book.xlt & Sheet.xlt from the XLStart folder & Excel continues to display the same dialogues when it is opened & closed.

I seem to have damaged Excel by putting the my templates into the XLStart folder.