We are using the AutoSplit™ / AutoSplit Pro™ by EverMap to split documents.
It uses Regex, or regular expressions for more advanced splits.
I need to split a large report by VERSION ID (report version) and CASE ID (the client). The version id is on one line, left justified (time stamp...
So I tried several approaches, and had success with
Dim stAppName, strPath As String
Dim varResult as Variant
strPath = "C:\Reports\REPORT_TEST_CLIENT91.pdf"
Application.FollowHyperlink strPath
SendKeys etc...
Objective: To open a pdf report from Access03 module, use SendKeys to paste in a predetermined, client specific password for (already set-up) secure email sending. Close. Loop to next report.
Table contains client code, password. Match reports in folder by Client Code and Paste in strRptPath...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.