Search results

I am not sure if one formula will do this or of a I need a formula in each row and then total the result. If a formula cant do this then I will resort to a macro. column B contains 0, 1, 2 and 3 column E contains the estimated value column F contains the real value I want to know on a row by...

thank you I'm trying using a media player active x to see where this gets me. I'll have to learn how to use it but time is on my side smiler44

thank you very kind. I will keep trying, I'm of the mindset, it is possible... just I dont know how :) smiler44

for this project, i dont press the shuffle button, once i have manually selected the songs i press play. i select windows explorer/documents/directory holding songs/ the songs i want to play/play smiler44

no no no :) you are thinking of an existing macro that selects a song, i need a new one and this macro will not select any songs, just work out the duration of the song being played or give me the song title of the song being played. We need to ignore any existing macro and start a fresh :)...

i do as in me but the macro doesn't and cant hard code the song title as next time i may select different songs . smiler44

:) all i want help with is getting the duration of the song being played or the name of the song being played. I think once I have this info I can proceed smiler44

sorry I mised that. The songs are in a directory in My Documents and has artists name followed by song title and file extension then date file created and duration . Adele - All out of love.mp3 12/11/16 13.42 00.03:50 yes you are correct all songs in one directory and no other files in...

I've tried Access, could not get on with it and that was when I may have needed it for a job I was applying for. Now I dont need it, there is no way I could learn it I'm not that clever macafee2

Gasman, I think you may be misunderstanding or I am misunderstanding. The code I have posted randomly selects a song from a directory and plays it. If the duration of that song does not exceed the time to play songs for, it randomly plays another song and so it goes on. In the macro i want, I...

Thank you Gasman, I was chuffed when it worked. would i be taking the mickey if I asked what should it be :) smiler44

this is the code that my existing project uses Sub start() ' play music for pre determined time Sheet1.Range("A1").Value = "00:00:00" Sheet1.Range("A2").Value = "00:00:00" Sheet1.TextBox2.Value = "00:00:00" Call randomlyselectsong If Sheet1.CheckBox1.Value = True Then ' shutdown laptop Call...

I am just tabbing through the code to make sure what i provided was working, have you tried the code? Are we getting out wires crossed? Ignoring the code i have provided can you help with using vba code to get the name of the song currently being played by windows media player? smiler44

Am I right in thinking that the song title is known when the fileinfo function runs? In this new situation, I have not been able to acquire the title. If you could help me get the title of the song being played by windows media player I'd appreciate it. smiler44

Gents I must tell you I'm no expert in coding as you can see. I have never done it for a living but have used and crated macros for work. I've had no training and a lot of stuff even if I use it I dont understand it, mainly because I did not create it. I have found a lot of stuff on the internet...

i think it pauses excel for the duration of the current song being played so it finishes before excel plays the next song. i can also see how long music has been playing for before and after the current song smiler44

isladogs, may be i dont quite understand. Once I have the attributes what can I do with them? I dont know (my code does not know) what song is being played and so cannot look the attributes up for that song. I need to obtain via code the duration of the song currently being played or the...

i created a marco with help from here and the internet that randomly plays songs for a pre determined time. i hope this is all of it. it may look as if i declare part way through a module but in fact this code is over 2 or more modules and the declarations are at the top Dim fd 'file...

I dont think so. I did find code doing an internet search that did the same or similar. This code lists the attributes and unless i can work out what song is being played, i cannot go the the attributes and retrieve the duration. smiler44

i am selecting songs to play using windows explorer, opening the directory, selecting the songs and pressing play. am i right in thinking your code requires me to know the title of the song? This is something i will need to obtain via code, i cannot pre program it i am not using Access just...