Results 1 to 4 of 4

Saving subset of Worksheets

Threaded View

rtiltins Saving subset of Worksheets 11-04-2008, 12:58 PM
shg Why not just copy the sheets... 11-04-2008, 02:38 PM
rtiltins This way (saving copy of... 11-04-2008, 03:15 PM
shg That's the definitive... 11-04-2008, 04:25 PM
  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    Canada
    Posts
    8

    Saving subset of Worksheets

    Hi all,
    I am trying to e-mail a portion of a spreadsheet that I have. My approach is the following: I save a copy in a temporary folder, open that copy, remove all the sheets that I don't need to send out, save it (same name as the e-mail subject), and then e-mail as an attachment. The current approach does not remove the macros and references though. I use the following to remove the macros and references:

    Set vbCom = Application.VBE.VBProjects(EmailSubject).VBComponents
    vbCom.Remove VBComponent:=vbCom.Item("AddIn_Manager")
        
    Set vbRef = Application.VBE.VBProjects(EmailSubject).References
    vbRef.Remove Reference:=vbRef.Item(1)
    Any thoughts on this? or perhaps suggestions for another method?
    Last edited by rtiltins; 11-04-2008 at 03:16 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1