Search found 495 matches

by Phil Pendlebury
Sat May 21, 2022 6:55 am
Forum: Technical / Scripting
Topic: Reading from a Google Sheet
Replies: 3
Views: 3217

Re: Reading from a Google Sheet

btw. I should add here that HTTP Request works on a shared public sheet but the data is impossible to parse. It is just crazily complex and not regularly formatted.
by Phil Pendlebury
Fri May 20, 2022 6:46 pm
Forum: Technical / Scripting
Topic: Reading from a Google Sheet
Replies: 3
Views: 3217

Reading from a Google Sheet

Hi all, Is there any way to read from a Google sheet, other than manually copy pasting the data from the web URL, (which is not altogether bad for me, except users would struggle with the concept and interfere). Ideally I would like to do this in the background silently. (Well, with a message saying...
by Phil Pendlebury
Fri May 20, 2022 6:42 pm
Forum: Technical / Scripting
Topic: Finding duplicates in an array and adding figures... Puzzle
Replies: 12
Views: 4499

Re: Finding duplicates in an array and adding figures... Puzzle

Ok I will post to other threads. Thanks again guys:

Virus Warning Issue: viewtopic.php?f=2&t=11153

Scaling Issue: viewtopic.php?f=2&t=11161
by Phil Pendlebury
Fri May 20, 2022 6:42 pm
Forum: Technical / Scripting
Topic: Dealing with Windows Scaling
Replies: 4
Views: 2014

Dealing with Windows Scaling

I have an app that works fine on my system: https://i.ibb.co/HGrqXBY/2022-05-18-18-28-00.jpg But on a user's system it looks like this: https://i.ibb.co/7ny9449/lFPWPgtg.png Does anyone have any ideas how to deal with this? I noticed a thread somewhere that looked like it dealt with Windows scale si...
by Phil Pendlebury
Fri May 20, 2022 6:38 pm
Forum: Technical / Scripting
Topic: Virus Total False Positives
Replies: 8
Views: 5272

Re: Virus Total False Positives

Hi guys, I could really do with some guidance on this one please. :-)
by Phil Pendlebury
Thu May 19, 2022 3:58 am
Forum: Technical / Scripting
Topic: Finding duplicates in an array and adding figures... Puzzle
Replies: 12
Views: 4499

Re: Finding duplicates in an array and adding figures... Puzzle

Thanks for reading guys, The app is basically a folder/file parser on steroids. It is for Microsoft Flight Sim. It reads the data from all aircraft folders and gives a report on the hours you have flown in that aircraft. Some aircraft have different models, hence the need to use a lookup file which ...
by Phil Pendlebury
Tue May 17, 2022 6:36 pm
Forum: Technical / Scripting
Topic: Finding duplicates in an array and adding figures... Puzzle
Replies: 12
Views: 4499

Re: Finding duplicates in an array and adding figures... Puzzle

Ok I have got it in:

Code: Select all

ArrayCopy>ARRNICE,,Combined
And changed:

Code: Select all

Separate>value,=,item
Now I just need to get that back into an array instead of a continuous file so I can sort them.

Thank again guys.
by Phil Pendlebury
Tue May 17, 2022 6:21 pm
Forum: Technical / Scripting
Topic: Finding duplicates in an array and adding figures... Puzzle
Replies: 12
Views: 4499

Re: Finding duplicates in an array and adding figures... Puzzle

Thanks guys, JRL I think you have it. I think I have fried my brain though as I cannot get my array into that code. I have an Array let's call it "ARRNICE" Which contains the list of names and figures. Actually I can make this array contain the figures and the names OR the names and the figures as i...
by Phil Pendlebury
Tue May 17, 2022 2:26 pm
Forum: Technical / Scripting
Topic: Finding duplicates in an array and adding figures... Puzzle
Replies: 12
Views: 4499

Re: Finding duplicates in an array and adding figures... Puzzle

Quite ingenious Dorian, and funny that it crossed my mind if only we had some of the ini file features in regular file reads etc. I will have mess with this and let you know how I get on. Thank you for your time.
by Phil Pendlebury
Tue May 17, 2022 12:30 pm
Forum: Technical / Scripting
Topic: Finding duplicates in an array and adding figures... Puzzle
Replies: 12
Views: 4499

Finding duplicates in an array and adding figures... Puzzle

Hi all, I have battled over this for a while and it is time to ask for assistance. Scenario is this. I have an Array that contains names I have another Array that contains numbers Both arrays have the same amount of fields and they match in order. So as a (simplified) example: ARR1 ARR2 Chris 5.400 ...
by Phil Pendlebury
Sun May 01, 2022 10:16 am
Forum: Technical / Scripting
Topic: Virus Total False Positives
Replies: 8
Views: 5272

Virus Total False Positives

Hi there, I have small script that I have compiled. It is a freeware application. The community site that will distribute it requires 100% clearance from a Virus Total scan : https://www.virustotal.com/gui/home/upload I have uploaded a few times, including disabling UPX.exe and still there are a few...
by Phil Pendlebury
Wed Apr 20, 2022 3:14 am
Forum: Technical / Scripting
Topic: Naming Tabsheets
Replies: 11
Views: 4308

Re: Naming Tabsheets

Hi guys. Thanks for your attention and care. Please don’t worry about “fixing” this on my behalf, or bothering Marcus with it. I’m sure it’s out of scope and if it was possible, Marcus would have set it up originally. It’s honestly not a huge thing. If it was, the forum would be littered with questi...
by Phil Pendlebury
Tue Apr 19, 2022 1:28 pm
Forum: Technical / Scripting
Topic: Naming Tabsheets
Replies: 11
Views: 4308

Re: Naming Tabsheets

Yup as I thought, if you name a TTabsheet anything other than TTabsheet the tabs simply disappear. :)
by Phil Pendlebury
Tue Apr 19, 2022 1:25 pm
Forum: Technical / Scripting
Topic: Naming Tabsheets
Replies: 11
Views: 4308

Re: Naming Tabsheets

Hi Dorian,

Did you try this? (Sorry I am away from computer). I did previously try renaming TTabsheet1 etc. but I thought it failed.

I will test again. Thank you.
Sign up to our newsletter for free automation tips, tricks & discounts