Author Topic: Excel OLE - Access data in linked OLE without source file  (Read 438 times)

0 Members and 1 Guest are viewing this topic.

alanjt

  • Needs a day job
  • Posts: 5337
  • Standby for witty remark...
Excel OLE - Access data in linked OLE without source file
« on: August 20, 2020, 09:58:39 AM »
I have a drawing with an excel OLE spreadsheet. I would like to access the data, but it will not open.
The OLE is linked instead of embedded and I do not have the source spreadsheet.

Is there any way to extract the data or convert the OLE to embedded?
Civil 3D 2019 ~ Windohz 7 64bit
Dropbox

cadtag

  • Swamp Rat
  • Posts: 1126
Re: Excel OLE - Access data in linked OLE without source file
« Reply #1 on: August 20, 2020, 03:02:47 PM »
maybe print to PDF, the copy the text from the PDF??
The only thing more dangerous to the liberty of a free people than big government is big business

alanjt

  • Needs a day job
  • Posts: 5337
  • Standby for witty remark...
Re: Excel OLE - Access data in linked OLE without source file
« Reply #2 on: August 26, 2020, 02:25:38 PM »
maybe print to PDF, the copy the text from the PDF??
Wasn't the most elegant method, but I was able to OCR the PDF and copy the text.
Thanks for the suggestion.

Still would be nice if there was a way to convert and OLE to be embedded, but I get why it wouldn't/shouldn't be possible.
Civil 3D 2019 ~ Windohz 7 64bit
Dropbox