Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Values to another Workbook
I want to use a macro so that evertime i run an analysis tool in a workbook,
I can copy the data into another file. So my questions are 1) Can I accomplish this without opening the other (index) file. The only method I know right now is to do something like Windows("Index.xls).Activate ,etc. Is there some way I can automactially open the file? 2)The data added would be appended at the last row of the index file. How should I accomlish this? I think I would need a FOR loop and a cell<"" check, but how would specify that the macro only looks down one column? i.e. I would want it to look down column A and skip row 1-10 and then check against each cell value to see if there's any value that exists in the cell. 3) How do I copy absolute values. ActiveCell = "=[Filename.xls]Main!R3C3" would give me a link, but I just need the absolute values. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for copying values from one workbook to another | Excel Worksheet Functions | |||
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
copying values only from another workbook | Excel Programming | |||
Copying values from one Workbook to Another | Excel Programming | |||
copying values form one workbook to other | Excel Programming |