Re: Adobe Reader Macro
Julio Cesar Thap
I have this Excel sheet that consolidates a bunch of reports and prints them to PDF. The code works fine when I was on a pc that had the actual Adobe software installed. I tried using it on my personal lap top which only has a adobe reader and the macros crashed with:
Excel does not require any specific library to be there for it to ExportAsFixedFormat Type:=xlTypePDF but to useAcroExch.App Adobe Pro is required. So it really depends on what you want to do with the PDF (it is not clear from your code, I guess it is not just open or create), to do certain things Adobe Pro might be better suited, another might do certain things better, etc. For example, BYTESCOUT SDK are powerful, easy to use and support multiple functionality and If I need to create CSV from PDF I can do it by adding 3 linesin your code:
Has anybody used this health dashboard- as it is for testing your implementation and your data governance, auditing and QA efforts as well as all variables, success events/metrics hits/instances for the whole suite. It is very helpful because it has some kind of anamoly detection built in it with confidence interval testing for custom success events extending past 100 as well as the evars and props. It also populates an email screenshot and uses outlook via a macro from the trigger of a button for creating an alerts email. I love this doc but it takes about 15-20 mins to run and we have about 20 different sites/report suites and it is not ideal for all of them.
A couple problems here:
1) it seems to freeze or break at any point when it is running after you click "run dashboard" to audit your report suite. I can't or dont know how to debug this to see where it is occuring - if it is some kind of setup/configuration I have (bc I haven't manipulated much of it other than the checkboxes to extend the variable auditing) and can't tell if its the API/server and the reporting Que backed up causing the freeze/stop or if it is something on my computer as it uses a significant amount of ram.
2) since our sites aren't identical in the implementations due to the features we have on our sites that are setup for tracking- we can't use the global report to see if any anomalies are detected unfortunately or else I would be using the global roll-up to then isolate and see where the breaks/anomalies are present and which site to go and dig deeper to fix any inconsistencies found- so I have to run all 18 of these dashboards.
3) Because of the lag/freezes- when I set it up with a vbs script to run and windows task scheduler, it then stops on one report and any other reports that i have scheduled to run later in the day don't run because of that one report that froze because it doesn't close it out so another can continue forward to run later in the day. So this freeze problem that happens within the sheet when it seems to break is causing all of the headaches I have. I'm wondering if there is a known issue and way to fix this but also if not- if theres another way to simply audit all sites implementations - that is all inclusive and as detailed as this report as it is very helpful and i prefer it as I can find a way to get the automated email alerts setup with some other scripts to email me accordingly. I want to get it all automated at some point but this one problem is holding up a lot of progress I've been trying to gain traction on.
Any help would be greatly apprecaited. Really all I have done is tried a few troublshooting steps - I just open the doc- enter my client id and secret and check all three checkboxes and hit run report and clear out the old report- right after that is when it freezes after I "run dashboard" macro by clicking the button. I've tried loading report builder before because it seemed to run better I noticed if you login to report builder add-on first in excel, and I've attempted to see if a self-signed certificate would help but nothing. And to note- it happens in both manual and automated operations so really there isn't much to go with on it or any detailed instructions as to what I can do to make it run more efficiently and not freeze or any FAQs on it in particular. Most of the instructions just show how to set it up and then run it and that's it. I had to figure out the vbs script to open it and run the macros myself with task scheduler. Thanks in advance. I'll try and attach the zip file I got with the report template and insructions if anyone would like to see it but I'll need to check with adobe I think as to the permissions and sharing it with the community as I'm not sure if it is allowed yet. Thanks!
I am glad to hear you are getting some value out of the Health Dashboard. I'm not sure what version you are using, but here's the latest and greatest version. We are always optimizing it to run as fast as possible. Keep in mind it is tapping into potentially hundreds of different reports at the same time, which is why it often takes a while to run, please be patient
Regarding customization - the Health Dashboard is available to be customized to your specifications. This can be done by Adobe Consulting Services. Please reach out to your Account Manager to request this.
If I'm correct, I believe you did the session at the summit I believe. Thank you so much for all of the content you shared! These dashboards have been extremely helpful and saved me hours on hours of work... So yes, I am finding a lot of use with them for the 18 suites I help manage. I do realize that there is quite a few things being pulled, so I apologize if i was seeming impatient. I've actually built a few SDRs mainly with R language, and have used the API explorer among other things so I'm used to it- I think I was more focused on the fact that it was freezing on me and couldn't figure out when trying to debug what might have been happening. Nevertheless, I am so grateful for this template and I've found things I never would have, as-well-as debugging or report building that would have taken me hours otherwise. I really wanted to make a video sometime on how easy it is to do the script with task scheduler, because it is easy enough to where anybody can automate something like this. However, time has been tight with work and I haven't had time to reach out to your team to get approval because I wanted to pay-it-forward and help others like your team and yourself have helped me with it. Regardless, thank you so much and this solves my dilemma! Very appreciated!
3. Red is indicative of governance problems, ie enabled but not receiving. Unfortunately the converse events being sent towards non-enabled variables are not identified by the tool, however the Experience Cloud Debugger will show a little triangle for this situation.
Hey Eric,
I noticed that the alerts summary isn't present in the latest health dashboard. Was this intended by chance or was it planned to bring that back in any future health dashboards? Reason being, is the automated emails that I made- were using that one tab. It's fine because the old health dashboards still work flawlessly (if not using to segment hence the most recent looks great btw and works with segments) but was curious only because of my automated daily/weekly master reports that I made that compiles the summary results of all the analytics health dashboard sheets for each site. Thanks eric!
Hi,
Im trying to copy text from a PDF File to an excel workbook, I have managed to open the PDF File with a userform the user selects the file to open using Application.GetOpenFilename then I use a Function I found to open the PDF file, so far so good, but then when I try to use sendkeys to select all and copy it doesnt work, this file ( Macro ) is going to be used on several computers on several places so I dont know the path of the program used to open the PDF File, any ideas on how to select and copy the text from the PDF File ? Thanks in advance !
Not all pdf files have content that can be selected and copied. If you have Acrobat, not Adobe Reader, one can get the content. Some 3rd party programs that we can use in Shell() can do it probably. After that, you are left with the kludgy SendKeys() sort of method. If you want to continue with that method, see:
Hi Kenneth thaks for your reply, the pdf files that Im trying to select and copy are all text and have the same format, if I open manually one of these PDF with Adobe Reader I can select all and copy using CTR + A and CTRL + C, but I want to automatize these process for the final user, by the way I cant use a third party program.
This is the function I use to open the PDF file, but after the file is opened I cant select and copy, the sendkeys ("^a") select the text (code) inside vba instead of selecting the text in the PDF file, watching your code on the other thread I see or at least I think that I need the path of the adobe reader, but the thing is that this excel file is going to be used by several final users on several computers and I dont know the path of their adobe readers, it is posible to track or identify the path after the PDF file is opened, after the "objshell.open" line ? so I can use it on the code of the other thread.
The sequence of events you need are:
1. Launch the PDF file (open it)
2. Activate the opened PDF file
3. SendKeys to highlight and copy all
4. Re-activate the Excel workbook that will store the pasted content
5. Dump the copy into an Excel sheet (presumably)
6. Close the PDF file
Once the PDF file is activated the SendKeys commands can be used.
Again, this can get tricky. If the Page Display in Acrobat is set by default to Enable Scrolling, then Ctrl+A will highlight the entire file, otherwise only the active page.
One way around this is to send the Shift+Ctrl+H key sequence to put acrobat into auto-scroll mode.