Misc AC Cars+Tracks TecSpecs ExcelScanner v4.3

Please Stop This · Jul 21, 2020

Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

3.4 - 2020-07-21

-added more tyre info
-added simple string filter on "control" tab, affecting directory names
-"tags" columns are sorted now
View attachment 390792
View attachment 390793

Also included in this archive, so i can save the separate download:

IniReader v0.2 (v0.1 of it: -link-)
============
-added simple string filter on "control" tab, affecting directory names
-fixed some errors

Read the rest of this update entry...

Leonardo Ratafiá · Jul 22, 2020

I only get kunos tracks to display

Please Stop This · Jul 22, 2020

remove "ks_" here

Please Stop This · Jul 22, 2020

Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

3.5 - 2020-07-22

-fixed preview images
-fixed tyre info
View attachment 391014

Read the rest of this update entry...

Please Stop This · Aug 11, 2020

Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

2020-08-11

-added filtering by comma separated list
-added check for "race" or "street" tags exist for cars
-included again: excel 97 version

View attachment 397238
View attachment 397236

Read the rest of this update entry...

Please Stop This · Aug 30, 2020

Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

v3.7 - 2020-08-30

-fixed some "type mismatch" errors for some people, never had them myself

Read the rest of this update entry...

Please Stop This · Feb 6, 2021

Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

v3.8 - 2021-02-06

-fixed ers/kers info and tyre data
-added note in tyre-column if "default tyreindex wrong"
-made scanning for foldersizes optional (faster when disabled)
View attachment 442967

Read the rest of this update entry...

gfRally · Feb 16, 2021

ok, I have a ton of cars (2000+) and tracks, I am getting a couple of runtime errors when running the scan. Its stopping on this line:

defSectF = CStr(Round(sTyreDimF * 1000)) + " / " + CStr(Round5((sTyreRADF - sTyreRimRADF) / sTyreDimF)) + " x R" + CStr(Round(sTyreRimRADF * 1000 * 0.2 / 2.45 - 1.45, 1)) + "''"

Understandably with this many cars it may be struggling, but may be a simple fix. Love the idea.

Please Stop This · Feb 17, 2021

Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

v3.8a - 2021-02-17

internal version # not changed
-----------------
-fixed div by zero in cases

Read the rest of this update entry...

Please Stop This · Feb 7, 2022

Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

v4.0 - 2022-02-07

-fixes
-added feature to unpack "data.acd" on the fly
-added feature to open all the "data\...ini" files of a car in a new Excel file
+also adds simple LUT-diagrams
+either use one of two new big buttons
+or do a scan and click on the car-name column
(you will be asked to open "data\...ini" files in a new spreadsheet)
View attachment 538900
result of scan:
View attachment 538904
data\.....ini's opened:
View attachment 538901
-all sources included...

Read the rest of this update entry...

multilaf1967 · Feb 7, 2022

Please Stop This said:
Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

v4.0 - 2022-02-07

Read the rest of this update entry...

Hi I use Office 2021 64 bits and receive a VBA error when opening the excel file. For "Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long" I receive a compilation error saying that (I translate from French) the code in this project has to be updated for 64 bits system. Verify and update the Declare instructions , after mark it with attribute PtrSafe...possible to resolve my issue? Thanks

Please Stop This · Feb 7, 2022

multilaf1967 said:
Hi I use Office 2021 64 bits and receive a VBA error when opening the excel file. For "Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long" I receive a compilation error saying that (I translate from French) the code in this project has to be updated for 64 bits system. Verify and update the Declare instructions , after mark it with attribute PtrSafe...possible to resolve my issue? Thanks

Before an "official" update, can you please try this?

ACTecSpecs41_iniReader02.zip

drive.google.com

multilaf1967 · Feb 8, 2022

Please Stop This said:
Before an "official" update, can you please try this?

ACTecSpecs41_iniReader02.zip

drive.google.com

Many thanks for your prompt reply.
Unfortunately your new version does not work

Sub is highlight

Please Stop This · Feb 8, 2022

multilaf1967 said:
Many thanks for your prompt reply.
Unfortunately your new version does not work
View attachment 539195
Sub is highlight

ok i hope i fixed it now, want to try again (link) ?

multilaf1967 · Feb 9, 2022

Please Stop This said:
ok i hope i fixed it now, want to try again (link) ?

Yes it is better but for Cars, I have the following error message

Tracks no issue.
Thanks a lot.

Please Stop This · Feb 9, 2022

Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

v4.1 - 2022-02-09

fixes for 64bit Excel and replaced localized MRound function

Read the rest of this update entry...

multilaf1967 · Feb 9, 2022

Please Stop This said:
Please Stop This updated AC Cars+Tracks TecSpecs ExcelScanner with a new update entry:

v4.1 - 2022-02-09

Read the rest of this update entry...