Home

Inserting large text/long string from Excel cell to fillable PDF form

%3CLINGO-SUB%20id%3D%22lingo-sub-793534%22%20slang%3D%22en-US%22%3EInserting%20large%20text%2Flong%20string%20from%20Excel%20cell%20to%20fillable%20PDF%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793534%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20%22export%22%20a%20large%20string%20of%20text%20from%20a%20cell.%20Here's%20an%20example%20of%20the%20text%20(formatting%20and%20spaces%20between%20paragraphs%20included)%20as%20downloaded%20from%20a%20SharePoint%20database%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CEM%3E%3CFONT%20size%3D%221%22%3EBACKGROUND%3A%20The%20Brine%20Chiller%20has%20multiple%20rivnuts%20on%20the%20frame%20that%20are%20used%20when%20installing%20the%20Brine%20Chiller%20Handling%20Set%20(~4%20per%20side).%20(Reference%20TO%20for%20visual)%20The%20Handling%20Set%20is%20used%20as%20the%20sole%20method%20of%20installing%2Fremoving%20a%20Brine%20Chiller%20from%20the%20LCEB.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CEM%3E%3CFONT%20size%3D%221%22%3EPROBLEM%3A%20Several%20of%20the%20rivnuts%20on%20the%20Brine%20Chiller%20frame%20are%20not%20able%20to%20support%20a%20threaded%20bolt%20from%20the%20Handling%20Set%20and%20require%20replacement.%20However%2C%20the%20IPB%20does%20NOT%20list%20any%20part%20information%20for%20these%20rivnuts.%20We%20do%20not%20have%20any%20other%20Brine%20Chillers%20on%20base%2C%20so%20until%20we%20get%20these%20rivnuts%20replaced%2C%20we%20are%20unable%20to%20install%20a%20Brine%20Chiller.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CEM%3E%3CFONT%20size%3D%221%22%3EAfter%20discussing%20with%20local%20TEF%2C%20they%20were%20able%20to%20look%20at%20MICS%20and%20determine%20that%20the%20following%20is%20the%20correct%20part%20information%3A%3C%2FFONT%3E%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%3CFONT%20size%3D%221%22%3EPN%23%3A%20%23%23%23%23%23%23%23%23%3C%2FFONT%3E%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%3CFONT%20size%3D%221%22%3ENomenclature%3A%20Rivnut%2C%20large%20head%2C%26nbsp%3B%3C%2FFONT%3E%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%3CFONT%20size%3D%221%22%3EUNC-2B%2C%20.165%2F.260%20grip%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CEM%3E%3CFONT%20size%3D%221%22%3EHowever%2C%20when%20we%20checked%20with%20Supply%20to%20see%20if%20it's%20orderable%2C%20it%20was%20found%20to%20be%20%22not%20authorized%20for%20US%20use.%22%20Without%20a%20specific%20TO%20reference%2Fprocedure%2C%20they%20need%20supporting%20documentation%20to%20get%20it%20ordered.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20size%3D%221%22%3ERECOMMENDATION%3A%20Requesting%20approval%20of%20provided%20part%20information%20and%20authorization%20to%20purchase%20Rivnuts.%3C%2FFONT%3E%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%3CFONT%20size%3D%221%22%3EAfter%20purchase%2C%20removal%2Finstallation%20of%20rivnuts%20will%20be%20coordinated%20with%20local%20TEF%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3EI'm%20trying%20to%20write%20a%20VBA%20code%20to%20take%20this%20information%20and%20insert%20it%20into%20a%20fillable%20PDF.%20It%20doesn't%20neccesarily%20need%20to%20use%20the%20%22application.sendkeys%22%20function%2C%20but%20the%20rest%20of%20my%20code%20to%20input%20other%20values%20into%20the%20PDF%20follow%20this%20format.%20Any%20help%20would%20be%20greatly%20appreciated!%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-793534%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Concileus
New Contributor

I'm trying to "export" a large string of text from a cell. Here's an example of the text (formatting and spaces between paragraphs included) as downloaded from a SharePoint database:


BACKGROUND: The Brine Chiller has multiple rivnuts on the frame that are used when installing the Brine Chiller Handling Set (~4 per side). (Reference TO for visual) The Handling Set is used as the sole method of installing/removing a Brine Chiller from the LCEB.


PROBLEM: Several of the rivnuts on the Brine Chiller frame are not able to support a threaded bolt from the Handling Set and require replacement. However, the IPB does NOT list any part information for these rivnuts. We do not have any other Brine Chillers on base, so until we get these rivnuts replaced, we are unable to install a Brine Chiller.


After discussing with local TEF, they were able to look at MICS and determine that the following is the correct part information:
PN#: ########
Nomenclature: Rivnut, large head, 
UNC-2B, .165/.260 grip


However, when we checked with Supply to see if it's orderable, it was found to be "not authorized for US use." Without a specific TO reference/procedure, they need supporting documentation to get it ordered.

 

RECOMMENDATION: Requesting approval of provided part information and authorization to purchase Rivnuts.
After purchase, removal/installation of rivnuts will be coordinated with local TEF

 

I'm trying to write a VBA code to take this information and insert it into a fillable PDF. It doesn't neccesarily need to use the "application.sendkeys" function, but the rest of my code to input other values into the PDF follow this format. Any help would be greatly appreciated!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies