Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working within a workbook without activating it?
This code is extremely ineffecient. It has to activate each workbook t do every step. Is there a way to work within a file without activatin it? Windows("Package Tracking.xls").Activate Call Sheets(1).Select(True) r = 2 Do i = 2 Do Until IsEmpty(Cells(i, 1)) Range(Cells(i, 1), Cells(i, 15)).Select Selection.Copy Windows("Master.xls").Activate Cells(r, 1).Select ActiveSheet.Paste Link:=True Cells(r + 1, 1).Select Windows("Package Tracking.xls").Activate i = i + 1 r = r + 1 Loop ActiveSheet.Next.Select On Error GoTo Format Loo -- hyyft ----------------------------------------------------------------------- hyyfte's Profile: http://www.excelforum.com/member.php...fo&userid=1318 View this thread: http://www.excelforum.com/showthread.php?threadid=26156 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working within a workbook without activating it?
hyyfte,
You seem to be looping through and making links row by row. It would be much more efficient to change Range(Cells(i, 1), Cells(i, 15)).Select Selection.Copy to Range(Cells(i, 1), Cells(Cells(65536,1).End(xlUp).Row, 15)).Copy (NB. This will only work if you don't have any filled in cells below your block of cells in column A) Then get rid of the "Do Until IsEmpty(Cells(i, 1))" loop. HTH, Bernie MS Excel MVP "hyyfte" wrote in message ... This code is extremely ineffecient. It has to activate each workbook to do every step. Is there a way to work within a file without activating it? Windows("Package Tracking.xls").Activate Call Sheets(1).Select(True) r = 2 Do i = 2 Do Until IsEmpty(Cells(i, 1)) Range(Cells(i, 1), Cells(i, 15)).Select Selection.Copy Windows("Master.xls").Activate Cells(r, 1).Select ActiveSheet.Paste Link:=True Cells(r + 1, 1).Select Windows("Package Tracking.xls").Activate i = i + 1 r = r + 1 Loop ActiveSheet.Next.Select On Error GoTo Format Loop -- hyyfte ------------------------------------------------------------------------ hyyfte's Profile: http://www.excelforum.com/member.php...o&userid=13187 View this thread: http://www.excelforum.com/showthread...hreadid=261569 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening or activating another workbook file | Excel Programming | |||
Open workbook without activating it | Excel Programming | |||
Activating workbook with variable Name | Excel Programming | |||
Activating a workbook help | Excel Programming |