ReportSmith Macro ADP Hosted EV4 1

[tol514]

Question: Can I code a SaveReport and use the xls extension PLUS some code to invoke the "Retain Formatting" option? (The retain formatting option is now a check-box on the save screen.) Tom

Tom Walsh, HRIS Analyst
Capital Health System
ADP HR&Payroll wi RSmith

 

[CharlesCook]

I Don't think "Retain Formatting" is in the macro lang anywhere. You may be able to find a print driver that creates something Excel can read.

Check out PrintReport and SaveReport in the Macro book:

http://www.srs-inc.com/Downloads/Doc4x/UsersGuide/ugc11.pdf

You might be able to do something like sendkeys and force the interface to do it. I would bet money it would only work some of the time.

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[tol514]

Charles, this documentation is VERY helpful! Thanks so much!! In fact, thanks, in general, for your help in many of these threads. Tom

Tom Walsh, HRIS Analyst
Capital Health System
ADP HR&Payroll wi RSmith

 

[CharlesCook]

You’re welcome.

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[rogerj9000]

Now I have run into this with reports that I export into Excel. ReportSmith's Excel driver is very old. Try exporting as a .CSV file instead and then open that in Excel. That resolve the problems I was having with formats and numbers imported as Text

 

[tol514]

That's a great idea, Roger. Thank you! Tom

Tom Walsh, HRIS Analyst
Capital Health System
ADP HR&Payroll wi RSmith