Mark Pierson wrote:If you can view the sheet called "Setup", that's all you need. What I don't know is whether the lookup functions that populate the fields on "Setup" will work with the viewer.
Mark
While the Free Excel Viewer allows me to look at the first page, I cannot enter any data thus not allowing anything but the initial "Cable 0525" to be shown using the Free Excel 97 Viewer.
I do not believe that the Devices4 excel file is password protected or encrypted but is simply compressed. If the file was saved by Excel uncompressed and then Zipped up as the current one is the resulting file size would be about the same.
Then I suspect the tools I have would be able to read the file and I could manually search for what I am Fisching for.
This would not be a general solution as the Free Excel Viewer action would remain the same.
The Robman wrote:Do you have many setup codes that you want to look up in devices4 or just a few. If it's just a few, post what they are and one of us will post files with the info that you need.
Later, Rob
Other than wanting to look at the entire file for learning purposes, there is only one code that I am looking for.
Prior to learning about JP1 I had great difficulty getting my RCU810 to learn one key on the original RCA TV remote. It would take 5 or more times to get the RCU810 to learn the key, sometimes many more.
My RCA TV Model (RCA F27683GY) was part of the one year customer purchased BETA TEST of the "TV Guide (Plus+ ?)" (text mode only) on screen free (Paid by TV pricing) listing service.
The key is the "TV Guide (Plus+ ?)" Schedule Recording (And / Or) VCR Recording button.
When I downloaded the RCU810 into IR, IR had just a hard time understanding this learned key.
2 TV Rec Gap-390-1617-24? 143 14 23 8F.E.17
The "TV Guide (Plus+ ?)" system changed to a graphic one the next year and I had to put the "TV Guide (Plus+ ?)" system into a special mode to download new software. I do not have many of the features of the current system.
A purchased RCA TV General Remote had the other TV Guide+ keys but not this one which was changed the next year with the Graphic Mode Version. I plan to do 10 or relearns and see if IR can understand any of them.
Mark Pierson wrote:Just an FYI, of all the JP1 spreadsheet tools, devices4 is probably the only one that might be portable to another app (though I'm not sure if Excel's Data Validation feature is supported by any of the other SS apps).
The other Excell-based tools, like KM, special-protocols, Extender Code Calculator, etc, use advanced features of Excel that prohibit their being ported to other the apps.
Lastly, since devices4 is getting dated (it's based on the 15-1994), it's necessity has gone down substantially. Many people >here, especially the experts, can probably help you locate whatever it is you're looking for.
Mark
I do not believe that Excel has ANY features that cannot be done in other Spreadsheets.
With Lotus 1-2-3's ability to switch to Script Mode I can add any programming needed should it not be built in.
For my own use of "Devices4", I would probably convert to Paradox 10 for my own use as I use its programming mode a lot. That is if dv4 has what I think it has. Not for general distribution.
SHF
