'' save as" option to user

Question

3.00/5 (1 vote)

See more:

my application saves an array as as excel sheet in d drive:
the code is:

xlWorkSheet.SaveAs("D:\vbexcel.xlsx")

how can i give a "save as" option to user so that the user can save the file in any location.?

Posted 29-Jul-13 21:42pm

hlsc1983

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Fredrik Bornander · Accepted Answer · 2013-07-29T21:51:00

Solution 1

Use the SaveFileDialog:

VB

Private Sub myButton_Click(sender As Object, e As EventArgs)
        Dim myStream As Stream
        Dim saveFileDialog As New SaveFileDialog()

        saveFileDialog.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*"
        saveFileDialog.FilterIndex = 2
        saveFileDialog.RestoreDirectory = True

        If saveFileDialog.ShowDialog() = DialogResult.OK Then
            xlWorkSheet.SaveAs(saveFileDialog.Filename)
        End If
End Sub

Hope this helps,
Fredrik

Posted 29-Jul-13 21:51pm

Fredrik Bornander

Comments

Ankur^\m/ 30-Jul-13 4:17am

Correct, 5!

Fredrik Bornander 30-Jul-13 16:43pm

Thanks man!

hlsc1983 30-Jul-13 7:54am

can anyone explain the need for declaring myStream as Stream datatype. i commented that line and still the application works......please shed some light. thanks..

Fredrik Bornander 30-Jul-13 8:34am

No need, it's in there by mistake. You should not include it in your code.

hlsc1983 30-Jul-13 8:49am

thank you..

Fredrik Bornander 30-Jul-13 16:42pm

Sorry about that.