Results 1 to 4 of 4

Thread: [Resolved] Excel VBA and SaveAs dialog box

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Oct 2000
    Location
    Scotland
    Posts
    96

    Angry [Resolved] Excel VBA and SaveAs dialog box

    Hi,

    I want to save some spreadsheets as part of a macro but I want to let the user choose where to store them - in other words I want to use the SaveAs dialog box.

    I know how to do this in VB but I can't get it to work in Excel/VBA.

    Does anyone have any ideas??

    Thanks

    H.
    Last edited by Hollie; Jun 20th, 2002 at 06:08 AM.
    Just trying to muddle through...

Posting Permissions

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



Click Here to Expand Forum to Full Width