hello, I am taking advantage of my keyboard’s programmable macro buttons. I created a keystroke macro to print labels from a spreadsheet selection… Once I select the rows and columns I want made into label I hit the macro which copies the selection, opens an existing spreadsheet file with the columns field names pre-filled, pastes the selections then saves as a temp file (for database reference), opens a new database file, connects to the temp file, saves as a database file (which the label file references), opens the label file(already has the field name referenced) then prints… many processes but I do it several times a day…
what I would like to know is how fast can LO process the macro keystrokes? with multiple file types being created and different applications opening I am trying to get the timing down for efficiency.
I had the keystroke to run at 20ms but would not function, maybe runs too fast?
when I had it record my hand speed it worked fine…
using windows 10
also can this be replicated withing LO not having to use my macro button?
here is the keystroke macro I made sorry, it’s long… hopefully this helps someone as well!! I hit the macro once my selection is made (things in parenthesis are my notes not in the macro) thank you! …
ctrl+c (copy the selection)
alt+f (file)
o (open)
tab
tab
tab
tab
tab
tab (tabs to get the cursor caret to the typing area)
enter
c:\users\user\desktop\lo files\labelmaker\ (folder with the files)
enter
tab
tab
tab
tab
tab
tab
tab (tabs to get the cursor caret to the typing area)
blankfield1.ods (spreadsheet with field names pre filled)
enter (opens the file)
ctrl+v (pastes the selection)
alt+f
shift+a (save as)
temp.ods (temporary file for connect with new database)
enter
y (“yes” overwrite file)
alt+f (file)
n (new)
b (database)
alt+x (gets caret to “connect to existing databsae”)
tab
s (select spreadsheet as file type)
alt+n (next)
alt+b (browse for file to connect)
temp.ods (the file made with the desired data to print)
enter
alt+f (Finish)
labeldb1.odb (name of database linked to the label file)
enter
y (overwrite)
alt+f
o (open)
labelfile1.odt (label file with field names references pre set)
enter
y ( yes get latest info)
ctrl+p (print it!)
y
enter