|
How do I change a macro to call a sheet from another workbook
Hi
This is proberably v easy, however I can't figure it I use a VBA macro to call up some infor and part of it is Worksheets("Gate A").Rows("10:3000").EntireRow.Hidden = False Worksheets("Question Database [Q]").Range("con_control").Copy With Worksheets("Question Database [Q]") "Gate A" & "Question Database" Are now held in a workbook calle 'Database' How do I amend the Macro to look at the sheet in the workbook rathe than the workbook it is in now??? Thankyou in advance Ni -- Message posted from http://www.ExcelForum.com |
How do I change a macro to call a sheet from another workbook
As long as Database workbook is already open.
Workbooks("Database").Worksheets("Gate A").R .... etc.. If it's not already openthen you could use this: Workbooks.Open ("C:\Database.xls") -- Rob van Gelder - http://www.vangelder.co.nz/excel "Nic@Rolls-Royce " wrote in message ... Hi This is proberably v easy, however I can't figure it I use a VBA macro to call up some infor and part of it is Worksheets("Gate A").Rows("10:3000").EntireRow.Hidden = False Worksheets("Question Database [Q]").Range("con_control").Copy With Worksheets("Question Database [Q]") "Gate A" & "Question Database" Are now held in a workbook called 'Database' How do I amend the Macro to look at the sheet in the workbook rather than the workbook it is in now??? Thankyou in advance Nic --- Message posted from http://www.ExcelForum.com/ |
How do I change a macro to call a sheet from another workbook
|
| All times are GMT +1. The time now is 06:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com