Good day.
Current scenario:
*1. Database.*
I have a spreadsheet (Sheet 1) containing the information
*2. Template (quote form).*
There is a form, with a specific layout that uses:
a- Validity > Cell Range > First Column from Sheet 1
b- For the fields (date, description, etc.) the function
=IFERROR(VLOOKUP($B$4,'Sheet1'.A2:E89,*5*,0),0) is inserted (FYI the *5*
changes depending on the column required from Sheet 1-- date is 5)
*3. PDF Export Macro.*
The following macro (inserted in an action button) is used to export to PDF:
/sub ExportPDF
Dim oDescriptor
rem define variables
dim document as object
dim dispatcher as object
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
oSheets = ThisComponent.getSheets()
oSheet3 = oSheets.getByIndex(2)
rem name of the file
filename = oSheet1.getCellRangeByName("B4").getString()
rem ----------------------------------------------------------------------
rem Prepare for PDF export
dim args1(1) as new com.sun.star.beans.PropertyValue
args1(0).Name = "URL"
args1(0).Value = "file:///C:/Users/rb/Desktop/Special%20Project/Joe%20Doe/"&
oSheet3.getCellRangeByName("B4").getString()&".pdf"
args1(1).Name = "FilterName"
args1(1).Value = "calc_pdf_Export"
dispatcher.executeDispatch(document, ".uno:ExportDirectToPDF", "", 0,
args1())/
end sub
Everything working great here: the quote is exported to PDF using the name
of cell B4, which is the cell containing the cell range from Sheet 1. Every
time I click on the drop-down box (validity) the information (date, etc.)
changes based on Sheet 1.
*Question:*
Is it possible to create a macro that exports simultaneously all of the
quotes (in PDF) according to the validity cell range?
By doing this, I wouldn´t have to click on the drop-down box each time I
want to get the next set of information.
*The desired result would be that with one single click on the "push
button", 88 PDF files would be exported (with the correspondent information
and file names)
*
I disabled the ExportPDF macro because it won´t work anyway, but here is the
file:
Example.ods <http://nabble.documentfoundation.org/file/n4174861/Example.ods>
On the sheet labeled as "Print", go to cell B4 for the drop-down box.
Any comments?
Thanks!
--
View this message in context:
http://nabble.documentfoundation.org/Simultaneous-PDF-Export-from-a-spreadsheet-database-based-on-validity-tp4174861.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
