Search results

I have windows 11 and office 2024 and set things up to use outlook classic. I have been to a web site and clicked the companies email address on the contact us page. A box is displayed with a number of options and one option is Outlook New. There is an option to click Browse apps in Microsoft...

I am unable to add a text box as an active x control into an excel2024 spread sheet, I have the developer tab showing but when i try i get cannot insert object. what am i doing wrong? smiler44

I could be back with lots of questions having gone from Excel 2007 to Excel 2024 Excel 2007 vba code, sheet1.textbox1.value = "1:30:00" Excel 2024 does not like .textbox1 What should it be? thank you in advance smiler44

I have a macro created on execl 2007 and have moved the workbook to another laptop running excel 2024 If I use the F8 key to step through the code it takes me to the desk top screen and locks the laptop. How do I make the F8 key step through the code or is there a different button to use...

I could be back with lots of questions having gone from Excel 2007 to Excel 2024 Excel 2007 vba code, sheet1.textbox1.value = "1:30:00" Excel 2024 does not like .textbox1 What should it be? thank you in advance smiler44

I am a novice I created a folder in windows 11, the path shows as c/users/sagent/documents/music but when I click the documents folder it is not there. Opening the documents file explorer I can see the folder below a folder marked Microsoft office. There does not seem to be any option, right...

I have an LG GSA-2164D usb DVD/CD re-writer but it does not show in the File Explorer list of Windows 11. It does show if I go to Device Manager and then click DVD/CD-Rom Drives. How do I get it to show in the File Explorer list ? Should it show in the File Explorer list? Thank you in advance...

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

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

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

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

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

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

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

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

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

this is part of some code I found on the internet for getting the properties of a file, I just want the duration of an mp4 file. Do the numbers represent what property of the file, the code is to retrieve? It may seem obvious but the code is beyond me and so bit by bit I am trying to decipher...

I have searched the net but not found anything that works. I am in need of code or a macro to shut down windows media player. windows version is windows 7 thank you in advance smiler44

I have tried various macros from the internet but none have worked. can you help with vba code to shut down a windows 7 laptop and a 8 laptop? thank you in advance smiler44

I found this code on the internet. It checks that URL's are still valid. Saves me clicking each one of my favourites to see they are still valid. Public PageSource As String Public httpRequest As Object Dim HL As Hyperlink Sub ValidateURLs() Dim Cell As String 'Range Dim Rng As...