POV-Ray : Newsgroups : povray.off-topic : Reading .dbx files with Excel macros Server Time
2 Nov 2024 18:50:47 EDT (-0400)
  Reading .dbx files with Excel macros (Message 1 to 2 of 2)  
From: JWV
Subject: Reading .dbx files with Excel macros
Date: 24 Mar 2008 09:00:41
Message: <47e7b409$1@news.povray.org>
Hi all,

I have a question about reading .dbx files (OE mailbox files) with Excel 
macros.

I recieve mails generated by a webform and i want to write the data in excel 
sheet. Is there a way to acces .dbx files from Excel using macros? Or should 
I copy/paste the data manualy?

All help is appcreciated.

Jan

PS: No, i do not have acces to the webserver, so i can not write the data to 
a database of any kind.


Post a reply to this message

From: Phil Cook
Subject: Re: Reading .dbx files with Excel macros
Date: 26 Mar 2008 09:26:55
Message: <op.t8mnq3uec3xi7v@news.povray.org>
And lo on Mon, 24 Mar 2008 14:00:44 -0000, JWV  
<j.w.a.vaandrager|at|planet.nl> did spake, saying:

> Hi all,
>
> I have a question about reading .dbx files (OE mailbox files) with Excel
> macros.
>
> I recieve mails generated by a webform and i want to write the data in  
> excel
> sheet. Is there a way to acces .dbx files from Excel using macros?

Not unless you buy/write your own libraries. Unlike Outlook proper,  
Outlook Express doesn't use VBA so you've no internal 'handles' to  
manipulate its file store. You could use another language if it had  
built-in dbx support, but of the top of my head I can't think of any;  
others here may be of help there

> Or should
> I copy/paste the data manualy?

May be your only option, remember VBA does have the ability to 'grab' the  
contents of the clipboard so you could copy the data then run a macro in  
Excel to parse and store it.

-- 
Phil Cook

--
I once tried to be apathetic, but I just couldn't be bothered
http://flipc.blogspot.com


Post a reply to this message

Copyright 2003-2023 Persistence of Vision Raytracer Pty. Ltd.