Search results

  1. S

    macro is rounding up and down

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

    Help required to create a formula

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

    get details of song being played

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

    macro to hide rows if column

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

    macro to paste many variables into a cell

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

    need a macro to find spaces in a string

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

    send text using Excel 2007

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

    add value of variable to value in text box

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

    why wont the use of a variable work

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

    list of file properties

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

    code/marco to shut down windows media player

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

    macro to shut down laptop

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

    How is return value generated

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

    Get list of files and sub folders

    I am after a macro that will list all the files and sub folders in folder x and then also list all the files and sub folders that are in the sub folders of x and so it goes on. This is where it becomes extra complicated. For each sub folder of X I want a new work sheet listing the files and...
  15. S

    formula for adding calaender days

    I want to add a number of days to a date and get the new calendar date but also account for bank holidays. cell A1 a date number of days to add bank holidays in cells A3:I3 something like this =WORKDAY.INTL(A1, 90, 7, A3:I3) but this is working days and takes into account the bank...
  16. S

    Help going from VB 5 to VB.Net

    I'm thinking of getting VB. Net and would like some advice please. I have a project written in Visual Basic version 5. Will VB.net be able to do the same things as VB5? what is the best way to convert a project written in VB version 5 to vb.net? I also have VB version 6 but have never used...
  17. S

    Break Excel 2003 password

    I have to add a macro to an xls workbook, I assume it is Excel 2003. The existing VBA code is password protected. Can you recommend something to break the password? I thought I had something to break the code, used it once a few years ago and now cant find it. Would prefer something not zipped...
  18. S

    get range and copy part of range

    I want to filter a spread sheet. There may be just one row plus the header of more rows plus the header. I want to copy column A and first visible cell after the header to column C and last used visible cell. so I filter and there are two entries, row 10 and row 99. I want to copy A10 to...
  19. S

    please can you explain this code?

    As per title, please can you explain this code? I found it on the internet and "although it does what I want" I do not understand how it works and cannot modify it. code [] Sub HighlightDupes() ' this works if column is filtered and only 'on visible rows Dim i As Long, dic As Variant, v...
  20. S

    copy an email and paste to another folder

    I have a macro that can move an email from one folder to another. This is fine but i need two other people to get a copy of the email. all 3 people have a folder off of the group email inbox. All emails go to inbox. they get checked and are moved to john or james or paul as required inbox...
Top Bottom