bizzybody
Content Type
Profiles
Forums
Events
Posts posted by bizzybody
-
-
I poked around some more and found this works. Select the range on Sheet 2 to be linked. Select the range on Sheet 1 to link to. Click Paste Special on the Edit menu then click the Paste Link button. Repeat for the other five columns.
Now any changes made in column A on Sheet 2 get automatically transferred to Sheet 1. Still not as simple for the user as a contained on one sheet list that can be edited in-place with alphabetizing happening right there. That I'm still interested in doing if possible.
0 -
I want to make a worksheet in Excel 2003 that's 12 columns by 35 rows. Six columns of numbers separated by six columns of text.
What I have right now is the above laid out on sheet one and on sheet two I have all the text entries in column A. I sort that column then copy and paste 1-35, 36-70 etc. work and tedium. Bleah. The last version of Excel I used much was 97 (I even took a course on it, 13 years ago). I figured by 2003 Excel ought to be able to alphabetize a discontinuous selection, but it still can't. If I select the whole list and have it sort starting with column A it scrambles the numbers (no leading zeros, and I don't want those). If I have it start with column B it won't do anything.
What I want to be able to do is enter text in the text cells and be able to alphabetize it without doing anything to the number columns. Shuffling through 13 year old memories of Excel 97, I thought about linking cells between sheets. Should be able to link 1-35 of column A on Sheet 2 to 1-35 of column B on Sheet 1, 36-70 of A on 2 to 1-35 of B on 1 - and so on. With that I should be able to input text in A on 2 and have it automatically change the text on Sheet 1. No math formulas required, just make what text is entered in a cell on Sheet 2 pop into its linked cell on Sheet 1.
Is there a quick way to do that without having to do 210 individual cell links?
'Course it would be simplest if I could just control+click the six text columns and bang the A>Z button and have it sort across the gaps, but Excel 2003 isn't that fancy. Seems to be such an obvious and useful feature, but apparently not to Microsoft.
The most elegant solution would be a one sheet list with self contained "magic" so that text could be entered into the highest numbered empty cell and all the columns auto-alphabetize when Enter is hit.
0 -
I did more searching and found an MS KB article on it, says the problem happens when MP11 is not full screen but doesn't when it's full screen - and puts the blame on improperly formatted DVD menus.
Well that's utter bolloks! The DVDs don't work in full screen or not and they work perfectly fine on any other software or player. Thank you Microsoft for not giving a **** about fixing your buggy software.
0 -
I'm having a problem with Media Player 11 where it's impossible to play some DVDs. It won't work the menus correctly, the active spots won't highlight when the mouse cursor is moved over them and on DVDs that use an indicator graphic to show which is the currently selected button, it won't show that.
The latest ones I've tried that it can't play are the special edition Monty Python and the Holy Grail and the Firefly TV series. It's also doing this on most DVD's I've authored with several different programs, but every one MP11 has problems with work perfectly on DVD players and other DVD playing software.
The fix for *me* is easy, use something other than MP11, but when I send a DVD off to someone and all that person has on their PC is MP11 that won't play it, that's not a good thing at all.
Time for Media Player 12, eh? (I doubt MS will release the next major version for XP.)
0 -
I just did a clean install of XP Pro SP3 on a new PC with an AMD LE-1260 CPU and 2 gigs RAM. There cannot be any viruses or malware on it, I've installed nothing but Windows, IE8, Media Player 11, Adobe Reader 9, WinZip 8.1, the latest Firefox (non-beta!), Google Chrome, all current updates from Microsoft Update, Avast 4 and Spybot S&D.
All fresh downloads, not from anything that's been in contact with any other computer.
So now I want to run an old EGA solitaire card game that's never ever had any problem running on any PC all the way back to an IBM model 5150 PC, or on any version of Windows from 3.1 through Vista Ultimate. (I have an Acer Aspire 5315 laptop with Vista on which this old game works perfectly.)
When I run it I get "The NTVDM CPU has encountered an illegal instruction". Searching the web shows that's an issue with the 16bit MS DOS Subsystem.
I'm wondering if Avast might have something to do with this http://support.microsoft.com/default.aspx?...b;en-us;Q314452
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\VirtualDeviceDrivers\VDD
has C:\Program Files\Alwil Software\Avast4\aswMonVd.dll in it. The COMMAND.COM in the System32 folder is the correct one.
A post on another forum claimed adding the full path to COMMAND.COM in config.nt fixed this error. shell=c:\windows\system32\command.com /e:2048 /p
Didn't work on this computer.
0 -
Picked up a Maxtor QuickView DiamondMax Plus 8 40 gig for $5 from a thrift store. (The place has several of these.) All the computer guy there could tell me about it was it was pulled from a DVR.
Right now I have it connected to a board with nothing but the drive, a floppy drive and a video card. BIOS setup sees it with full capacity. I tried booting with a 98SE floppy and FDISK can tell there's a hard drive but gives me "Error Reading Fixed Disk".
I hooked it up as primary slave on an XP system and Disk Management can't do a thing with it, shows it's empty but won't allow partitions to be created. HDD Unlock Wizard's demo claims the drive is not locked. Something must be locked or password protected on it.
What utility will unlock this drive so it can be used normally? Preferably something I can run off a boot floppy or is in a bootable CD image.
0 -
"Foolproof" instructions for this driver?
I'm fixing up an olde Compaq Armada 7380DMT* (I don't have a USB card for it) and writing what I hope are user-proof instructions for various things. Here's what I did for this USB driver.Feel free to copy, modify, add to, remove from, fold, spindle, mutilate, translate into Farsi...
*This laptop dates from 1999, quite possibly the last laptop series ever *without* built in USB. Strange of Compaq to not have USB on these when others had it at least as early as 1997.
1. Obtain a Cardbus USB card with Windows 98 Second Edition drivers.2. Follow its instructions for installing its drivers.
3. DO NOT install any drivers for your USB Mass Storage devices.
3. Run nusb33e.exe to install universal USB Mass Storage drivers.
All USB Mass Storage devices such as external hard drives, thumb/pen drives, floppy drives, audio/video players, digital cameras and cell phones with drive/disk/mass storage mode should work, as long as the filesystem is FAT16 or FAT32.
In other words, if you can plug it into WinMe, 2000, XP or Vista and use it like a disk drive *without* having to install a driver, it *should* work in 98SE with this driver.
If not, go here. http://www.msfn.org/board/maximus-decim-na...ers-t43605.html
This driver DOES NOT SUPPORT non-storage devices such as scanners, printers, tablets, cameras/phones that *don't* have a drive/disk/mass storage mode, or any other device that doesn't act like a disk drive.
If it is a storage device and requires a driver for WinMe, 2000, XP or Vista, it won't work with this driver in 98SE. (Note that some storage devices may have drivers/utilities for features other than basic storage support that does not require a driver to be installed.)
This USB driver is only for the ENGLISH version of 98SE. See the above forum link for versions for other languages. If there's not one for your 98SE's language, ask nicely and someone there may be able to fix you up.
Why this driver instead of installing individual drivers for every camera, drive and phone? Multiple USB Mass Storage drivers use up room on your hard drive, use more RAM, add more bloat to the Registry and can cause conflicts with each other.
Additional note for media with a formatted capacity of less than 32 megabytes (includes media with exactly 32 meg unformatted capacity). Windows 2000 and XP will format such media as FAT12. Windows Me and 98SE with this driver will format such media as FAT16. It's best to never format 32meg or smaller media with 2000 or XP, especially when it's the non-removable memory in a device.
0 -
Is there a program that can copy the Win98SE DOS system files to a hard drive from XP? Would be nice and easy to be able to hook up a drive as slave, format it FAT32 then SYS it with the 98SE files, then copy the 98 install files, drivers etc. to the drive.
All it'd really need to do is ensure IO.SYS is in the right place since with 9x MSDOS.SYS and COMMAND.COM don't have to be located in specific sectors.
Then I could just plug it into its final resting PC place and install - just like I used to do in ye olden dayes when my main OS was 98SE. I don't work on old Windows versions enough to justify having a box running it full time or even dual booting it.
0 -
TSST TS-L632D DVD/RW/RAM drive with latest firmware.
It's from a Dell laptop, I flashed it with the Toshiba firmware to enable all the media types the drive supports. Dell had Dual Layer DVD-R and DVD-RAM disabled, but Double Layer DVD+R was enabled. Exactly the same drive, just for some reason Dell decided to cripple it a bit.
Worked fine for quite a while with autoplay turned off, then one day it started acting up and only quit when I re-enabled autoplay. Probably some "critical update" caused it.
0 -
I have Vista 32bit with SP2 integrated in an .iso
Can I do everything with that using vLite that I did starting from an Anytime Upgrade DVD? (I used vLite to integrate SP1 then removed a bunch of stuff.) If there's anything at all that vLite will bugger up using the SP2 integrated .iso, I'd like to know *before* I spend a ton of time making a trimmed down disc.
I remove the sidebar, flip 3d, UAC, tons of drivers for hardware my laptop doesn't have and never will, all the useless frippery goes out. Amazing how *small* an 80 gig drive seems these days. My sister has an identical laptop, she likes the sidebar and some of the other bloat, so I've made more bloaty custom install DVDs for her.
What'd really be nice is some SP2 installer helper that either lies to the SP2 installer about the presence of missing stuff and shunts such updates off to /null, or temporarily installs stuff the SP2 installer really must have (from an un-modified SP1 updated disc or .iso), then rips them back out once SP2 is installed.
0 -
Vista Ultimate SP1. When I turn off autoplay for the dvd burner, Windows claims all discs are "blank" until I use Nero Info Tool to check the disc. *Then* Vista will go ahead and read the disc.
It will also fail to update the disc contents, showing the files and folders of the *previous* disc along with the contents of the current disc.
If I turn autoplay back on, the problem goes away but I have to put up with the annoyance of autoplay and its interference with burning discs.
Microsoft has created a virtual version of a bad floppy drive change line for optical discs.
0 -
Try the Registry file here to put a Take Ownership option on the rightclick menu.
http://www.howtogeek.com/howto/windows-vis...-menu-in-vista/
It also has a Registry file to remove that.
0 -
I found that something changed the config.nt file in windows\system32 so I copied the backup from windows\repair That worked for a while to make the old game run, but something chaned config.nt again. So I copied the backup again and this time checked the read only attribute.
Full scans with up to date Avast and Spybot Search and Destroy come up clean.
That was the shareware version I attached. I never paid for the full version. I assume part of the $5 the disk cost me off a spinner rack went to him. There's no nagging or other reminders, dunno what, if anything extra the "full" version was supposed to have.
*reads the Klondike DOC file for the first time ever in 17 years* Hmm, Mr. Martins also wrote a Poker Solitaire and Pyramid solitaire game, also in "high-resolution EGA graphics" and "They can be found wherever you bought Klondike." Not likely, considering the drugstore where I got the Klondike disc isn't there anymore.
Oh look, it has commandline options for computers without a mouse. The stuff one can discover from those instruction thingies...
Edit: HOTU has his Poker Solitaire game tagged as freeware. http://hotud.org/component/content/article/37-strategy/22980
0 -
I need to capture a screenshot showing a video playing in Windows Media Player 11, but Windows' built in function only gets the not quite black overlay color inside the MP11 window.
There was a free screen capture utility I used with Win9x that took over control of the Print Screen key and would caputure anything on the screen to the clipboard, in spite of various softwares' attempts to prevent it. Can't remember the name of it.
0 -
You're probably in a smaller minority with IE6 than than Netscape 7 users.
Not even the Win 9x/Me die-hards use IE6 since Opera is still in current development for those versions of Windows. I recently gave away an older PC with WinMe and the latest Opera version. It's new owner is perfectly happy with it for web use.
0 -
My mother loves this ancient 1992 DOS Klondike game by Eduardo Martins. It uses medium resolution EGA video mode and until recently it ran fine on her laptop with XP Home. Yup, that's the whole game in that 116K zip file. I originally got it on a 360K shareware floppy.
Suddenly it won't run properly. When launched it opens a DOS window then minimizes to the taskbar. Click the button on the taskbar and it expands then immediately minimizes again.
It's supposed to run full screen. The shortcut properties are set to run full screen, all the shortcut settings are the same as on another XP system where the old game still runs like it should.
0 -
Figured out it needed a null modem type cable, so I scrounged up a 25 pin serial and 25 pin parallel backplate connectors and soldered one together.
Now I'm able to make the plotter do things using the Roland driver I've seen mentioned many places working great with old HP HPGL/1 plotters, but so far it's not plotting correctly what's on screen in Dr. Stika.
That driver has no pre-sets for US Letter! When I manually add that, Dr. Sticka's print setup doesn't allow the custom media size to be selected. Bleah.
At least I have the thing communicating.
0 -
I've checked all the BIOS and other settings. There are NO conflicts with anything on COM1. This PC only has one COM port, there's not a COM2, no pin header on the board for one. ONLY ONE COM PORT - PERIOD. No BIOS setting for a second one.
I was using an external Sportster 56K modem before getting DSL. I REMOVED THE DRIVER FOR IT.
I'm attempting to get an old HP 7470A 2-color pen plotter (rebadged as an IBM 7371) working on COM1. I've installed XP's HP-GL plotter driver. I've made sure the driver settings and plotter DIP switches match. (I've had a bag of red HP plotter pens for years, got them free. The plotter cost me a whole dollar.)
HP's website says the plotter can be tested by sending this command from DOS or a command prompt.
MODE COM1: 9600,N, 8,1,P (sets the port)
ECHO IN; SP1; PA0, 0;PD1000, 1000;SP0; PG;>COM1 (makes the plotter draw a diagonal line)
The first command worked ONE TIME. I'd removed the plotter driver while trying to get some response from the plotter and forgot it was removed when I tried the second line.
Since then all I get is the "Device COM1 is not currently available" message when I try a MODE command. I get access is denied when I try the test command.
I've disabled the port, rebooted then re-enabled the port and rebooted (flashback to Win9x and changing anything on network settings) and tried removing COM1 then rebooting and letting XP reinstall it.
I am logged in as a user with Administrator rights.
Nothing will pry loose whatever it is XP has "using" COM1. Is there something like an Unlocker type utility to force Windows to let go of COM ports that aren't really being used?
Edit: I tried making a direct connection to COM1 with HyperTerminal. That says another program is using COM1. There shouldn't be. It was available right up until I ran that MODE command.
Edit2: Found a post on another forum that said to use Process Explorer and search for serial1 Results? NOTHING. The OP on that thread found it was ActiveSync hogging his port. Apparently I have nothing using COM1, but XP thinks *something* is. (Another button for Sledgehammer For Windows: "Force Windows to let go of COM# port! It's NOT in use, biatch!"")
0 -
Did that, several times.
Tonight I booted up with DaRT 5.0, deleted the swap and hibernation files then used its system restore to roll back a couple of weeks. Rebooted and the emulators now run.
Microsoft Update has nothing "new", so it can't have been a "security" update that decided the JIT mac emulators are malware.
But the Xflash program from codeguys is still being blocked from running.
0 -
XP Pro SP3, all current updates.
I have some exe files that for reasons unknown, XP is not allowing to run. One is xflash_utility.exe from codeguys.rpc1.org a utility for flashing LiteOn optical drives with firmware.
The others are the JIT version of the Basilisk II 68K Macintosh emulator and the SheepShaver PPC Macintosh emulator.
When I doubleclick or rightclick then click Open, nothing happens. THERE IS NO ERROR MESSAGE. The name of the exe will briefly flash in the process list in Task Manager. I'm logged in as a user with Administrator rights. I've also tried run as Administrator and logged in as Administrator.
Other exe files run without a problem. The emulators were running fine but suddenly they will not, just happened yesterday.
It's not Avast antivirus causing the problem. I've stopped it and even killed it, those programs still won't run. The optical drive flasher never has been able to run on this particular PC since I downloaded it. The program is OK because it will run, extracted from the same ZIP file, on another PC running XP Pro SP3.
I have run into XP completely refusing to allow certain exe files to be launched before this and the only cure I could find was to do a clean install. I just did a clean install not long ago and I am not going to do it just to get three little programs to work, especially not when two of them would run two days ago.
0 -
How do I make the default columns for Details view in Explorer to
Filename, Date Modified, Type, Size
Vista is always changing them to the settings for music, even after I have it apply the 'all items' template to the root and all subfolders. I've no use at all for the Genre, Ratings, Artist etc columns but I do use Dimensions for images and Frame Width and Frame Height for video. Due to the strict adherence to alphabetical order, after selecting those two I have to drag and move Width to the left of Height. (MS couldn't have programmed in a bit of extra logic to automatically arrange them that way, nooo, too logical to make it match how the entire video industry lists the dimensions of an image.)
Would be nice if there were separate width and height columns for images too! What'd be extra good is if there's a way to make it use the 'all items' template by default then add Dimensions if image files are in the folder and/or Frame Width and Frame Height if videos are in the folder.
0 -
I haven't tried to install SP2 yet, would be nice to know what can be removed with vLite, while adding SP1, and still be able to install SP2.
Been doing some research and looks like for the first time Microsoft has released a non-cumulative service pack so SP1 must be installed before SP2.
It also looks like the author of vLite isn't going to "step up to the plate" and update it to integrate SP2, so we're back to the 'reverse integration' method. I'll have to find somewhere to shift a few gigs of files to do that- then I'll be stuck with all the crap I removed from Vista Ultimate SP1 using vLite.
0 -
OK, here it is.
0 -
I don't have the lastsession.ini from when I made this CD, but I do have the winnt.sif
I made this quite a while ago, just now got around to doing the install. Easiest thing I can do right now is boot it with ERD Commander 2005 and break in with Locksmith.
I wonder if it has anything to do with the password being 14 characters?
Have you typed the password in the 1st box to rule out keyboard config issue ?There's just the password box when I click the Administrator icon, it's using the fancy Welcome screen, not the old style logon screen.
; Generated by nLite 1.4.9.1
[Data]
AutomaticUpdates="No"
Autopartition=0
MsDosInitiated=0
UnattendedInstall="Yes"
[unattended]
UnattendMode=DefaultHide
UnattendSwitch="Yes"
OemPreinstall="Yes"
OemSkipEula="Yes"
FileSystem=*
WaitForReboot="No"
NoWaitAfterTextMode=1
NoWaitAfterGUIMode=1
DriverSigningPolicy=Ignore
NonDriverSigningPolicy=Ignore
Hibernation="No"
[Display]
Xresolution=800
Yresolution=600
BitsPerPel=32
[GuiUnattended]
EncryptedAdminPassword="No"
AutoLogon="Yes"
AdminPassword="999valveportal"
TimeZone=010
OEMSkipRegional=1
OemSkipWelcome=1
[Components]
[userData]
ProductKey="K8X93-8V8YF-*****-*****-*****"
ComputerName=ENRICHMENT
FullName="Simulation Unit"
OrgName="Aperture Laboratiries"
[RegionalSettings]
LanguageGroup=1
Language= "0409"
[Networking]
InstallDefaultComponents="Yes"
[WindowsFirewall]
Profiles=WindowsFirewall.TurnOffFirewall
[WindowsFirewall.TurnOffFirewall]
Mode=0
[identification]
JoinWorkgroup="APLABS"
0
I'm fixing up an olde Compaq Armada 7380DMT* (I don't have a USB card for it) and writing what I hope are user-proof instructions for various things. Here's what I did for this USB driver.
How about a 'cage match' of the various ways to get the Classi
in Windows 7
Posted
Let's have a knock-down, drag out battle royale of every program and method that can be found to restore the good old Classic start menu to Windows 7. Assign points for how close it is to the real deal, stability, automatically adding newly installed programs etc. If it causes error messages, crashes, any sort of thing that shouts out it's not like the original, then knock off points. Of course free methods should get an automatic point bonus because we're just trying to get back what Microsoft should've left in.
If you think the scrolling menu is the bees knees, Microsoft's gift to all mankind, goody for you! Go forth and use it in happiness and love - just don't tell those who don't like it they should embrace the new because *you* think it's better.
Looks like there's far more people out there who hate the new start menu in 7 than who despise the unchangeable and nearly invisible "highlight" color in Vista's and 7's Windows Explorer. (I'm still looking for a way to change that color.)
These are people who, if they used Win Me, the first thing they did was disable single-click and the scrolling/personalized Start menu and the first thing they do in Vista is to enable the Classic start menu, if not going all the way with disabling Aero.
As for myself, on Vista I use the Classic start menu but leave the rest alone. Microsoft managed, somehow, to make the rest of the Classic UI *wrong* in some fashion in Vista that bugs me to no end.
If you think the scrolling Start menu is super duper, have you ever seen Vista or 7 with 100+ different programs installed? That's one loooooooooong scrolling menu. When I work on someone else's PC with Vista, I'll temporarily switch it to the Classic menu so I can get things done. Most of them want to know how I did that because they HATE the scrolling menu, so for them I show them.
But for 7 MS expects everyone to be good little robots and do it their one and only, focus group approved way. (Such group carefully 'weeded' of anyone who'd tell them to go push a rope!)
P.S. If anyone just posts New Start Menu GOOD, Classic Start Menu BAD proselytizing posts in this thread, could the moderators just delete them? As I said before, anyone who likes the New Way is welcome to it. You don't need to waste your effort trying to force those who don't to follow your path.