Ask Your Question
0

keyboard macro speed between multiple apps

asked 2018-11-06 22:09:26 +0100

clos911 gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-11-10 06:45:48 +0100

clos911 gravatar image

updated 2018-11-10 06:47:54 +0100

To answer my own question, after messing with the timing a bit, LO was able to process my key stroke macro at a speed of .02 second between each key press and a 2.5 second delay when opening another LO program so that the keystroke commands continues once the program is fully loaded. I'm sure LO can process faster than .02 seconds between keys but I'm trying to play it safe. This is saving me a lot of time making labels, hopefully someone can modify and use this to their own needs.

The marcro begins after the selection is made. https://drive.google.com/file/d/1l1fH...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-06 22:09:26 +0100

Seen: 15 times

Last updated: Nov 10