Search results

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

This is the situation. I have selected some songs to play via windows media player, they start playing. I want the songs to play for x number of minutes. so I start excel tell it how long to play for and run the macro. I cannot work out how to :- 1. get the duration of the song being...

not sure i understand the question :) count myself as an amateur that has hook or by crook created some very successful bits of automation. Google is my friend but even then I do find I need personal help and this is where I turn to a form smiler44

no worries thank you fr trying smiler44

I think I've just had a lightbilb moment. this is a modified macro I found on the internet BeginRow = 2 EndRow = 20 ChkCol = 3 For RowCnt = BeginRow To EndRow If Cells(RowCnt, ChkCol).Value <> "Brand House" And Cells(RowCnt, ChkCol).Value <> "Local Brand Family Group" Then...

thank you, either I did not understand what I was looking at or what I'm after was not there smiler44

I am in need of a macro to hide rows where column C does not contain and of these values, there will only be 1 value per cell. book, car, plane, boat, pencil, rubber, rule, pen. lots of macros to hide rows that do contain criteria but could not find one or get one to work where I had 7 items...

sussed it, still got to get it right but I have it all but cracked smiler44

my mind is blank. BH, CD, EF RC are all populated variables I want to paste the contents into a cell, something along the lines of activecell.value = BH & " " & CD & " " & EF & " " & RC but this gives be an object required error I've tried sheet1. at the beginning but this too is wrong I...