Replies

Porley,

If I understand you correctly, you want to open Excel and your program file (code.vzg) as well as a data file (data.vzg) when you double-click on the data file in Windows Explorer. If that’s the case, take advantage of the fact that Excel can open multiple files from the command line. For example, from the Run… menu:

Excel code.vzg data.vzg

Do be able to do this from Windows Explorer, you need to associate the.vzg file type with an action, as described earlier in the thread. From the Explorer menu, select View/Folder Options…/File type, etc. When you create the .vzg type, edit the Open action, and specify the Application used to perform action as something like this:

“c:Program FilesMicrosoft OfficeOfficeEXCEL.EXE” “C:My Pathcode.vzg” “%1”

This should open Excel, load the code file, then load the data file. I don’t think you will need to check the DDE box.

JohnBF’s code very cleverly takes advantage of the fact that TRUE =1 and FALSE =0. But it still leaves the problem of rounding to -$0.01 if the input is zero. We can fix that by using the IF() function. Note that FLOOR(…, 0.01) would give a numeric error, because the first argument is negative and the second argument is positive. To round the contents of cell A1 (to positive values or zero), use

=IF(A1<0.01,0,CEILING(A1,0.5)-NOT(MOD(CEILING(A1,0.5),1))*0.01)

But, dmerrix, why do you want to round to the nearest half dollar instead of to 49 cents? In the latter case, the code is a bit simpler, and you could round the contents of cell A1 using

=IF(A1<0.01,0,CEILING(A1,0.5)-0.01)

Personal.xls defaults as a hidden workbook. It’s true that you can still access it by opening the VBE and using the Project Explorer. But if you were thinking of getting to it from Excel by using

Tools/Macro/Macros…/Edit,

you’ll need to unhide the workbook first:

Window/Unhide…

Hans,

I fooled around with sorting by Custom Lists until I got them working. There were two bugs/inaccuracies in the Help, though:

1. AddCustomList method does fail if the list already exists; and
2. These constants are backwards: xlSortOrientation.xlSortColumns =1, xlSortOrientation.xlSortRows =2; but
   the macro recorder constants work: Constants.xlLeftToRight=2 Constants.xlTopToBottom=1

Thanks again for your tip.

I also prefer working in the Normal view. That’s probably a holdover habit from the old days of Word 2.0 and ‘286 computers, when other views caused a real performance hit. As far as I know, the watermarks/backgrounds are only visible in Web Layout (or possibly Print Layout) view. This defeats the purpose of making sure that a recipient of an electronic Word document knows that it is a draft. The PDF solution is probably the best one, but I wanted to use a tool I already had, if possible.

I didn’t need a time-sensitive watermark. My post was to a thread on the Windows 98 board, responding to an enquiry about a “time bomb” function to automatically delete files after a specified time had expired. Kind of like the old Mission Impossible scenario: this file will destruct in 60 seconds. Someone suggested that watermarks would be a better solution to his problem; hence,my question. The context for all of this disappeared when my post got transferred to the Word board. Thank you to those who responded.

Oh, of course! Custom Lists, not array variables. Now it makes sense. I’ll give it a try.
Thanks, Hans!

Edited by DaveA on 04-Sep-01 16:34.

Added hot link code

Another source for information on file extensions and their respective formats is http://www.wotsit.org/

Is this the way the SBE contact manager is supposed to work?
Is there a way to fix it (for instance, can I install another contact manager from the CD, and if so, how)?
Thanks.