Save as macro based on multiple options

Hi,

I have created a macro for multiple (about 5) people to run. At the start of the macro I would like them to choose their name from either a drop down box or a userform option button then click ok, once they click ok it would then save the file in their own folder and the filename with todays date, and then continue running the macro.

For example:
Bob B --> saves in c:\excel\Bob B\
Claire S --> saves in c:\excel\Claire S\

I can do a single save as macro but I have never delt with userforms or anything to give multiple options.

Any help would be greatly appreciated and sorry if that didn't make sense. Btw I am using excel 2003.

Cheers

Hi

Why don't you use environ("username") or application.username to determine their "name" and file accordingly? That way the user doesn't have to make any selection.

rylo

Hi -

Try;

Please Login or Register  to view this content.

Regards,
event

Thanks for the replies.

rylo I didn't want to use that as the folder relates to their position not their name sorry - should have made that clear in my first post.
Thanks event21 will try that, but not sure as i haven't worked with combo boxes before.

Hi

Well, how about building a lookup table that maps the username to whatever is being used to generate the path? Position, or something else?

rylo

Hey rylo,
I created this as an add-in so they just open it and it runs straight away as the spreadsheet they get straight from an export from another database. I'm not sure how I would do that with an add-in, I'm not really that good at macros...
Cheers

Hi -

Thanks event21 will try that, but not sure as i haven't worked with combo boxes before.

You need to post your macro here.

Regards,
event

I've worked out how to use the option buttons and then go back to the macro.. Thanks for your help anyways