Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wordpad
I have an embedded wordpad which i can access as an oleobject in VBA. I am
completely unsuccessful and curious if I could read the contents of the embedded file. Once I have the file contents read, I am going to parse the information and direct the information to cells. I just need a direction and if the capability is feasible without writing a temp file and then reading a temp file from the filesystem. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wordpad
It appears possible. I just created a Wordpad object in Book1, typed in
"hello world", and then used the macro recorder to copy the text from this object to cell "A1". Here is what the macro recorder came up with... Sub Macro1() ActiveSheet.Shapes("Object 1").Select Selection.Verb Verb:=xlPrimary Range("A1").Select ActiveSheet.Paste End Sub "kee" wrote in message ... I have an embedded wordpad which i can access as an oleobject in VBA. I am completely unsuccessful and curious if I could read the contents of the embedded file. Once I have the file contents read, I am going to parse the information and direct the information to cells. I just need a direction and if the capability is feasible without writing a temp file and then reading a temp file from the filesystem. Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wordpad
"Mark Ivey" wrote: It appears possible. I just created a Wordpad object in Book1, typed in "hello world", and then used the macro recorder to copy the text from this object to cell "A1". Here is what the macro recorder came up with... Sub Macro1() ActiveSheet.Shapes("Object 1").Select Selection.Verb Verb:=xlPrimary Range("A1").Select ActiveSheet.Paste End Sub "kee" wrote in message ... I have an embedded wordpad which i can access as an oleobject in VBA. I am completely unsuccessful and curious if I could read the contents of the embedded file. Once I have the file contents read, I am going to parse the information and direct the information to cells. I just need a direction and if the capability is feasible without writing a temp file and then reading a temp file from the filesystem. Thanks, Another site convinced me to go to a texbox. As soon as I done with that I will retry this code. I was wondering if I could record the action with a macro.....great thanks! I am sure it will work.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Data To WordPad TXT File | Excel Discussion (Misc queries) | |||
Excel, WordPad and DDE | Excel Programming | |||
connecting wordpad and excel | Excel Discussion (Misc queries) | |||
WordPad file convert in Excel | Excel Discussion (Misc queries) | |||
exporting to wordpad? | Excel Programming |