Save As macro keeps crashing excel program

Hi,
I’m wondering what I’m doing wrong here.

I have a Macro designed (not mine) to pick up a person’s name in cell A2 and “save as” when someone choses to save the template.

This macro works in that a file is saved in the right drive under the name in cell A2 however it also crashes the excel program (Excel 2010).

Problem signature:
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 14.0.4756.1000
Application Timestamp: 4b9c08e8
Fault Module Name: EXCEL.EXE
Fault Module Version: 14.0.4756.1000
Fault Module Timestamp: 4b9c08e8
Exception Code: c0000005
Exception Offset: 00041e17
OS Version: 6.1.7601.2.1.0.256.48

I’m assuming it’s a security thing (might not be) but if other users have to enable security each time they use this file it will be useless. I’m trying to design for users that have current issues in manually choosing the “save as” function let alone the skills for disabling security settings.

Can someone please give me some guidance

Please Login or Register  to view this content.

Regards
Graeme

Hi TMS,
thanks for your very fast reply.

gave it a try and same outcome it saved name in A2 but crashed the program - this time a different event name

Problem signature:
Problem Event Name: BEX
Application Name: EXCEL.EXE
Application Version: 14.0.4756.1000
Application Timestamp: 4b9c08e8
Fault Module Name: unknown
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Offset: 0016afb4
Exception Code: c0000005
Exception Data: 00000008

Hi TMS

A2 is just the cell the "save as" is getting the file name from (name of person)

I'll try the diagnostics.

Thanks for your help - much appreciated

OK
This is officially driving me nuts
The file will ‘save as’ but the program crashes…


Problem signature:
Problem Event Name: BEX
Application Name: EXCEL.EXE
Application Version: 14.0.4756.1000
Application Timestamp: 4b9c08e8
Fault Module Name: unknown
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Offset: 0029ae24
Exception Code: c0000005
Exception Data: 00000008
OS Version: 6.1.7601.2.1.0.256.48
Additional information about the problem:
LCID: 1033
skulcid: 1033



the only other macro to this file is

Please Login or Register  to view this content.

is it at all possible that these 2 macros are conflicting?