H
HammerJoe
Hi,
I have a macro in my main workbook that creates a new workbook and it
copies from main workbook a report sheet and pastes only formats and
values to it so it can be emailed.
Because people can send it as an attachment, I decided to create a new
workbook with just one sheet. It makes the file smaller and at the
same time it removes the formulas from prying eyes.
The problem is I can't use the sendmail function, because it requires
saving the new workbook to the disk (as far as I know) and because of
profile space limitations this is not workable for me).
The other problem, when the workbook is created a button is created to
allow the user to close the workbook and return to the main workbook.
That works fine except when the email recipient opens the file.
there is a prompt about broken links (which is obviously because of
the button).
I understand that it is not possible to avoid that prompt with excel
2003
So I decided to get rid of the button and just wait for the new
workbook to be closed before returning to the main workbook and
continuing with the macro
Another problem then, excel of course prompts to save the new
workbook.
Can I eliminate the Broken/Update link prompt when opening the
workbook?
OR
How can I close the workbook without prompt??
(i am not sre if I can inject code from a macro into the new workbook
to detect close event??)
I have a macro in my main workbook that creates a new workbook and it
copies from main workbook a report sheet and pastes only formats and
values to it so it can be emailed.
Because people can send it as an attachment, I decided to create a new
workbook with just one sheet. It makes the file smaller and at the
same time it removes the formulas from prying eyes.
The problem is I can't use the sendmail function, because it requires
saving the new workbook to the disk (as far as I know) and because of
profile space limitations this is not workable for me).
The other problem, when the workbook is created a button is created to
allow the user to close the workbook and return to the main workbook.
That works fine except when the email recipient opens the file.
there is a prompt about broken links (which is obviously because of
the button).
I understand that it is not possible to avoid that prompt with excel
2003
So I decided to get rid of the button and just wait for the new
workbook to be closed before returning to the main workbook and
continuing with the macro
Another problem then, excel of course prompts to save the new
workbook.
Can I eliminate the Broken/Update link prompt when opening the
workbook?
OR
How can I close the workbook without prompt??
(i am not sre if I can inject code from a macro into the new workbook
to detect close event??)