Search results for query: *

Thanks a lot guys for the replies... I used Rob's code as it was the first in the list and it is working excellently. Think I've finished the project now.. just got to write it all up :S Thanks again guys Tom

Thanks for the speedy reply.. That is similar to what I had in the first place but it is not saving it to the same directory as the workbook. I.e. it is saving it to c:/ only and not the same directory. If it was just for my own use.. then I would just put in a standard folder name.. but I am...

Hi again, With the help of RobBroekhuis I fixed my last problem concerning the user form. Another problem I am having is that i have created a part of the worksheet which opens a new sheet, copies some data accross and saves it as "report1202" for example (i.e. report then mmyy)...

Hey, Thanks for the reply again, that one worked.. Well done and thanks again. Tom

Thanks for the reply. The first bit is great but the second isn't working, even with me trying to tinker with it a bit. It needs to select the sheet "suppliers" find the selection we have just made in the combo box, and find the number which is in the cell two columns to the left of...

Hi all, I have made an excel workbook which has worked quite successfully so far (with a few usual hiccups of course!) but have come across a problem. I know the basics of VBA and the use of user forms (applying buttons to a user form to make a box to ask if you want to continue etc.) The...