Search results

thank you Majp I'll try your code as its less then what I have just come up with which is not very pretty Sub macro5() 'find the location of the first 5 spaces Dim SearchString ' what to search Dim SearchChar ' charector to find Dim MyPos1 ' position of cahrector to find Dim mypos2 Dim...

Can you help please? I need a macro to find what is to the left of the first space, to the left of the second space etc of a string and the location of each space in a string, there are 4 spaces in the string. I have searched the internet but all I can find is formulas thank you smiler44

just found this that looks very interesting but would appreciate someone having a look at it and advising me if safe http://www.smsco.it/tomcat/en/sms_tutorials/sms_from_excel.jsp internet search last night made me think it was "easy" but to night makes me think... give up macafee2

these are a few of the links I looked at https://www.youtube.com/watch?v=k1P6dkIZFeg https://www.youtube.com/watch?v=fHGwfIiZCWI https://www.cm.com/blog/how-to-sending-personalised-sms-messages-using-excel/ https://appsource.microsoft.com/en-us/product/office/WA104380647?tab=Overview Be...

a look on the internet suggests I can send a text message using Excel 2007. The option is via an Add In. I don't have an Add In tab. I have clicked the round office button, clicked Excel options, clicked Add In's but am lost on what to do now, if I need to select an add in, I cant see one for...

oh ya. cheers smiler44

Gasman, can you tell me more about this? "There are actually buttons on the ribbon to do blocks of code." smiler44

Gasman, thank you. I thought my problem was to do with time but I was was off beam. I'm a bit wiser now As for indenting, I struggle with it, always have. the Set fs = CreateObject("scripting.filesystemobject") is someone elses code and so I would not know what to do with it. I'm lost on how...

what I have been trying to do is play random songs for a set length of time then shut down windows media player, excel and my laptop. with help from here, the internet and past projects I have a macro that works, perhaps not bug free but working. if I input 90, macro stops at anything over 1...

sorry i dont know. b is a variable but perhaps incorrectly i have just gone dim b and not declared it as string or integer, this could be the problem, what do you think? smiler44

I don't think it is smiler44

not using formula but a macro but text2.value = text2.value + b is not right because if textbox2 contains 3 and b= 5 this code gives 35 instead of 8. next time it runs it gives 355. I am lost on how to add the values of two text boxes together and am lost on how to add 2 times together. both I...

i currently am using cells A1, A2 and A3, at worst i only want to use A1 just to put the run time of the current song into. A1 run time of current song A2 = text2 value which is run time of songs played so far A3 = A1 + A2 text2.value = A3 value i want something along the lines of b= runtime...

for now I've come up with the same method as isladogs. I then populate my tet box from the cell value, this works but I'm not happy with it. I was hoping to populate the variable and then simply go textbox2.value = textbox2.value + variable but I cant get this to work. 1, cant get the add...

I want to add the run time of a song from a variable to the time already in a text box and then have the text box display the new time. The format is 00:00:00 when the next song is played I want to add this time to the time in the text box as well and show the new time and so on and so on...

thanks Majp, once I get the code to work I will try to tidy it up. I am almost there, just one problem that I thought was easy has me beaten. I'll try a bit longer to solve it, if I am still beaten I will create a new thread, please keep your eyes peeled :) thanks again smiler44

sorry for wasting your time, I found it at least I think I have. I will if I may put it down to dyslexia, otherwise, it is down to my stupidity. I have been running the code and running the code and finally I think the penny has dropped. In Public Sub RecursiveDir(ByVal currdir As String)...

It is very hard to read. Can you go back and use the # tag at the top of the edit window. Select the code and then hit #. It all runs together. sorry Majp, I don't understand smiler44

majp, thank you for the quick reply. Sorry, the code is from different modules hence some of the declarations appear in the middle of nowhere. All but one of the dims's you refer to are from code taken from the net and I have left them where they were. I'm a total ammeter. Even though it is...

I found some code on the internet and have chopped and changed it around but for the life of me I cannot understand why the use of a variable will not work. The code randomly selects an mp3 file and goes on to play it. The variable is to get the running time of the mp3 file. if I don't use a...