Problems with saving via VBA

[rpinxt]

So we have some sort of form in which a macro 'submits' it.
Basically what it does is save the workbook as a non macro workbook in a different place.

This works for all people just fine....except for 1.....
For what I know he has the same excel and settings and all (full open for macro's).
Still only he gets the :
"Runtime Error 1004: method saveas of object _workbook failed"

This is the code for saving:

Please Login or Register  to view this content.

Could it have to do with "FileFormat:=xlOpenXMLWorkbook"
But why would it still work for all others??

[CK76]

"Activeworkbook" is prone to causing error, depending on user action and set up etc.

Try specifying workbook object, using name or some other method.

If you can, post full code. Just looking at that snippet, only advise I can give is above.

[rpinxt]

Ok let me then share the full code:

Please Login or Register  to view this content.

[CK76]

So, the code is saving the workbook that houses the code? Then just replace "Activeworkbook" with "ThisWorkbook" and see what happens.

[rpinxt]

Yes I guess.

Its like this.
With another macro I generate several workbooks that house the code like above.

Then user needs to fill that workbook and press button submit.
Macro writes a copy to a different place as a (normal) xlsx.
So the xlsm becomes and xlsx and then the xlsm gets deleted in the other folder.

I will replace it with ThisWorkbook.
Unfortunately this process happens only once a week so I will need to get back to you if this will work.

Maybe there are some more things I can try?
Like declaring the workbook or something?

[CK76]

You could declare workbook variable and set it as well. Though it's not necessary if the code is referring to the workbook that it's housed in.

[xlnitwit]

Have you verified that the user has the P drive mapped, and to the same location as everyone else? And also that he or she has permission to save to that folder?

[CK76]

If that was the case, it should give same error number but different message.

Something in line of...
"Microsoft Excel cannot access the file..."

[rpinxt]

Yup those where the first things i checked.

When it crashed I ended the macro and manually saved the file (under his user account naturally) to the placed it should go.
No problems (first also thought he would not have access to that folder, but was not the case).