Public sDate as Date

doesn't work. It says it can't find the date. sDate as String worked
(on my computer).

Susan :/


On Dec 22, 4:51*pm, Susan wrote:
Whew, I'm not completely stupid... I have

Public sDate As String, sCategory As String

in another module.

I will change it to

Public sDate as Date

Susan

On Dec 22, 4:09*pm, Claus Busch wrote:



Hi Susan,

Am Sat, 22 Dec 2012 12:56:51 -0800 (PST) schrieb Susan:

This macro is written in 03 VBA and saved in a 97-03 workbook. *It
works fine on my XP windows desktop, and works fine on my Windows 7
Professional laptop in Office 2010 when saved as a 97-03 workbook. *In
sending to an overseas client (India), however, it keeps bombing out
right at the very beginning because it cannot find the date. *As you
see, I have reformulated the date in her copy to dd/mm/yy, (my
original is mm/dd/yy), because I assume her computer defaults to dd/mm/
yy. *She tried manually formatting Column A to dd/mm/yy, but
apparently that hasn't worked. *Any suggestions?

try:
sDate = Date
That works for all language settings

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2