No, no, no, sir. No more chick pit for you. Come on.

Riley ,'Lessons'


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!


DebetEsse - Jun 12, 2008 11:34:53 am PDT #6563 of 25501
Woe to the fucking wicked.

Vortex, I believe the answer is yes (I'm looking at this now.) It looks like there are programs to allow you to pull the files from the iPod onto the computer.


Gris - Jun 12, 2008 11:59:49 am PDT #6564 of 25501
Hey. New board.

huh. Jon, that's odd. My guess is that some library you have referenced is overriding the Year function somehow. VBA apparently lets you overwrite functions with impunity. At least, if I write the code below:

Sub test()
MsgBox Year(Now)
End Sub

Function Year(bob() As Date)
Year = 2008
End Function

in Excel 2004 on a Mac, it gives the error "Type Mismatch: Array or User-Defined Type Expected" when I try to run test.


Gris - Jun 12, 2008 12:12:42 pm PDT #6565 of 25501
Hey. New board.

Extra reading has shown me (and testing has confirmed) that IF that's the problem, you can solve it by using VBA.Year instead of Year.

That is, the code below correctly returns "2008" instead of an error:

Sub test()
  MsgBox VBA.Year(Now)
End Sub

Function Year(bob() As Date)
  Year = 1999
End Function


Vortex - Jun 12, 2008 12:16:32 pm PDT #6566 of 25501
"Cry havoc and let slip the boobs of war!" -- Miracleman

It looks like there are programs to allow you to pull the files from the iPod onto the computer

oh, good. I'm not worried about the stuff on the iPod, I'm worried that the stuff on the iPod will overwrite the iTunes.


amych - Jun 12, 2008 12:18:55 pm PDT #6567 of 25501
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?

I'm not worried about the stuff on the iPod, I'm worried that the stuff on the iPod will overwrite the iTunes.

Not a worry. The stuff in iTunes can wipe your 'Pod if you're not careful, but it never goes the other way.


Vortex - Jun 12, 2008 12:21:21 pm PDT #6568 of 25501
"Cry havoc and let slip the boobs of war!" -- Miracleman

cool. that's what I thought, but I'm often wrong


Jon B. - Jun 12, 2008 12:21:50 pm PDT #6569 of 25501
A turkey in every toilet -- only in America!

Thanks for the info, Gris. As I said, I've got it working with DatePart, but that's something to think about the next time it happens.


megan walker - Jun 12, 2008 12:25:18 pm PDT #6570 of 25501
"What kind of magical sunshine and lollipop world do you live in? Because you need to be medicated."-SFist

Not a worry. The stuff in iTunes can wipe your 'Pod if you're not careful, but it never goes the other way.

Um, I'm pretty sure that I've been asked some version of "There's stuff on your iPod that's not on your computer, do want to update the computer?"


tommyrot - Jun 12, 2008 12:27:47 pm PDT #6571 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.

I think it does that in case you have stuff you bought from the iTunes store... and that's all it copies over.

It's possible I'm thinking of something else....


Vortex - Jun 12, 2008 12:37:45 pm PDT #6572 of 25501
"Cry havoc and let slip the boobs of war!" -- Miracleman

Um, I'm pretty sure that I've been asked some version of "There's stuff on your iPod that's not on your computer, do want to update the computer?"

oh, fine, scare me then! I think I should just make sure that "manual sync" is checked, I should be fine.