Run-time error when saving with macro

[rpinxt]

Hi All,
I made a model for our department and part of this model is the option to generate, from excel, a word document with data from excel and then save it to a shared drive.
Now the strange thing that happend suddenly that 1 user gets a Run-time error '13' : Type mismatch.
Up till now no other users (including me) are getting this error. For me it just works fine.
Can anybody tell me what is going on here? In the past she was also able to generate the word file.
And just to let you know, yes she still has read/write authorization on that shared drive.

Here is the code. The line which generates the error is to the bottom of the code and is the line which starts with "objWord.ActiveDocument.SaveAs Filename:="P:\Finance\....."

Please Login or Register  to view this content.

Thanks!

[hulpeloos]

your string :

Please Login or Register  to view this content.

versus

Please Login or Register  to view this content.

-are you sure each cell that is referd to is containing data and in the correct format ?
-does any of those cells contain formulas ? e.g. (Today-1) and are you sure this users has his regional setting (time & date) setup the same as you ?
(one of the reasons you should be using the format fucntion when working with dates and times if file is used on different pc's )

( had the same issue once and it did take me half a day before i realised the person getting the error had his regional settings on mm/dd/yy as others had it on dd/mm/yy )

[rpinxt]

Hi hulpeloos,
Thanks you for saving me that 1/2 day! You were right it were the date settings....
She now was able to generate the document without saving errors.

But just out of curiousity, how would I change my code with the format function you stated?
Thanks.

[hulpeloos]

e.g.

Please Login or Register  to view this content.