open as read only

N

Newbie80

Im opening a different workbook and Im copying a sheet from it. Thought
I opened it as readonly, but sometimes it still asks if I want to save
the changes.

Set sourceWb = Workbooks.Open(filepath, True, False)
........
..............
(can I write something like sourceWb.Don'tSave or something)

sourceWb.Close
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering out duplicate data values 2
Setting Variables 5
Second workbook not closing as expected 2
use a txt.value on a form to search a sheet 2
Select all data in column and list in form combo box 5
List Index filtering 1
excel VBA - Userform cmd problem 3
Copy sheets to New Workbook - Excel 2007 1

Top