Posted to microsoft.public.excel.programming

Gert-Jan[_3_] Gert-Jan[_3_] is offline

external usenet poster

Posts: 11

Closing a workbook

Hi,

Can anyone help to make this work:

Sub CopyAndClose()
Dim filex
filex = Range("Sheets2!F2").Value
Workbooks.Open Filename:=filex, Password:="123"
Sheets("database").Select
Sheets("database").Copy Befo=Workbooks("test.xls"). _
Sheets(1)
Workbooks.Close Filename:=filex
End Sub

The error is in the last row.

Thanks, Gert-Jan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Closing a workbook	N1KO	Excel Discussion (Misc queries)	0	February 12th 09 03:51 PM
closing a workbook	oercim	Excel Programming	0	March 24th 06 01:27 PM
Closing Hidden Workbook when Active Workbook is Closed	SusanK521	Excel Programming	5	September 24th 05 12:27 AM
Help with closing down a workbook??	Don	Excel Worksheet Functions	1	May 9th 05 04:05 AM
closing excel after closing a workbook	CWalsh[_2_]	Excel Programming	3	January 21st 04 03:33 PM

All times are GMT +1. The time now is 11:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us