Member Isaac Harned
Member
Forum Replies Created
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
No bueno, not sure there is a way. It pops up with a little warning before deleting that states it can’t be undone.
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
Back when we used to have Foxit PDF creator, I found it to unlock certain docs when printing to PDF. Do not know if this is still the case.
Are these single sheets or multi-page docs?
If single sheet, you could always take a screenshot for a one off work around.
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
ok I am much closer now than ever before thanks to you guys and that amazing tool. Still having a couple issues:
1. I am seeing duplicated field names when formatted to fdf, can’t quite see why this is happening. Some also appear not to add the “J” variable to the name, and there are several duplications of that.
Also having issue with actually saving the file as FDF, as it is trying to save as xml and just adding the extension for fdf. File attached (could not upload “fdf” file, extension not supported. will have to run macro to see), here’s my code so far:
Sub fdfExpTest()
On Error GoTo ErrorHandler
Application.ScreenUpdating = False ‘disabling screen updating
Dim ws As Worksheet
Set ws = Worksheets(“Sheet3”)
Dim lrow As ListRow
Dim table As ListObject
Set table = ws.ListObjects(“Table3”)
Dim sFileFields, formField As String
Dim currentCell As String
Dim fileName As String
sFileFields = “”
Dim i As Integer
For i = 2 To table.ListRows.Count
Set lrow = table.ListRows(i)
currentCell = lrow.Range(1, 1).Address
Dim j As Integer
For j = 1 To 12
formField = “<</V(” & Range(currentCell).Value & “)/T(” & Replace(Range(currentCell).Value, “-“, j & “-“) & “)>>”
sFileFields = sFileFields & formField
Next j
Next i
fileName = InputBox(“Please enter the file name:”, “File Name”)
If fileName = “” Then Exit Sub ‘if user clicked cancel or didn’t type a name
Dim dialog As FileDialog
Set dialog = Application.FileDialog(msoFileDialogSaveAs)
With dialog
.Title = “Select a location to save the FDF file”
.InitialFileName = fileName & “.fdf”
.Show
If .SelectedItems.Count = 0 Then
MsgBox “No location selected, file will not be saved”
Exit Sub
Else
fileName = .SelectedItems(1)
End If
End With
If Dir(fileName & “.fdf”) <> “” Then ‘checking if the path exists
If MsgBox(“A file with the same name already exists, do you want to replace it?”, vbYesNo) = vbNo Then Exit Sub
End If
Dim fso As New FileSystemObject ‘Create a new FileSystemObject
Dim f As TextStream ‘Create a new TextStream
Set f = fso.CreateTextFile(fileName & “.fdf”, True) ‘Create a new .fdf file and open it for writing
f.WriteLine “%FDF-1.2”
f.WriteLine “%âãÏÓ”
f.WriteLine “1 0 obj<</Version 1.5/FDF<</F(12 TU – Portrait.pdf)/ID[<48dd2d6619f25a804876d8592bbf3bec><78c1721c7ccd2e9289e7fbfd72376444>]/Fields[” & sFileFields & “]”
f.WriteLine “]>>endobj”
f.WriteLine “trailer”
f.WriteLine “<</Root 1 0 R>>”
f.WriteLine “%%EOF”
f.Close ‘closing the file
MsgBox “FDF file has been created successfully and saved in ” & fileName
Application.ScreenUpdating = True ‘enabling screen updating
Exit Sub
ErrorHandler:
MsgBox “Error: ” & Err.Description
Application.ScreenUpdating = True ‘enabling screen updating
End Sub
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
You would think the enterprise track of updates would be properly tested and vetted. Oh well, back to disabling!
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
Sure it’s still a work in progress though. Tab one of the excel workbook was my original intent, but I abandoned after only naming a couple of fields.
Tab 2 is the start of the table. Any row identifiers that have no number would get the column name appended to the end. All the row titles with a dash would get the column name before the dash.
I think you are pretty familiar with the pdf form at this point =)
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
So I tested this, and verified. Unfortunately its apparently not the only one. There seems to be no indicator when these fields drop off, everything else about the field was fine and modifiable. May be a support ticket in the end..
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
OK, I am playing with this a bit today, and this could work, but I think it’s gonna take a little finagling. Just as a quick explanation: I have 12 Terminal unit sections on the page with lines built in for Grille data. Each of these lines will have fields that are named by ‘Terminal#-Row#’. I will have to find a way to concatenate this in the middle before the final merge for the FDF format, i.e. “Mark-1” in the first column will end up as “Mark1-1”. Seems like a split first, then store as separate and concatenate, not too bad. It will take me some time to get another round here but I will get back with something here semi-soon.
Unfortunately my job consists of the highest complexity takeoffs, plus training, plus develop new workflows, so timing gets very sporadic. Thank you guys for your patience!
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
Thank you for taking a look, and for your patience with me while I put out fires. Promise I’m turning back to this ASAP!
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
😁 Anything to turn a five minute process into a five second!
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
Copy copy, that’s where I landed as well. Thank you for looking!
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
Hmm that’s not encouraging, but sounds right. I have had various glitches when it comes to these form fields and modifying their properties en masse, and it is a very similar glitch. I will try this out and report back =)
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
This looks awesome! I will runs some tests!!
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
Ah for bluebeam, yes, but unfortunately I am trying Mitch’s suggestion of saving Excel as FDF
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
– All field names consistent across templates.
– Form will be blank when importing.
– No reverse necessary, once it’s in the pdf it’s good. These data files will be used year over year and the transfer from PDF to new version of PDF is easy enough
-
Points: 8,282Rank: UC2 Brainery Purple Belt III
Maybe I am missing it, or maybe its a type of export that I didn’t see in the data tab, but these are the options I have for Save as file type: