[Solved] Program to create CSV from PDF: User-defined type not defined

[JayS]

Edit: Split from Create CSV from Formdata of PDFs in a folder (using PDFtk) because the Code Snippets forum is not the right place to ask questions about how to use macros.

Hey, hopefully this will get a reply. I have PDFtk server and toolkit installed, added the code here and ran the macro. I am getting an error
"Compile Error - User defined type not defined"
I am at a block here. I cant see anything in the below to change

Function MakePropertyValue(Optional cName As String, Optional uValue) As com.sun.star.beans.PropertyValue

All I need is the page numbers from the list. Hopefully there is something I can alter to make this work.

Any help is appriciated - Jay

[Zizi64]

Microsoft Visual Basic for Applications?????????????????

How it is related to the StarBasic + AOO/LO API based macro code???

[John_Ha]

Macros are not compiled.

1. Place the macro as described in musikai's post - eg in Tools > Macros > Organise Macros > OpenOffice Basic > My Macros > Standard > Module 1.

2. Run the macro by going to Tools > Macros > Organise Macros > OpenOffice Basic > My Macros > Standard > Module 1 and running Folder_of_PDFs_to_CSV.

It should run.

Read the book "Macros Explained" at http://www.pitonyak.org/oo.php for more information or see the User Guides or read Help.

[Mountaineer]

...
1. Place the macro as described in musikai's post - eg in Tools > Macros > Organise Macros > OpenOffice Basic > My Macros > Standard > Module 1.
...

I guess he can't, because his signature says he is using Office365.
As M$ don't know UNO the code stumbles at the first type from UNO-libs.

Using Macros from OpenOffice/UNO in VBA is even more comlicated as the other way round, as I assume there is no flag to switch uno-library-compatibility.

So before 1) he needs 0) to install either OpenOffice or LibreOffice, or he has to rewrite the code in VBA.

J.

[Hagar Delest]

Topic moved to the General discussion section. To avoid confusion with AOO related questions.

[JayS]

Thank you for the replies all. Very silly of me here, yes I was using 365 so that's probably why this wasn't working. I did find TTFA PDF Page Counter in the meantime which was exactly what I needed so thank you for your help here