Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

2014-11-12 Thread Bud Windelborn
the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Bud Windelborn > > *To:* excel-.

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

2014-11-12 Thread Bud Windelborn
Thanks! I'm not sure I understand yet though. When I run this macro, I've already got the sheet BusinessOrganizerMapping2013.xlsm open. I hit the button to run the macro and another sheet opens based on the sheet name that's in cell A7 of BusinessOrganizerMapping2013.xlsm. I can manage the c

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

2014-11-11 Thread Bud Windelborn
).sheets("Temp").Range("A1:I100" > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all th

$$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

2014-11-11 Thread Bud Windelborn
This is driving me nuts. What am I doing wrong? I'm need to open a new workbook and the name of that new workbook is contained in a cell. All I need to do is copy the data, close the new workbook, retain the data in the clipboard, then paste the data into my original workbook. Here's where I