Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
putting info from one file into another using vba
I am using vba in spreadsheet1 to open and count data from an excel
spreadsheet located online (spreadsheet2). Once that data is counted in spreadsheet2, I want that value to be printed in spreadsheet1 where the macro was initially run from. I have the following code so far, but it will (obviously) print the data in spreadsheet2 rather than spreadsheet1: Sub openn() Dim Countt As Long Workbooks.Open Filename:="sample filename.xls" Countt = CountColor(Range("D4:GE4"), 45, False) + CountColor(Range("D4:GE4"), 10, False) + CountColor(Range("d4:GE4"), 8, False) Range("k53").Value = Countt End Sub How do I get it to put that value in spreadsheet1? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help taking columns of info and putting them into another fil | Excel Discussion (Misc queries) | |||
Pulling info 2 cells and putting it in one | Excel Worksheet Functions | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Putting Data & Time in file name | Excel Programming | |||
putting file name within spreadsheet | Excel Discussion (Misc queries) |