Save as macro

[[email protected]]

I am trying to make a macro which opens the Save As-box. Can anyone
help me?

I know this has been asked before, but on most occations people want
the filename to be based on the input in the worksheet. I just want the
Save As-box to appear, and the user to enter the filename (and choose
the path).

[Bob Phillips]

Look at GetSaveAsFilename in VBA help.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

<[email protected]> wrote in message
news:[email protected]...
> I am trying to make a macro which opens the Save As-box. Can anyone
> help me?
>
> I know this has been asked before, but on most occations people want
> the filename to be based on the input in the worksheet. I just want the
> Save As-box to appear, and the user to enter the filename (and choose
> the path).
>

[impslayer]

[email protected] skrev:

> I am trying to make a macro which opens the Save As-box. Can anyone
> help me?
>
> I know this has been asked before, but on most occations people want
> the filename to be based on the input in the worksheet. I just want the
> Save As-box to appear, and the user to enter the filename (and choose
> the path).

Sounds like the very recent 'Breaking a UserForm' thread, have you read
it?

GetSaveAsFilename might be what you need, or did I misunderstand your
requirements?

/impslayer, aka Birger Johansson

[[email protected]]

And where do I find VBA help (would probably help me with many
questions:-) ? When I press the questionmark in my Visual basic window,
and search for GetSaveAsFilename in Index, I get no match (only
GetObject function and GetSetting function).

[JK]

[email protected] wrote:
> And where do I find VBA help (would probably help me with many
> questions:-) ? When I press the questionmark in my Visual basic window,
> and search for GetSaveAsFilename in Index, I get no match (only
> GetObject function and GetSetting function).

put this line to your code:

Application.GetSaveAsFilename

It will open the Save As -prompt

[Bob Phillips]

Type GetSaveAsFilename in the immediate window, select it, then press F1.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JK" <[email protected]> wrote in message
news:[email protected]...
> [email protected] wrote:
> > And where do I find VBA help (would probably help me with many
> > questions:-) ? When I press the questionmark in my Visual basic window,
> > and search for GetSaveAsFilename in Index, I get no match (only
> > GetObject function and GetSetting function).
>
> put this line to your code:
>
> Application.GetSaveAsFilename
>
> It will open the Save As -prompt
>

[[email protected]]

Thanks. And how do I get the SaveAs-box to filter only excel-files (and
give the file .xls-ending)?

[JK]

Ok, put this to the code:

Application.GetSaveAsFilename , "Excel-files,*.xls", 1, "Give the name"


The overview can be found from the Help files (select the
GetSaveAsFilename in code window and press F1)

[[email protected]]

Very good thank you. Did not know about the F1-function, but it will
help me a lot on other issues as well :-)