AndreaM
12-09-2016, 10:12 PM
Hi
I have a Word doc with VBA script to populate numbers from a Userform to a Table in the Word doc. This works perfectly, but the problem I have is with the currency format of the number. It works well if the format in the doc is the same as the regional settings on my PC, but the problem comes in when the template runs on a machine with different regional settings, specifically on the decimal symbols and number separator. I cannot a way to force this setting in Word just for this template so that the macro works from any machine. Also Word 2016 doesn't have the option to set the decimal and separator symbol just for Word.
Can someone please help me with this problem I have been battling with for several weeks now.
Kind regards
Andrea
I have a Word doc with VBA script to populate numbers from a Userform to a Table in the Word doc. This works perfectly, but the problem I have is with the currency format of the number. It works well if the format in the doc is the same as the regional settings on my PC, but the problem comes in when the template runs on a machine with different regional settings, specifically on the decimal symbols and number separator. I cannot a way to force this setting in Word just for this template so that the macro works from any machine. Also Word 2016 doesn't have the option to set the decimal and separator symbol just for Word.
Can someone please help me with this problem I have been battling with for several weeks now.
Kind regards
Andrea