ExcelBanter - create a macro to automatically open excel another excel file

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - create a macro to automatically open excel another excel file (https://www.excelbanter.com/excel-discussion-misc-queries/195584-create-macro-automatically-open-excel-another-excel-file.html)

[email protected] uk

create a macro to automatically open excel another excel file

Gord Dibben

create a macro to automatically open excel another excel file

Private Sub Workbook_Open()
Workbooks.Open Filename:= _
"C:\Program Files\Microsoft Office\Exceldata\12months.xls"
End Sub

Gord Dibben MS Excel MVP

On Sun, 20 Jul 2008 13:09:01 -0700, uk
wrote:

All times are GMT +1. The time now is 08:14 AM.