jpar
02-12-2014, 07:59 AM
Hello everyone,
any reason how it can be possible, that if I open my excel-file and run the macro, everything is fine. Then if I just open the Visual Basic Editor, close it again and try to run the macro, it fails to work.
It also fails to work if I open the file and have the VB editor already open.
The macro imports data from Urchin, can this effect? Also Im not the original creator of this file and there are private and public subs.
Any help would be greatly appreciated!
Jpar
E: additional info
any reason how it can be possible, that if I open my excel-file and run the macro, everything is fine. Then if I just open the Visual Basic Editor, close it again and try to run the macro, it fails to work.
It also fails to work if I open the file and have the VB editor already open.
The macro imports data from Urchin, can this effect? Also Im not the original creator of this file and there are private and public subs.
Any help would be greatly appreciated!
Jpar
E: additional info