Hi,
Is it possible to save a single sheet from a workbook as a separate file?
Cheers,
Lotte
Hi,
Is it possible to save a single sheet from a workbook as a separate file?
Cheers,
Lotte
Please Login or Register to view this content.
Last edited by shg; 12-13-2007 at 12:48 AM.
Now that's what I call quick! Thank you
Lotte
... and a follow-up question (or two).
Is it possible to refer to the user desktop using this command?
i.e.
would work for the default user only, and the XP system I (and other staff at my workplace) use do not have an "All users" folder...Please Login or Register to view this content.
Finally, is it possible to attach the input the file to a new email in the default email editor (typically MS Outlook)
Cheers,
Lotte
Hi Lotte,
You should be able to get the currently logged in user's profile path by adding the following code to your macro:
So in your code, you might try:Please Login or Register to view this content.
As for e-mailing workbooks/sheets, have a look at: http://www.rondebruin.nl/sendmail.htmPlease Login or Register to view this content.
Hi pjoaquin,
Thank you very much! That works.
Lotte
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks