I have a workbook and I use as my ever changing database; named "input". With using the following code I'm able to open the workbook.What I want to do is have sheet1 in the input workbook be copied to the current workbook.VB:Workbooks.Open Filename:="Users:machy:desktop:input.xltx"
I want to do this to allow for continually changing database have updated values in the current workbook.
Try something like this
VB:Windows("Users:machy:desktop:input.xltx").Activate 'your workbook to get the sheet from Sheets("Sheet1").Select ' the sheet you want Sheets("Sheet1").Copy Before:=Workbooks("Input.xls").Sheets(1) 'the workbook you want the sheet in
Last edited by Dave Hawley; April 28th, 2012 at 14:56.
There are currently 1 users browsing this thread. (0 members and 1 guests)