Search results

thank you pbaldy, currency has worked. I never knew integer could not deal with decimals. smiler44

I have a macro comparing the value of two cells next to each other but 39.99 is being rounded up to 40 and 33.17 rounded down to 33. I have no idea why or how to cure it, please can you advise? Below is my code and it is Excel 2007 thank you Dim rt As String ' number of times Dim ev As Integer...

thank you both, for some reason I did not get a email notification. I think I will need to put "that" formula in a cell in each row, is that right? Is there a way to put a formula in one cell and it do all the work, there could be 800 rows? smiler44

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...