Clicky

Hi,

I want to save an excel in VBA and i want that the system ask me to select the directory and fill in the excel-name.

Tx

asked 12/14/2011 07:26

sonmic's gravatar image

sonmic ♦♦


2 Answers:
Hi,

If I understand your needs correctly, the Visual Basic for Applications [VBA] code statement you will need in your Microsoft Excel workbook file to show the "Save As" dialog box (allowing you to select a folder & filename) is:


Application.Dialogs(xlDialogSaveAs).Show


BFN,

fp.
link

answered

fanpages's gravatar image

fanpages

Hi, sonmic.

Has fp called it correctly or are you just looking to select the folder? So the save would use that plus an already specified filename?

Regards,
Brian.
link

answered 2011-12-15 at 04:30:01

redmondb's gravatar image

redmondb

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×1

Asked: 12/14/2011 07:26

Seen: 308 times

Last updated: 12/17/2011 05:46