Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am using this for importing some sheets from a workbook. After importing the file must be closed. Sub importerendb() Range("rekenvel!E2").Value = Range("rekenvel!b13").Value & "\" & importeren.databasescombo.Value & ".xls" Dim bestandsnaam bestandsnaam = Range("rekenvel!E2").Value Workbooks.Open Filename:=bestandsnaam, Password:="XYZ" For Each n In ActiveWorkbook.Names n.Delete Next Sheets(Array("lijstkerken", "database")).Move Befo=Workbooks( _ "myfile.xls").Sheets(1) Workbooks(bestandsnaam).Close savechanges:=False Unload importeren End Sub It goes wrong in the line "Workbooks(bestandsnaam).Close savechanges:=False" What am I doing wrong? Thanks for help, Gert-Jan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to skip the save file notoification on file closing? | Excel Worksheet Functions | |||
Open external data (varying file names) and closing file once data is retrieved | Excel Programming | |||
Closing a db file getting errors | Excel Programming | |||
VBA Closing File | Excel Programming | |||
VBA closing one file | Excel Programming |