Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Inserting a worksheet from another workbook the links remain.
I would like to inset a worksheet and bring accross the values rather than the formulas. This is the macro: Sub Balance_Sheet_Data() Application.ScreenUpdating = False Workbooks.Open Filename:="G:\Balance Sheet 2004.xls" Cells.Select Selection.Copy Windows("DATA SOURCE - GOLF # 3-01.xls").Activate Sheets("Balance Sheet Recon Data").Select Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False Windows("Balance Sheet 2004.xls").Activate ActiveWorkbook.Close Sheets("Command Page").Select Range("A1").Select Application.ScreenUpdating = True End Subs What visual basic command do I change? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Are there any NON-Visual Basic solutions for inserting a picture based a derived or called filename? | Excel Worksheet Functions | |||
Worksheet naming using visual basic | Excel Worksheet Functions | |||
visual basic command identify a worksheet in a workbook | Excel Programming | |||
inserting subtotal() function in spreadsheet via Visual Basic/macro | Excel Programming | |||
Saving Workbook in Visual Basic Hides the Worksheet, Why | Excel Programming |