opening the excel working file -> opens an additional one with empty contents - how get rid of 2nd ws

driller

New Member
Joined
Sep 19, 2017
Messages
3
at the beginning with an excel working file only 1 workbook (wb1)opened.

after filling wb1 with data from websites (webscraping) writing vba excel macros for analysis those data.
After an excel crash (guess bad scripting) suddenly a 2nd workbook (wb2) opens (which is empty) now on each time wb1 will be started.
I cant get rid of wb2.

My question is, how can I find where is the 2ns wb get started....thanks for suggestions. If more Information is required pls ask for. Thank you
 
Last edited by a moderator:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
...found additional behaviour while closing excel wb1.

procedures 1:
1. opening wb1:--> wb1 opens & wb2 opens
2. closing wb1: --> wb1 closed
3. closing wb2 (empty wb) : --> wb2 closed

procedure 2:
1. opening wb1:--> wb1 opens & wb2 opens (-->same behaviour)
2. closing wb1:--> wb1 closed & wb2 still open
3. opening wb1: --> wb1 opens and wb2 will be closed ( different behaviour)

procedure 3:
1. closing wb1: --> wb1 closed & wb2 is not open
'----------------------------
2. opening wb1: --> wb1 opening & wb2 opening
----------------------------
my questions:
-any idea how to get out of this loop?
- where to start to find this "link" --> guess - must be stored somewhere with command open file
( habe not writen or tried script to open file via FSO functions)

where is this "command" located that produces this behaviour ?
how can i erase this "link" ? in registry ??
 
Upvote 0

Forum statistics

Threads
1,223,714
Messages
6,174,052
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top