Replies

Finding a working PC has been problematic. However, on one installation, did receive a warning message of form information being posted to a ‘Restricted Site’, so that is probably the issue. The fix may not be easy as all our copies of IE are customized ones from an Application Service Provider a customer insists that we use. This customized one has most of the Internet Options features disabled or hidden. Long, and challenging treks through RegEdit are required to bring the features back to life. Your assistance was helpful.

Thanks.

Finding a working PC has been problematic. However, on one installation, did receive a warning message of form information being posted to a ‘Restricted Site’, so that is probably the issue. The fix may not be easy as all our copies of IE are customized ones from an Application Service Provider a customer insists that we use. This customized one has most of the Internet Options features disabled or hidden. Long, and challenging treks through RegEdit are required to bring the features back to life. Your assistance was helpful.

Thanks.

Have you thought of using Tools|Scenarios. Although I have never played with Scenarios in VBA, there is a Scenarios Collection Object which would seem to address your needs.

Regards.

If he is wealthy, name me as a beneficiary as well!

As to the graphic in the signature, that was my only thought. You might retry using HTML, and include a heavy dose of JavaScript to disable the right mouse button so they cannot, easily, grab the graphic.

Sorry I can’t be of more assistance.

Go to Tools|Options|Mail Format. Once there, select the Signature Picker. If you already have a standard signature, click on Edit. (If not, select New.) From there, select Advanced Edit. You will end up in Word, and you can then use that to insert a graphic.

Hope that helps.

You may want to take a look at this article. Autocomplete apparently does not work if it has been more than 102 rows since the last occurrence of the entry.

Microsoft Knowledge Base Article – Q177423
XL97: AutoComplete Fails After 102 Rows Past Last Occurrence

Wow!

The hours, nay, days I have lost trying to do this simple task, AND IT WAS THERE ALL ALONG!

To paraphrase W.C. Fields: “Microsoft drove me to drink, and I didn’t even have the courtesy to thank them!”

Thanks for the tip.

I think you will find that =text([cellref],”0000#”) will accomplish the same task, and with a lot less brackets.

If the first entry is in G2, then the formula is =text(G2,”000#”).

Copy that formula down, and the cell references will automatically change to reflect the appropriate row. For example, the second entry formula will be =text(G3,”000#”), and the third entry will be =text(G3,”000#”)

Regards.

If the column is the first one in the CSV file, then the solution is a minor variation. Instead of replacing CR/LF/” combinations with CR/LF/=”, the replace changes to CR/LF/=”0.

If it is not the first column, then the solution may be simpler in a formula within Excel.

For example, if the entry is in column B, and the first entry is in B2:

=text(B2,”000#”)

Hope this helps.

Are the entries currently three digits, and you need to have a leading zero to bring them up to four digits?

If the column with the need for the leading zero is the first column, then open up the CSV file with a good text editor, and replace the CR/LF/” entries with a CR/LF/=” entry. (Of course, you would have to change the first line manually.) If it is not, then you may want to replace all ,” with ,=”.

This second choice will play havoc with any other numeric values in the file. But they can be addressed via value() formulas afterwards.

Hope that helps.

The normal routine for a CSV is, of course, something similar to this:

“Smith”,”John”,”000123456″

which when loaded into Excel gives you

Smith John 123456

However, try this:

“Smith”,”John”,=”000123456″

I think this is what you are after.

According to the Excel Help file:

Sheets in a workbook Limited by available memory (default is 3 sheets)

Personally, I would keep everything on one sheet, and then use Data|AutoFilter if I want to focus in on one student, one class, one grade, etc. But that is just my own preference.

Glad to help!