VBA - posting data from Excel to Word as typed, not making first letter upper-case

[Dave Coram]

Morning!

Hope all's well!

A quick question, if I may:

I have a macro which works exactly as it should - it takes data from an Excel spreadsheet, and pastes it in the relevant places on a Word form - the only thing is, where the data has been put in, it converts the first letter to upper-case (as Word would do normally).

Is there any way in which I can force Word to drop the data in as typed?

It's not a biggie - can work with things as they are, if need be - it just looks odd to have the first letter of things like e-mail addresses in upper-case.

Thanks in advance!

Dave

 

[Alan_P]

Morning Dave,

Something like this;

Set wordapp = CreateObject("word.Application")

Set NewDoc = wordapp.Documents.Add
wordapp.Visible = True

[B]wordapp.AutoCorrect.CorrectSentenceCaps = False[/B]

End Sub

Hope this helps,
Cheers,
Alan.

 

[Dave Coram]

Will give this a go, Alan - thanks!