Results 1 to 2 of 2

Thread: Any easy way to save an excel worksheet as a workbook in VB?

  1. Jun 18th, 2003, 06:52 AM #1
    Cole Patzman
    Cole Patzman is offline

    Thread Starter
    Lively Member
    Join Date
    Dec 2001
    Location
    Melbourne, Florida
    Posts
    65

    Any easy way to save an excel worksheet as a workbook in VB?

    I have a workbook with several worksheets. After populating the worksheets, I would like to save the worksheets as workbooks. Any one have a clue on how that can be done easily?
    Reply With Quote Reply With Quote
  2. Jun 20th, 2003, 06:12 AM #2
    JordanChris
    JordanChris is offline
    Frenzied Member
    Join Date
    Jan 2001
    Location
    Newbury, UK
    Posts
    1,878
    In Excel macro programming there is a command .SaveCopyAs. This might do what you want....
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width