Open files from List

[Jack]

I'm trying to open a group of files from a list starting at D5 on the Menu
worksheet.
Following is the code i have tried.

sub open_files()
dim fname
With ActiveWorkbook
fname = "c:\documents\" & .worksheets("Menu").range("D5").value & ".xls"
Workbooks.Open Filename:= fname
End With
End Sub

the macro stops at the workbooks.open step - help would be appreciated

 

[jasontferrell]

This looks ok to me...what error are you getting? Do you have a
workbook with the right filename in the c:\documents directory?

 

[Jack]

yes - the file is there - the error message i get is file can't be found

 

[jasontferrell]

Change you code to add a msgbox that will display while running. Then
check the filename. You could've duplicated the "xls".

sub open_files()
dim fname
With ActiveWorkbook
fname = "c:\documents\" & .worksheets("Menu").range("D5").value &
".xls"
msgbox fname
Workbooks.Open Filename:= fname
End With
End Sub

 

[Dave Peterson]

If the workbook is opening, then the macro stops, change the shortcut key that
you use to run the macro. Do not include the shift key.

If the code stops before the workbook is opened, then what's the error? Maybe
you don't have a workbook with that name????

 

[Jack]

Thanks

the file was a 2007 file - when i save it as a 2003 the macro worked.
thanks for your help

 

[Jack]

Dave

thanks - i had the file as an excel 2007 once i changed it to 2003 this
worked.

 

[Jack]

What code do i need to add so that i don;t show the files as they are opening?

 

[jasontferrell]

You can add:
Application.ScreenUpdating=False
at the beginning and then set it to true at the end.

 

[Jack]

Thanks for all your help