I'm trying to put a macro together that after opening a log file, automatically copies the results to first empty cell in another excel file.
The log files are always named "test xxx", with xxx a specific number. The file were the data needs to be copied to is named "2013-0xxx". From this log file I want to copy cell A75 and cell D75, respectively to the first empty cell in column A and E.
For example, there is a log file named "test 621". From this file I want to copy cell A75 and D75 to the first empty cell in column A and E of a file named "2013-0621".
The first problem is to open the correct file. I can open a file named "621", but not "2013-0621". Secondly, I get an error in my code to copy and paste in the first empty cell. Hope someone can help.
Please Login or Register to view this content.