RE: extracting embedded or Ole Object data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Of course of course. You really don't have an Oleobject, you have a text
file that you want to extract certain strings. I have done this a lot. It
could get complicated depending on the file. If you post some of the text
file and specify what string you need extracted I wil get yyou started, maybe
even get the whole thing done depending on how complex the task is.

"SteveDB1" wrote:

Hi all.
I have need to pull text data from an embedded, or an OLE object I pull
from-- in this case-- an AutoCAD DWG file.
Thus far I've been going through the embedded element one line-item at a
time, and have finally gotten tired of it.
Is there a way to pull the information off of an embedded object within
excel?
I'm using Office2007.
Thank you.

.

Relevant Pages

  • Re: Extracting time from strings
    ... to hurt is in trying to determine the shift times in 24 hr format. ... Some rosters are 14 day, others are 28 although all will start on ... extract the employees name, position and section from the first columns. ... strings to extract the times. ...
    (microsoft.public.excel.programming)
  • Re: Extract text plus "n" characters or date on partial match
    ... Maybe starting from the same code I need to extract dates, first, ... extract the "rmd" strings. ... To extract the rmd strings as you write above, ... Dim i As Long ...
    (microsoft.public.excel.programming)
  • Re: Extract specific string
    ... Rick (MVP - Excel) ... Where do you want the extracted strings to go... ... > The string start always with "S" and finished with 8 digits and a VB ... Do the strings you are trying to extract ...
    (microsoft.public.excel.programming)
  • Re: 12 string question
    ... Most of the thin strings buzz. ... I certainly don't want to pull the bridge off my new guitar or mess up the ...
    (rec.music.makers.guitar.acoustic)
  • Re: Query on pattern matching
    ... I need to extract few strings from one file and paste it to another file. ... Since i am using spaces as delimiters here, i am facing problems. ...
    (perl.beginners)