PC Review


Reply
Thread Tools Rate Thread

Close specific workbk

 
 
=?Utf-8?B?SnVuaW9yNzI4?=
Guest
Posts: n/a
 
      16th Apr 2007
Hi,

How do i call to close a specific workbook instead of the current active
workbk, because most of the books they taught is to close current active
workbk.
i tried workbk.close(filename), but it does not work.

thanks,
 
Reply With Quote
 
 
 
 
papou
Guest
Posts: n/a
 
      16th Apr 2007
Hi
To close and save specific workbook already open:
Workbooks("book1.xls").Close True

HTH
Cordially
Pascal

"Junior728" <(E-Mail Removed)> a écrit dans le message de
news: FF84DCDF-94D3-4179-BFC8-(E-Mail Removed)...
> Hi,
>
> How do i call to close a specific workbook instead of the current active
> workbk, because most of the books they taught is to close current active
> workbk.
> i tried workbk.close(filename), but it does not work.
>
> thanks,



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking a textbox to a cell in another workbk amelia Microsoft Excel Misc 4 5th Apr 2009 05:28 AM
Transferring of certain cells from one workbk to another amelia Microsoft Excel Programming 20 14th Feb 2009 09:10 AM
Linkk Workbk to data source Yossy Microsoft Excel Programming 0 31st Dec 2008 01:11 AM
How do I jump from the 1st worksht in a workbk 2 the very last =?Utf-8?B?c2hhdW5v?= Microsoft Excel Worksheet Functions 3 11th Oct 2006 09:43 AM
Open Workbk/Close Workbk Done Asynchronously? SidBord Microsoft Excel Programming 0 29th Apr 2004 06:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:35 PM.