Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have the following macro which is supposed to add a new sheet, open up the
designated file, copy the first 3 lines, go back to the original spreadsheet and paste the copied 3 lines. However, it seems to be stopping at the Selection.Paste line because it can't determine which spreadsheet to go to. How do I fix this? At any time I run this I could be in a diffferent spreadsheet creating jnls. Thanks in advance Rick Sub newupload() ' ' newupload Macro ' ' Sheets("Sheet1").Select Sheets.Add Workbooks.Open Filename:="I:\Jnl upload.xls" Rows("1:3").Select Selection.Copy ActiveSheet.Activate Selection.Paste Windows("Jnl upload.xls").Activate ActiveWindow.Close End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions |