Search results for query: *

I'm trying to make a spreadsheet so that everytime I add a new row, the background is a different colour. I want two colours that alternate as you go down the rows so that it is easier to read. Is there a way to do this automatically when I type in text? I have the following code, which...

I am trying to open a word file from a command button in excel. I've been trying to use: filenam = "\filename.doc" loc = activeworkbook.path helpfil = loc & filenam RetVal = Shell("C:\Program files\Microsoft Office\Winword.exe " & helpfil, vb normal focus) However, this does not work. It...

I am looking to have a command button which, when pressed, opens another excel file. This is simple enough, but I can't work out how to make this work when the file location is different. I.e. I want to be able to email these files to other users and for the code to still work. Is there a way...

I am trying to make a query which involves having the option of typing in numerous parameters (sort of like a search function), but I can't work out how to stop it from bringing back only empty fields if I don't type in a value for one of the parameters. For example, one of the parameters is ID...