473,320 Members | 1,744 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Send and receive information between Excel/VBA and C

Hi

I use a large txt file of 1,5m lines which VBA reads into memory, and
then can searches certain values out of that data. Seach could be
faster and I wonder if c or some other language could be used for the
search engine.

So, Excel/VBA would send a variable and a big array to C, which would
search given variable from the array, and return much smaller array of
hits back to VBA.

Is this possible? How? Any kind of help needed

Regards, Jari
Dec 22 '07 #1
3 1587
On Dec 23, 5:03 pm, CBFalconer <cbfalco...@yahoo.comwrote:
I suggest you take a look at hash tables. I have published a
library for general use (GPL licensed, but other arrangements can
be made with me), written in portable standard C, which has various
features for portability. You can find it at:

<http://cbfalconer.home.att.net/download/>
If you are going to go this route why not use Apache Portable Runtime
library?

http://apr.apache.org/docs/apr/1.2/g...apr__hash.html

Ivan Novick
http://www.0x4849.net
Dec 24 '07 #2
On Dec 25, 11:28 am, CBFalconer <cbfalco...@yahoo.comwrote:
Ivan Novick wrote:
The advantage to using APR or some other widely used library, is
it has been peer reviewed and tested in production by many people
all over the world.

So has hashlib. I made a trivial adjustment last year. Before
that the last bug report was in 2002. I have had no further bug
reports. You obviously haven't looked at it.
My question is: is hashlib solely your code?

I am not doubting the quality of your code... but its different to
have a solution from a single developer available from their personal
site, than to have one from a relatively large and reputable
organization like the apache foundation.

If the code was at least available as a package in the major linux
distros (redhat, suse, debian, etc) than I would be fine with it.

Regards,
Ivan Novick
http://www.0x4849.net
Dec 26 '07 #3
Ivan Novick wrote:
CBFalconer <cbfalco...@yahoo.comwrote:
>Ivan Novick wrote:
>>The advantage to using APR or some other widely used library, is
it has been peer reviewed and tested in production by many people
all over the world.

So has hashlib. I made a trivial adjustment last year. Before
that the last bug report was in 2002. I have had no further bug
reports. You obviously haven't looked at it.

My question is: is hashlib solely your code?

I am not doubting the quality of your code... but its different to
have a solution from a single developer available from their personal
site, than to have one from a relatively large and reputable
organization like the apache foundation.

If the code was at least available as a package in the major linux
distros (redhat, suse, debian, etc) than I would be fine with it.
You are being ridiculous. The source is there, you can evaluate
the quality for yourself.

Before I wrote it I discussed the interface with various members of
the c.l.c group. This resulted in some interface modifications.
The code is mine. I issue the licenses. Everybody gets a free GPL
license.

--
Merry Christmas, Happy Hanukah, Happy New Year
Joyeux Noel, Bonne Annee, Frohe Weihnachten
Chuck F (cbfalconer at maineline dot net)
<http://cbfalconer.home.att.net>

--
Posted via a free Usenet account from http://www.teranews.com

Dec 26 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Robert Rossney | last post by:
I'm trying to send and receive XmlDocument objects using the System.Messaging.dll functions. The code I've written follows, as best I can tell, the methodology used in the sample code for the...
1
by: Kitchen Bin | last post by:
Hi. I am trying to use Sockets to do multiple Send and Receives via HTTP (not simultaneously). A first pair of Send/Receives works fine and sure enough I receive HTML back, but the next...
4
by: Sasha | last post by:
Hi, I need to send xml file to an asp page.. I have no idea how to do it... I only know that I need to do HTTPRequest Post... Could someone help? Maybe there are some examples on the Web? ...
13
by: Manfred Braun | last post by:
Hi All, I am trying to understand the blocking method socket.Send(). The call blocks as expected, but does this mean, it returnes after the underlying TCP layer got a confirmation, that the send...
2
by: Alpha | last post by:
Hi, I'm able to make connection to a server using socket connection. However, when I send a command string the server just ignores it. All command string needs to start with "0xF9" at Byte 0. ...
1
by: logambiga | last post by:
hai everybody, i want to know how to send an email notification from db2. I configured the smtp server also,but im not able to receive mails.please help me how to solve this.
2
by: SammyBar | last post by:
Hi all, I'm trying to send a message from ASP.NET to another PC by using MSMQ. I created my ASP.NET project by using Visual Studio 2005 but I initially set the project to be located on the File...
4
by: Joseph Geretz | last post by:
We use a Soap Header to pass a token class (m_Token) back and forth with authenticated session information. Given the following implementation for our Logout method, I vastly prefer to simply code...
2
by: Malli mindwave | last post by:
Hi, We are using the yahoowebHostiing service for my company website, In that one screen of the SendComments/FeedBack section is there, I'm basically dot.net develeoper ,but yahoowebhosting not...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.