Check If workbook not open then open workbook and run code

**HaroonSid** · 02-22-2017, 07:21 AM

hi,
i have below code to copy paste data to once workbook to second workbook

Please Login or Register  to view this content.

if workbook "Vouchers - Purchase Transactions With StockItems.xlsm" not open then its giving debug error
so
i want if workbook not open then firstly open workbook and then copy paste data

thanx

**HaroonSid** · 02-22-2017, 08:25 AM

Found an answer

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**HaroonSid** · 02-22-2017, 08:26 AM

Post Here For Others

thanx Google and Excel Forum

Check If workbook not open then open workbook and run code

LinkBack

Thread Tools

Rate This Thread

Display

Check If workbook not open then open workbook and run code

Re: Check If workbook not open then open workbook and run code

Re: Check If workbook not open then open workbook and run code

Thread Information

Users Browsing this Thread

Similar Threads

Code to check if Workbook is currently open...

Macro to open a closed workbook and select copy cells into an open workbook

Code to open a workbook, do what i want, close it, and open the next

Save an open workbook, then open template workbook and close the saved workbook

Code to open a workbook , copy info and return it to another workbook using a cell v.

Code check to see if workbook open

Need VB code for workbook open to open a link

Bookmarks

Bookmarks

Posting Permissions