ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i open a data workbook when i open a timesheet workbook (https://www.excelbanter.com/excel-discussion-misc-queries/215276-how-do-i-open-data-workbook-when-i-open-timesheet-workbook.html)

[email protected] uk

how do i open a data workbook when i open a timesheet workbook
 
how do i open a data workbook when i open a timesheet workbook

Mike H

how do i open a data workbook when i open a timesheet workbook
 
Hi,

use the workbook open event of you timesheet workbook to open the data
workbook

Private Sub Workbook_Open()
Workbooks.Open ("C:\MyDataBook.xls")
End Sub

Mike

uk" wrote:

how do i open a data workbook when i open a timesheet workbook


[email protected] uk

how do i open a data workbook when i open a timesheet workboo
 
hello mike
i have tried the path that you said & i can't get to work

"Mike H" wrote:

Hi,

use the workbook open event of you timesheet workbook to open the data
workbook

Private Sub Workbook_Open()
Workbooks.Open ("C:\MyDataBook.xls")
End Sub

Mike

uk" wrote:

how do i open a data workbook when i open a timesheet workbook



All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com