Hi, see my attached images. The problem is that the keystrokes doesn't work hence the key doesn't move between the rows and columns. Can anyone see what is wrong in my macro?
Thought I could add images.
Links instead:
You should be able to attach images just by dragging and dropping them. It's also helpful if you share your macro to the forum:
https://wiki.keyboardmaestro.com/Forum#How_to_PostUpload_Your_Macro_to_the_Forum
If we see the actual macro, we can usually figure out what's going on much more quickly.
-rob.
The links worked, but for some reason have messed-up preview images. Having now seen the macro, can you explain what you're trying to accomplish? That is, what manual task is the macro trying to automate?
I see a lot of unneeded things in the macro, at least based on what I think you want to do, but it'd be helpful if you just explained the task in words as a first step.
thanks!
-rob.
Hi,
this is my first KM-macro…
I have an excel sheet with 3 columns (id, url, message).
For each row I would like to access the Facebook-profile (=url) and send a message with the personalized message (=message).
Easy as that…
Morten von Hafenbrädl CEO / Daglig leder
MVH NiceLife.no AS
Prestlidi 104, NO-4745 Bygland, Norway
m: +47 9165 1152
w: nicelife.no
e: morten@nicelife.no
|
- |
| griffman Leader
November 16 |
- | - |
The links worked, but for some reason have messed-up preview images. Having now seen the macro, can you explain what you're trying to accomplish? That is, what manual task is the macro trying to automate?
I see a lot of unneeded things in the macro, at least based on what I think you want to do, but it'd be helpful if you just explained the task in words as a first step.
thanks!
-rob.
Thanks, that's a good start. But I have many more questions 
...
Are the links in the URL column clickable, or do you need to copy them and then paste them in a browser? And does this sheet have multiple rows, and do you want the macro to process all of the rows in the sheet when you run it? Or do you want to select a row in Excel, then invoke your macro and it runs just one time on the selected row?
After the macro clicks/opens the link and Facebook appears, are you wanting it to compose and send the message, too? Or is the macro done when Facebook opens?
-rob.
See below
Morten von Hafenbrädl CEO / Daglig leder
MVH NiceLife.no AS
Prestlidi 104, NO-4745 Bygland, Norway
m: +47 9165 1152
w: nicelife.no
e: morten@nicelife.no
|
- |
November 16 |
- | - |
mortennicelifeno:
I have an excel sheet with 3 columns (id, url, message).
For each row I would like to access the Facebook-profile (=url) and send a message with the personalized message (=message).
Thanks, that's a good start. But I have many more questions ...
Are the links in the URL column clickable, or do you need to copy them and then paste them in a browser? And does this sheet have multiple rows<4k+>, and do you want the macro to process all of the rows in the sheet when you run it? Or do you want to select a row in Excel, then invoke your macro and it runs just one time on the selected row?
After the macro clicks/opens the link and Facebook appears, are you wanting it to compose and send the message, too? Or is the macro done when Facebook opens?<my first answer says: send a message with the personalized message in the message-column)>
-rob.
Sorry, but there is nothing below ... and I'm not sure how you're posting, but an entire screen's worth of your bio is appearing every time—probably not needed here, and I don't know that you want to put your email addresses on a public forum like this?
(The entire conversation thread is also getting reposted in every post, which makes this much longer than it needs be, too.)
-rob.
Nice of you to help BUT my way of using mail is not the topic of the day.
I have been using it since it was rolled out in the 80s and will continue to do so MY WAY until I die.
If you don’t like it - leave it but stop commenting on it - that is impolite!
AND, the answers are within <> on each of your own questions.
Please also to keep the history of the e-mail.
Morten von Hafenbrädl CEO / Daglig leder
MVH NiceLife.no AS
Prestlidi 104, NO-4745 Bygland, Norway
m: +47 9165 1152
w: nicelife.no
e: morten@nicelife.no
|
- |
November 16 |
- | - |
Sorry, but there is nothing below ... and I'm not sure how you're posting, but an entire screen's worth of your bio is appearing every time—probably not needed here, and I don't know that you want to put your email addresses on a public forum like this?
(The entire conversation thread is also getting reposted in every post, which makes this much longer than it needs be, too.)
-rob.
You are not replying via email, you are posting to a public forum. The URL is here:
[Excel and keystroke suddenly stop working]
And as you can see there, there's nothing private about it. That URL is public, available to bots, scrapers, scammers, and anyone else who wanders by.
And as you can also see, there's no content in your replies.
-rob.
You'll have a much easier time -- and we'll be able to help you far better -- if you interact with this Forum with a web browser instead of your email account.
You'll also be able to edit your previous posts to remove what I assume is your email signature -- unless you are happy to have your contact details publicly available?
Your answers to @griffman's questions are lost in the rest of the text, and aren't complete. I can see you've got "4k+" rows in your spreadsheet -- do you want all of the rows to be processed by your macro in one go? Or just do one row per execution?
And it will really help us to help you if you post your actual macro rather than images of it. Not only do we get to see, and test, the whole macro but many Keyboard Maestro actions have options that aren't visible in a screenshot but might be causing you problems.
You can find instructions on how to post your macro at How to Post/Upload your Macros and Scripts
Because the OP posted the Dropbox image URLs with dl=0 on the end. That forces them to be links. To see them as inline images, it needs to be raw=1 instead.
I have created a new Topic - starting from scratch from the macro itself in KM. Closing this one.