Replies

(Edited by HansV to make URL clickable – see Help 19)

Ronny:

Microsoft at its main site http://www.microsoft.com[/url%5D at the office web page has a link to “Templates”
If you select this you will go to the Template page. At the bottom there is a category called education
If you select this category you will see a selection for Teachers then a sub-selection fro tests and grades.

One of these seems to do exactly what you desire. Just download and save on you computer.
Regards,

TD

It seems that Excel is not finding the exact location of the function. Are you sure that in Excel is set up to run Macro’s from all locations rather than running just the macro’s for a paticular sheet ?

A quick way to find out is to copy the entire procedure to the Macro module for the open workbook and see if the function runs.

Regards,

TD

It seems that Excel is not finding the exact location of the function. Are you sure that in Excel is set up to run Macro’s from all locations rather than running just the macro’s for a paticular sheet ?

A quick way to find out is to copy the entire procedure to the Macro module for the open workbook and see if the function runs.

Regards,

TD

If possible, the best solution would be to have everything in one workbook. Then instead of Links you could use worksheet formulas (more reliable) and Excel’s “Grouping” making the job of managing data much easier. If you cannot combine the data of both workbooks into one workbook the only solution would be some type of Macro but that could get complex.

Regards,
TD

If possible, the best solution would be to have everything in one workbook. Then instead of Links you could use worksheet formulas (more reliable) and Excel’s “Grouping” making the job of managing data much easier. If you cannot combine the data of both workbooks into one workbook the only solution would be some type of Macro but that could get complex.

Regards,
TD

Not sure of what you want. However, using the string formulas in Excel I was able to do what I believe you want.

If not explain what is different.

See attached.

Regards,

TD

Not sure of what you want. However, using the string formulas in Excel I was able to do what I believe you want.

If not explain what is different.

See attached.

Regards,

TD

Alan:

A simple work around would be to open a new column A thereby making the alphanumeric column to B.
In column A use the following formula = Left (B1,1). Then copy down the formula to every entry to be filtered.
Lastly redo the autofilter to include the new column A. Do your autofilter from column A amounts.

This should work.

Regards,

TD

Alan:

A simple work around would be to open a new column A thereby making the alphanumeric column to B.
In column A use the following formula = Left (B1,1). Then copy down the formula to every entry to be filtered.
Lastly redo the autofilter to include the new column A. Do your autofilter from column A amounts.

This should work.

Regards,

TD

Not sure this is answer, but each user may have their Edit Links Start Up Prompt set differently. Ask each User what their setting is for Editing Links. If settings are different then you need Macro code to change that setting to what you want when the workbook opens.

Hope this helps,

TD

Hans
Thank you for the valuable information. Based on your response, and an article on the Microsoft Knowledge Base we were able to resolve the problem. It now works on both 2000 and 97.

TD

Hans
Thank you for the valuable information. Based on your response, and an article on the Microsoft Knowledge Base we were able to resolve the problem. It now works on both 2000 and 97.

TD

Not sure this will help but maybe by using “DATA OBJECT” in VBA you might be able to solve this. The built in help for Word VBA has an explanation and example of the use of DATA OBJECT.

Kevin:
The braces and vertical bar indicate a mandatory choice VBA must make between the items listed inside the braces. In your case you have given VBA two choices to review, the items left of the vertical bar and the items right of the vertical bar.
So in your code there are three items left of the vertical bar PR_Company Name PR_Street Address PR_Locality on the right side you have only two PR_Street Address PR_Locality .
As you can see the only difference between the choices is the company name element.
In other words a left choice by VBA produces 3 lines a right choice produces 2 line.
To you it seems like an if / then type statement is being performed when VBA is using the Option Statement Syntax to get the job done.

As for the other items in your code (outside) the braces they are mandatory and will always generate data from the address book both before and after the code in braces.

Hope this helps.