So, I did it. I'm in the middle of a system restore to about two weeks ago. I don't think I'll be losing any documents I can't replace, but I will have to reinstall some software. We'll see if printing just gets broken again. And if it does work, I'll have to figure something else out to fix printing on S's machine.
I'll just jump in my time machine, go back to the twelfth century, and ask the vampires to postpone their ancient prophesy for a few days while you take in dinner and a show.
Giles ,'Selfless'
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!
Sean K - Jun 10, 2008 5:41:51 pm PDT #6552 of 25501
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty
Sean K - Jun 10, 2008 6:27:41 pm PDT #6553 of 25501
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty
HA! System restore failed to fix printing. I'm currently 10.5.2, and I could print under 10.5.2. A test print just failed.
Typo Boy - Jun 10, 2008 6:33:56 pm PDT #6554 of 25501
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.
In terms of manipulating content of Acrobat file - Scan Soft - cheaper than Acrobat (well was when I bought mine - may have changed) and can do more - import into word, make changes, print back into adobe.
Sean K - Jun 10, 2008 6:39:57 pm PDT #6555 of 25501
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty
In terms of manipulating content of Acrobat file - Scan Soft - cheaper than Acrobat (well was when I bought mine - may have changed) and can do more - import into word, make changes, print back into adobe.
Heh. And since I don't have Word, and would have to open the .doc import with Pages, I now find myself wondering just how many different file types I can convert this file to.
DCJensen - Jun 10, 2008 7:40:28 pm PDT #6556 of 25501
All is well that ends in pizza.
Contact Customer Service
Please select a product group for appropriate contact information on the product you purchased or questions before you buy.
Multi Function Center®
7777 North Brother Blvd.
Bartlett, Tennessee 38133
1-877-BROTHER (877-276-8437)
901-379-1215 (fax)
9:00am to 8:00pm Eastern Time
Jon B. - Jun 12, 2008 10:04:27 am PDT #6557 of 25501
A turkey in every toilet -- only in America!
Excel VBA question:
Anyone have any clue why the Year function wouldn't be working for me? If I use Year(somedateserialnumber or text here), I get a compile error with the message "Expected Array". If I try to use Application.WorksheetFunction.year, it compiles but bombs and I get the error message
Run-Time error '438': Object doesn't support this property of method.
The Month function works fine, but Year doesn't. WTF?
tommyrot - Jun 12, 2008 10:15:53 am PDT #6558 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.
You haven't accidentally changed your computer to European date formatting, have you?
Also, does the Year function work outside of VBA (i.e. in a cell)?
Jon B. - Jun 12, 2008 10:20:30 am PDT #6559 of 25501
A turkey in every toilet -- only in America!
Yes, it works in a cell.
I still don't know why it's not working in VBA, but i found a workaround using the DatePart function.
Now, to figure out why Application.WorksheetFunction.Sum isn't working either...
Vortex - Jun 12, 2008 10:24:59 am PDT #6560 of 25501
"Cry havoc and let slip the boobs of war!" -- Miracleman
Hey, all. What happens if I take my old iPod (which was permissioned to my old computer, which has gone to the great network in the sky) and hook it up to the new computer/iTunes? Will it wipe the info on the old iPod and upload the new iTunes?)
tommyrot - Jun 12, 2008 10:29:06 am PDT #6561 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.
Now, to figure out why Application.WorksheetFunction.Sum isn't working either...
Um... have you tried rebooting?
I'd also go into the VBA window and check Tools/References and make sure none are broken.
When we have weird problems like this in Access, sometimes a decompile/recompile will fix things. Dunno how to do a decompile in Excel (in Access you do it with a command-line switch) but you could try copying the code in question and pasting it into a new Excel spreadsheet VBA module.