Just This Video For Fun
http://www.youtube.com/watch?v=0VvjrldlqI0
I have many music files and I would like to try to integrate Excel in order to create playlists. I have the code to list the files within a folder...
Code:
Sub List_Files()
Dim par, sfil As String
Dim r As Range
par = Application.InputBox("Enter Directory")
sfil = Dir(par & "/*.*", vbDirectory)
Set r = ActiveCell
Do Until sfil = ""
r = sfil
Set r = r.Offset(1)
sfil = Dir$
Loop
End Sub
After I list these files, I will have another list of "Best Hits", and I will cross reference the two lists with vlookup or index/match in order to see if the files I have in the "Best Hits" list are also in the list of files which I have on my computer.
After I have my final lists of songs, I want to create a playlist ".m3u" inclusive with the cross referenced songs.
Any way to do this?
Can anyone tell me if it is possible to run multiple videos in Excel at one time. I have never done anything with Power Point but I can't seem to figure out how to do it there.
I figured a macro to click on a running video (one of four) to enlarge it to full screen with another click to minimize it might be possible in Excel. You guys have figured out how to do just about everything else, maybe you can do this too.
Thanks to the best forum on the web!!!
Excel Function Dictionary Urud & English with Videos & Presentation:
http://www.exceladvise.com/index.html
we need your comments to make it better.
Hello,
I've got a file that works just fine in Excel 2003 and 2007, but won't open in 2010. It's got a series of flash videos (via YouTube) embedded (about 10) and when Excel 2010 opens the file, it just hangs, and the status bar at the bottom says "Contacting the server for information. Press ESC to cancel". It then crashes after some time. Note that if I have one video, it's fine, though there is a 3 or 4 second lag while Excel 2010 "contacts the server" but when I bring it up to 3 or 4, it causes Excel to crash.
I'd really appreciate some help on this. Is there anything I can do to make Excel 2010 not "contact the server".
You can find an example of a file that causes this error he http://www.exceleverest.com/DownloadDemo.aspx
Cheers!
Sean
Hello,
I've got a file that works just fine in Excel 2003 and 2007, but won't open in 2010. It's got a series of flash videos (via YouTube) embedded (about 10) and when Excel 2010 opens the file, it just hangs, and the status bar at the bottom says "Contacting the server for information. Press ESC to cancel". It then crashes after some time. Note that if I have one video, it's fine, though there is a 3 or 4 second lag while Excel 2010 "contacts the server" but when I bring it up to 3 or 4, it causes Excel to crash.
I'd really appreciate some help on this. Is there anything I can do to make Excel 2010 not "contact the server".
You can find an example of a file that causes this error he http://www.exceleverest.com/DownloadDemo.aspx
Cheers!
Sean
Hi,
I saw EXCELISFUN TRICK 369. I need to do something similar. I tried to follow his code and couldn't. Then I tried copying it and growing his records and still couldn't get it to work.
What I am trying to do is on the first list use an inventory list. Which could be about 2000 - 5000 records or maybe double that (not sure how big of a list I could use in Excel). But lets say it is the max number (if someone could tell me that number I would be most appreciative).
I then will load a second list, or would load a list into second column. I then want the difference (what is missing) from the second list to appear in the third list. If it can give me the row of where it is in the first list that would be great (not a problem if you can't). I just don't know why the code from that video is not working any help would be greatly aprreciated?
Thanks,
Peter Fraga
(fragapete@hotmail.com)
I am having trouble creating a similar spreadsheet to Excelisfun video #712. The only difference between mine and his, is that I have 3 blanks between the data sets. Can someone help?
http://www.youtube.com/user/ExcelIsF...22/Po35KC2ODNw
