Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File SaveAs without VBA (XP)

    Is it possible to save a file via VBA without including the code in the modules?

    Regards,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: File SaveAs without VBA (XP)

    Please explain what you want to accomplish.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File SaveAs without VBA (XP)

    Hans,

    I have a workbook with multiple sheets and I would like to save a copy without the VBA code in the file which will be distributed.

    Regards,
    John

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File SaveAs without VBA (XP)

    Hi John

    I think you may delete / export all codes modules in your VBA Project before you save the workbook or
    you can copy all sheets to a new workbook and save the it.

    regards, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: File SaveAs without VBA (XP)

    See the section "Deleting All VBA Code In A Project" in Chip Pearson's Programming In The VBA Editor.

Posting Permissions

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