Jesse, are you on Vista now?
Yeah.
Bunnies frighten me.
Anya ,'Help'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Jesse - Apr 17, 2008 2:52:20 am PDT #5757 of 25501
Sometimes I trip on how happy we could be.
Jessica - Apr 17, 2008 3:35:19 am PDT #5758 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Since I can't afford a new Tivo right now anyway, I think the TruWay stuff sounds pretty darn neat. I assume it means more HD channels too. Whee!
Jon B. - Apr 17, 2008 3:43:46 am PDT #5759 of 25501
A turkey in every toilet -- only in America!
Any Excel VBA gurus around? I've written a bunch of macros that use this nifty functionality that lets me call an Attachmate Extra 3270 session from within the macro. Using the GetObject function, the Attachmate app opens, I automagically connect to a session and can send information back and forth between the two apps. It's really useful for copying and pasting data from my company's mainframe into a spreadsheet. It works great and has saved me a lot of work.
The problem is when I have other people run the same macro. For some people, it works fine; for others, the Attachmate application doesn't open and the macro ends without doing anything.
I can't for the life of me figure out why it works for some people and not others. We're all using Windows XP Pro and the same versions of Excel and Attachmate. Could admin privileges have something to do with it? I have them, but the other people might not.
Jon B. - Apr 17, 2008 3:58:29 am PDT #5760 of 25501
A turkey in every toilet -- only in America!
Errrhg. It's not about whether you're an administrator. It worked fine on someone's machine here who's not.
§ ita § - Apr 17, 2008 5:04:22 am PDT #5761 of 25501
Well not canonically, no, but this is transformative fiction.
How are you liking it Jesse?
Jesse - Apr 17, 2008 5:12:17 am PDT #5762 of 25501
Sometimes I trip on how happy we could be.
I'm going to have to get used to it. Really, once I get all the settings straightened out, I'm sure I won't even notice it -- especially given that we already have Office 2007 here at work.
tommyrot - Apr 17, 2008 5:21:23 am PDT #5763 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Jon B., does everyone have the exact same installation of Office? Maybe some were installed with the scripting option (or whatever it's called during installation) selected, and some without? Anyway, if you haven't already, I'd start by verifying that macros work at all on the "bad" machines....
Jon B. - Apr 17, 2008 5:29:58 am PDT #5764 of 25501
A turkey in every toilet -- only in America!
Macros, in general, do work on all the machines. Actually, it turns out that one person whose machine I thought didn't run the Attachmate macro, DOES run the macro. This changes some of my earlier assumptions. It may be related to the version of Attachmate after all. I need to test on some more machines and will report back.
tommyrot - Apr 17, 2008 5:36:02 am PDT #5765 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Jon, does the macro report any errors when it runs? Can you put in some error-trapping in the code that does the connection? Failing that (eta: if that doesn't give you the error), once your macro has instantiated the object, are there any properties you can read regarding its status?
eta²: or you could put a Stop in the code and step through to see where the problem is....
Jon B. - Apr 17, 2008 6:40:42 am PDT #5766 of 25501
A turkey in every toilet -- only in America!
Jon, does the macro report any errors when it runs?
Run-Time error '429'
ActiveX component can't create object.
It bombs on the CreateObject or GetObject functions.
It's almost definitely related to the version of Attachmate. I'm using Attachmate Extra! 6.5. The folks on whose machines it bombs are using Attachmate Extreme! 8.0.
I wish I was making up the names of those programs.