Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to get/set contents of embedded file using Excel OleObject
Hi all, I'm trying to read/write to a large embedded text file in an
Excel Worksheet. This file has too many columns for a regular sheet but is used to source a window of data in another Excel sheet. I understand that this embedded text file can be accessed using OleObject with the Excel object model. However, I would like to know how to read/write to this object using VBA, even if an additional COM component for streams needs to be written. Know the text could instead be saved in a Word document but this would be too heavyweight. Also know a Textbox could be used but not sure what the upper limitations are for this. Any ideas appreciated! Thanks Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating embedded powerpoint in excel file | Excel Discussion (Misc queries) | |||
Change and refresh OLEObject showing Excel chart on Access form. | Charts and Charting in Excel | |||
Is the Excel Version Number Embedded in a File | Excel Discussion (Misc queries) | |||
Playing a embedded wav file when excel opens | Excel Discussion (Misc queries) | |||
swf flash file embedded in html file which is edited in excel.. he | Excel Discussion (Misc queries) |