Recent content by smiler44

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