Recent content by Roxalia

Thank you Mike, It works like a charm and I'm going to spend this swedish night learning some new things. You enlightened my VBA world. Best regards, Roger A humble servant to the global VBA community

Hi Mike, I sorted out the FIND question. I just added: Dim datum As Date ... datum = Format(i, "yyyy-mm-dd") ... and changed: Columns("A:A").Find(What:=Date - 1, LookIn:=xlValues).Activate to Columns("A:A").Find(datum, LookIn:=xlValues).Activate Now the program loops until the last date...

Thanx, For the recommendations. The cycling works but when it comes to paste in the information in the file at the right position I don't know how to transform it. For example: The original code: Columns("A:A").Find(What:=Date -1, LookIn:=xlValues).Activate The Find(What:=DATE... should be...

Hi, I've done my first programming in VBA in Excel and it worked. The program copies a datefile everyday into a masterfile. Now, because I'm lazy I thought I could use the code and transform it a little for the previous years. Instead of using the today command. I would the user to select a...

After a good deal of research on the Internet. I did it like this. Little of the code is with help from the macro-recorder. I suppose the code could be more sophisticated. Thanx, Roger Sub Kopiera() 'Skrivet av Roger Håkanson ' ' Join today´s date with ".xls" ' Format the filnamn to match...

I understand that I can convert the cell with the custom category. But I'm going to put this string in a small program and compare it to a file name looking like this 060103.xls. Would it work anyway or would excel use the hidden 38720?

Hi, I would like to convert a date cell with the syntax YYYY-MM-DD to a text cell reading just "YYMMDD" and not the counter number 38720. Anyone have a good clue for a swedish novice... Roger

Hi, A question from a swedish novice.. I have a program that deliever a excel-file everyday. They are called 051227, 051228.xls etc. I have another workbook where I want the information to be added. If I have a cell with =now() or =today() and want to use this information and pare it...