Replies

Since I’m under a deadline I’d rather not wait for Excel 2007. I thought about Access not having the 65K row limit, and that perhaps a crosstab query might work, but I lack experience with that feature. Whatever method is easiest for you, using Access so the report includes all my data, would be great.

Chris, thank you. I went to the site. I didn’t see anything helpful right off, and one of the links was a dead-end. There was a suggestion to have Windows “see” the iPod as an extra hard drive, so that may be worth looking into. (I have two programs that will sync folders.) I will continue to check there since I may have missed something. Thanks again!

Indeed there is an Export feature. Click File, then Export Song Library. It produces a delimited file that Excel opens easily. (I noticed my library at work is partially on my hard drive and partially on my network drive, so I suppose I should fix that.) I have less than 1000 songs at work, so it shouldn’t be too big a job to find the gaps between here and home — I hope. Thanks again.

John, thanks for your reply. I guess the next step would be getting a list from each computer and figuring out the differences. For example, is it possible to print a list from the iTunes library to a text file and put the two lists side-by-side in Excel? That may not be ideal, just the first thing I thought of. Thanks again.

Thanks very much, John!

It works great. I knew I was close, but just hadn’t put the pieces together. Thanks a million, and have a great weekend!

It did. I have been using a group of third party add-ins for several years. Evidently not all of them have been freshened to work with Excel 2003. Some have. I will watch the vendor’s web site for new versions. Bookmarked the “Fixing Startup problems” page as well.

Thanks a lot!

We’re using Office XP SP-2. I had noticed that Office seemed to hold the view setting once I selected it, but it doesn’t seem to hold it the next time I sign in to the network. I was hoping there might some kind of registry hack that would do the job, that I could take to my IT staff. Thanks for the replies.

We’re using Office XP SP-2. I had noticed that Office seemed to hold the view setting once I selected it, but it doesn’t seem to hold it the next time I sign in to the network. I was hoping there might some kind of registry hack that would do the job, that I could take to my IT staff. Thanks for the replies.

Thanks for the responses. This pretty much confirms what I thought originally. Thanks again.

I left out a vital piece of information. I’m doing calculations with this – starting at x date and time and adding y number of hours to it. Sometimes the value of y is greater than 24 hours, so I need the date as well as the time. Sorry I left that out.

Mark, thanks, I will pass that on to her to check.

By the way, I can think of maybe a hundred pithy things to say about your “picture”. Suffice that I love that movie and wish I’d thought of it first.

OK, middle age strikes again. Those curly braces looked like parentheses. I looked at VB Help for SendKeys and they looked like parentheses there, too. Yes, I don’t want the messages permanently deleted at first, since I seem to be vulnerable to Murphy’s law of deletion (anything deleted permanently will be needed five minutes after deletion). This code marks it as read then sends it to the deleted items folder.

Sub Expunge()
SendKeys “^q {del}”
End Sub

I’ll check that website, thanks.

This is really interesting. Here’s the code that does what I need:

Sub Mark_read_delete()
‘ this macro marks a message as read & deletes it
‘ from Woody’s Lounge 5/02, message at:
‘ http://www.wopr.com/cgi-bin/w3t/showthread…t&Number=139201
SendKeys “^q ^d”
End Sub

For some reason the code SendKeys “(delete)” doesn’t work. I had to use ” ^d”.

Is there a (good) reference/web site on using VB in Outlook as there is for Excel and Access? Other than this one, of course. Thank you both for the help. That soft drink offer is still open if you’re down Texas way.

I posted a thank you on the other message. Sorry, multiple windows, middle-aged brain and all, lost my place. This code permanently deletes the message(s), then?