Who knows about VBE???
 

'Cos I sure don't, and I need some help. I need to automate a process that will do calculations, then send the data to an Access database, then do more calculations, then send again, etc.

If someone can help, would they reply in this post, and I'll give them the details, ie the file locations etc etc, and they could write it for me? I am CLUELESS when it comes to VB, I want to learn, haven't had time yet.

I've tried some of those online excel/vb help forums, but they don't understand racing and therefore don't understand that this process needs to be done in Excel, and needs to be done HEAPS of times.

If anyone can help, it would be greatly appreciated. It wouldn't require a great deal of code. If no-one can, I understand too.

Thanks.

Great Idea !

It's been done.
You can purchase for around $20,000.00


Or,
Qoute/
I am CLUELESS when it comes to VB, I want to learn, haven't had time yet.

Enrol in programm courses and start learning.

Dude if you think that what I asked for would cost $20,000 then you've got your head up your you know what. I have written all the Excel stuff, just need someone to write the code that will do three things - calculate, refresh, send to Access. If that costs $20,000, then I know one thing, whatever you do for a living, I am glad I am not your client.

Actually, to further prove the point, a mate has introduced me to a programmer mate of his, he's doing it for me for a slab of beer. It'd want to be a good slab for 20 grand.

Durizt,
I think you have misunderstood my answer to your question.

However
For a slab of beer, perhaps you can auction your system, let's say, a slab of beer and a packet of twisties ?

Aah I see - yeah we have a miscommunication: I ain't selling (or buying) the method, I have already devised that, it's just a simple bit of programming I am after. You can have the Twisties all for yourself.

Duritz,
What are the codes you cannot find answers for ?

Here's a piece of code asked by someone I cannot find answers for, same reason, they (Excel Forum) do not seem to understand racing.

Sub Find_First()
Dim FindString As String
Dim Rng As Range
FindString = InputBox("Enter a Search value")

If Trim(FindString) <> "" Then
Set Rng = Range("A:A").find(What:=FindString, _
After:=Range("A" & Rows.Count), _
LookIn:=xlFormulas, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
If Not Rng Is Nothing Then
Application.Goto Rng, True
Else
MsgBox "Nothing found"
End If
End If
End Sub


I'll try and break it down.

Excel Sheet 1
Cell A1
Has a date always fixed in Sheet1 A1
But in Sheet 2 the same date may not be in Cell A1

They (the experts) say to type in the date where it says:

FindString = InputBox("Enter a Search value")

But that defeats the purpose because it's horse race and the dates keep changing.
The question, how is the code then written to find the fixed value of Sheet 1 A1 and find the same date or Value in Sheet 2 in whatever Cell it exists ?
Without having to type it in.

Is this the type of problems you get Duritz ?

Nah that's not it but thanks for trying. What I am attempting to do is append large amounts of data from Excel to Access. Essentially, Excel will calculate stuff from a race meeting, send the results to Access, then move onto the next meeting, calculate it, then send the results, so on and so forth.

You may try the other way round.
Append all your data to Access first, and take out what is required by Excel.
Then back to Access.
But I don't think Access is suited. There are other Databases around,but ofcourse that means starting from scratch.
BTW,
The above code was also just an example to.
There is a way to re-code a few lines and it will do the Find without having to type in the criteria. The point is though, you are correct when asking for code and such, but racing requirements I think is the least understood.

Hi Bluetown!
Sorry to butt in but this statement is just nonsense!
There is nothing in a database containing horse data that would make it unique.
As a matter of fact the fields are far easier to identify,and always the same type. Ie. just an example the name of Horse, venue etc is always a string, while the time ran is always single.
The approach taken by the poster by going to Excel then to Access then back again is very awkward to say the least.
Re. Acces not being the best, sorry it is the most suitable to use with Excel being from the same stable so to speak and sharing the same VBA language.
As to programming, again there is nothing in horseracing data that would make it specially hard to use.
Good luck with it.