Recent content by darag2358

I want to change the assignment units from a percentage to decimals. When I go to Tools > Options > schedule tab > Show Assignment Units as decimals, it only seems to change the units as decimal for me. If another person on another workstation views the project file, it shows as a percentage...

Back to the top...

Nope not getting any message like that and unfortunately I wouldn't be able to upgrade his office version. Now he is reporting to me that he occasionally saves an image to his c:\temp folder that he uses to copy to email, and it also creates a shortcut to the image file on his desktop. Sounds...

I have a user who opens a certain Excel 97 workbook and a shortcut of the spreadsheet automatically gets placed on his NT desktop. It only happens with this one spreadsheet, which has no VBA coding. I tried searching the web and I saw one other person that had the same issue post the issue in...

I would check to make sure she is using the correct printer driver first. I don't know of any setting in Word that would turn off printing for underscored letters.

Which is the registry setting that changes when you go in to Tools, Options and enable autocomplete for passwords?

Still not sure about your process, but this should help. I'm assuming that you are opening your Test.txt file in Excel and then separating them in to columns - in your example above, columns A through I. Somewhere to the right, like column J put this formula in J1 and copy down...

Ooooops. Change 2nd line to: Range("A:A").Clear Did I mention I was rusty?

Probably needs to be done in VB. I'm a little rusty but something like this if you are working with range A1:A100 ======================= Sub Autonumber() Range("A:A").Delete For c = 1 To 100 Cells(c, 1).Value = c Next c End Sub ======================= Then you can assign it a...

Not exactly getting everything that you are doing, but sounds like you are wanting the VLookup function in Excel? Take a look in the help section in Excel for details on how to use the function.

BTT

Have a user who is getting an error whenever he tries to use Save As. Error: "The instruction at (0x3001e2f6) referenced memory at (0x42c4c676). The memory could not be read..." He can use "Save" just fine, just not "Save As". Running Excel 97, Win NT 4.0, and...

You get any messages when you double-click on the file? Or does nothing happen at all? What operating system?

Don't think I am completely understanding what you are trying to accomplish, but I think you might be looking for the Vlookup or Hlookup function? Check out the help section in Excel for information on how these two functions work.

I can seem to view the properties window. I have tried deleting my cache.dsk file, but still not able to get this to work. Just started happening today. If I choose document properties, nothing happens - no errors. Any advice? LN 4.5 Windows NT 4.0