AOO version -OpenOffice 4.1.7 (en-GB) - OS - Windows 10 Desktop PC
Novice 75 yo here so please excuse any oddities. Searched a lot of Posts and topics and to be honest I'm not sure what I'm looking for but did use " Macro " in the search engine but could hardly understand what I was reading.
To keep the old grey matter up top still swirling I joined an online Virtual Golf club ( WGT ) and was asked to see if I could set up a member monitoring system to keep records of members score details. The membership is 100+ and increasing so I needed somthing that would be fast and efficient so I thought that a Macro would be ideal.
Initially I have just added named Tabs on separate sheets to record their scores, accessed via the web site, the member's golf club, the member's online name, and the member's score details in a tabulated format.
Tried Copy & Paste variations ( Ctrl+c -Ctrl+v - Paste Special variations, etc,etc ) and I tested it out on just 3 named members to get it working but it repeats the last recorded member details and pastes all the same details in the 3 named Tabs!
Due to my lack of knowledge on this subject I have made a short video clip ( if moderators allow to post: - non public & unlisted ) to show what I am doing to enable anyone that may be able to help, to quickly see the problem. ( and solution I kindly hope ) Included in the video clip is the dialogue of the recorded Macro and in clip comments if it helps.
Hope the detail shows up but there is a large screen option as the video starts up that looks like [ ], and a High Definition option of 1080p for best results
Video Link,( swipe and go to.....) https://youtu.be/cBP8m8XZ5ro?feature=shared
I can sort out any minor formatting ( dates alignment, Hyperlink removing etc (( which I've tried also )) so long as I can get the Macro working correctly. Any help would be most appreciated, thank you.
Macro repeating same data in different named Tabs
Macro repeating same data in different named Tabs
Apache OpenOffice 4.1.17 - Win 10 OS - PC Desktop
Re: Macro Repeating same data in different named Tabs
If you want the macro to copy data from the web, you should abandon that plan. The macro recorder will certainly not do that and even a user-written macro in a "real" programming language would be quite a task to write. Is the data only available on player-specific web pages? Is there no way to get data for many players at once?
Let's back up even farther. Do you have one tab per player? You almost certainly don't want to do that. It will make it very hard to put together any summary covering multiple players. Please explain what you want to achieve with the spreadsheet. What does it mean to monitor a player?
Let's back up even farther. Do you have one tab per player? You almost certainly don't want to do that. It will make it very hard to put together any summary covering multiple players. Please explain what you want to achieve with the spreadsheet. What does it mean to monitor a player?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Macro repeating same data in different named Tabs
Thank you FJCC for your prompt reply.
"you should abandon that plan. The macro recorder will certainly not do that and even a user-written macro in a "real" programming language would be quite a task to write."
Well, that puts it in a nutshell thank you for being forthright, so I will have to think of something else.
"Is there no way to get data for many players at once?"
Yes, but not the relevant information that I'm looking for i.e. specific course, specific Tournament type, score on that course, skill level etc.
" Do you have one tab per player"
Yes because different players play more rounds than others and at a different pace and the details on the sheet that I hoped tp collect would reflect this and other relevant information for that particular player.
"What does it mean to monitor a player?"
When a new player starts his/her Golf career on the game, they start at a beginner's Rank or level. If they join a club ( which is recommended to progress quicker ), keeping club member score details of their progress can help their club peers to advise and teach them what and how to do certain skills to enable them to enjoy the game better and move up the levels.
"Please explain what you want to achieve with the spreadsheet."
Upon gathering the info required via the details collected on the spreadsheet it was hoped to use conditional formatting, sort etc.highlighting any trends which could be seen at a glance rather than having to study in greater detail.
Thank you once again for your reply and advice.
"you should abandon that plan. The macro recorder will certainly not do that and even a user-written macro in a "real" programming language would be quite a task to write."
Well, that puts it in a nutshell thank you for being forthright, so I will have to think of something else.
"Is there no way to get data for many players at once?"
Yes, but not the relevant information that I'm looking for i.e. specific course, specific Tournament type, score on that course, skill level etc.
" Do you have one tab per player"
Yes because different players play more rounds than others and at a different pace and the details on the sheet that I hoped tp collect would reflect this and other relevant information for that particular player.
"What does it mean to monitor a player?"
When a new player starts his/her Golf career on the game, they start at a beginner's Rank or level. If they join a club ( which is recommended to progress quicker ), keeping club member score details of their progress can help their club peers to advise and teach them what and how to do certain skills to enable them to enjoy the game better and move up the levels.
"Please explain what you want to achieve with the spreadsheet."
Upon gathering the info required via the details collected on the spreadsheet it was hoped to use conditional formatting, sort etc.highlighting any trends which could be seen at a glance rather than having to study in greater detail.
Thank you once again for your reply and advice.
Apache OpenOffice 4.1.17 - Win 10 OS - PC Desktop
Re: Macro repeating same data in different named Tabs
Take a look at AutoIt, you might be able to create a script to carry out the operations including on the web page - will be some learning involved for AutoIt though.
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
Re: Macro repeating same data in different named Tabs
Thank you, JeJe I will check it out.
Apache OpenOffice 4.1.17 - Win 10 OS - PC Desktop