moorecurls
New Member
- Joined
- Oct 28, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I have to use SendKeys to fill in a pdf form. I'm using the below code that is working but not correctly each time:
Dim localDate As Date
localDate = Date 'is current system date
'Fill in fields
SendKeys localDate 'put extra tabs here if needed
The variable localDate is today's date 6/7/2024 in both locations but when it enters into the pdf it is only printing 6/7/2. Any suggestions on how to get this to work each time with the full date? The pdf field needs the date in the MM/DD/YY format. So maybe I need to format the variable. Any suggestions on how to do this? Thanks.
Dim localDate As Date
localDate = Date 'is current system date
'Fill in fields
SendKeys localDate 'put extra tabs here if needed
The variable localDate is today's date 6/7/2024 in both locations but when it enters into the pdf it is only printing 6/7/2. Any suggestions on how to get this to work each time with the full date? The pdf field needs the date in the MM/DD/YY format. So maybe I need to format the variable. Any suggestions on how to do this? Thanks.