ActiveDocument.Close error

[IonutC]

Hi guys,

I have a code and it works perfectly, but because I use a template dotx I have an error when I am trying to close the document.
In the excel appears a window to save the doc somewhere as dotm but i don;t want to do that. I simply need to close my active doc without saving anything etc.

Can you please advise?

Please Login or Register  to view this content.

I think the line would need to be:

Please Login or Register  to view this content.

but is still not working. Maybe I need to put numbers instead of wdDoNotSaveChanges and wdOriginalDocumentFormat.
I searched on MSN and I was not able to find the real numbers for them.

Thank you in advance,
Ionut

[grimes0332]

You are using Late Binding (Unless you have added a Reference to Word in ther Tools.References menu) so you need to replace all the [wd...] constants, which only exist when Word is explicitly referenced, with the numeric equivalent.

You can get these from the VBA environment in Word.

[IonutC]

Hi,

I have Microsoft Scripting Run time selected in VBA, despite I have the late binding in the name and I have the same issue.
Is there another one I have to select?


Thanks,
Ionut

[macropod]

Cross-posted at: http://www.mrexcel.com/forum/excel-q...ose-error.html

Please read the Cross-Posting policy in rule #8: http://www.excelforum.com/forum-rule...rum-rules.html

[IonutC]

Thank you! I taught the forums are different and not the same. will keep this in my mind.

[macropod]

I taught the forums are different and not the same.

They are different: that's the whole point!

[IonutC]

got it thanks!

[macropod]

I see you're also carrying on the same discussion in this thread: http://www.excelforum.com/excel-prog...oc-to-pdf.html

Please read the Duplicate Thread policy in rule #5: http://www.excelforum.com/forum-rule...rum-rules.html

[IonutC]

Macropod I started the topic as save doc to pdf. when i saw that i got an error i created a new topic with the error i got, in meantime the discussion from pdf evolved to the one with error.

[IonutC]

Hi,

For future users that will have the same error please note that I had the error because I had a comma

Please Login or Register  to view this content.

and i should have:

Please Login or Register  to view this content.

Cheers and thanks to all!

Ionut

[IonutC]

Hi,

For future users that will have the same error please note that I had the error because I had a comma

Please Login or Register  to view this content.

and i should have:

Please Login or Register  to view this content.

Cheers and thanks to all!

Ionut

[macropod]

You should have kept the discussion in the original thread, as it's all part of the same issue you're having with automating Word. Saving a document as a pdf is little different than saving in any other format. Now you've got two discussions going with people working at cross-purposes and/or reinventing the wheel.