Doug McLean
Member
Forum Replies Created
-
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

@mechave would be your best source on this one
-
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

Hi Austin, welcome to the Brainery.
In answer to your question, probably not directly, but its more than likely doable.
You’re first going to have to figure out exactly how data will get imported into your software.As David said, you’ll probably have to wash it in Power Query or something to get it exactly correct.
You can look for my post about my XCON presentation on the message boards, it walks you through all the steps you’re going to need to do first in order to do what you want.
If you like, you can jump on Studio and join Project 971-801-391. Its my presentation with the full Power Point and a bunch of step by step instructions.Cheers
-
Doug McLean
MemberJanuary 4, 2023 at 2:58 pm in reply to: Visual Basic coding, Cells to Form Fields exportPoints: 18,312Rank: UC2 Brainery Advanced Blue Belt III
I just looked and there is a Get PDF Form Data connector in Power Automate.
Its put out by Encodian.
I’ve never used this, but I’m sure with a little digging, we could figure it out pretty easily. -
Doug McLean
MemberJanuary 4, 2023 at 2:39 pm in reply to: Visual Basic coding, Cells to Form Fields exportPoints: 18,312Rank: UC2 Brainery Advanced Blue Belt III
It seems going from PDF data to Excel is fairly easy, but going the other way is almost impossible.
I would still explore the use of Power Automate though, might be the easiest way
-
Doug McLean
MemberDecember 31, 2022 at 2:58 pm in reply to: Visual Basic coding, Cells to Form Fields exportPoints: 18,312Rank: UC2 Brainery Advanced Blue Belt III
Isaac, are you trying to go from Excel to PDF? Why?
Wouldn’t it be much easier to go to either a Word or Excel form and then just print to PDF?
Another way would be to use Power Automate to take named cells from an Excel document to a PDF.
-
Doug McLean
MemberDecember 30, 2022 at 6:09 pm in reply to: Use your scroll wheel to avoid moving markupsPoints: 18,312Rank: UC2 Brainery Advanced Blue Belt III
One of my personal favourite tips and tricks to share.
-
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

Thanks Dave.
Same to you and your family
-
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

In a word, no, but the data can be exported.
-
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

I always have new people add this to their toolbars when I give them their initial tutorial.
I have to say it’s a bit confusing to me that this isn’t a default tool.
If you go looking for it, its on the Text toolbar. Just check the box to add -
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

RIGHT?!?!?!
-
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

Yeah, sometimes you do something and you get an unexpected result.
One simple line of code can change something that’s worked for years. You don’t even realize what you’ve done. -
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

If you need any help, just let me know
-
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

I use it to show how to add a tool to a toolbar.
-
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

Mine is set that way.
It only happens when I use an email template. -
Points: 18,312Rank: UC2 Brainery Advanced Blue Belt III

This is why I use Forms.
Revu makes it very easy to export all the form data. Plus if they’re all in the same folder, you can use Merge Data and Revu will pull all the like data fields together in one simple report.