evilaid
10-23-2011, 02:40 AM
I've got such a annoying problem and i no longer know what to do..
I've got two workbooks.
From the first one i make a call for a macro in the second workbook. What the macro in the second workbook does is only that it makes a printout of a sheet (in the same book)..
This works fine when i open the the second workbook and interactivitley start the printout macro, but nothin happens when calling macro from the other workbook.
I tested and the macro executes correctly but printout never happens, i also made an error handler and it gives no errors.
I noticed the same problem if i in the printout macro try to create and save a new excelfile...
So...
When calling macros in another workbook macros run correctly but printout and filecreation never seems to happen?
Much appreciate any help or suggestions
Best regards
I've got two workbooks.
From the first one i make a call for a macro in the second workbook. What the macro in the second workbook does is only that it makes a printout of a sheet (in the same book)..
This works fine when i open the the second workbook and interactivitley start the printout macro, but nothin happens when calling macro from the other workbook.
I tested and the macro executes correctly but printout never happens, i also made an error handler and it gives no errors.
I noticed the same problem if i in the printout macro try to create and save a new excelfile...
So...
When calling macros in another workbook macros run correctly but printout and filecreation never seems to happen?
Much appreciate any help or suggestions
Best regards