Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

EMBEDDING MS EXCELL WRKSHT INTO ACAD

Status
Not open for further replies.

chicopee

Mechanical
Joined
Feb 15, 2003
Messages
6,199
Location
US
I HAVE FOUR PAGES IN SHEET 1 OF THE ABOVE REFERENCED SPREADSHEET THAT I AM TRANSFERRING INTO 2004 ACAD VIA OLE OBJECTS. ONLY ONE AND ONE HALF PAGE IS BEING TRANSFERRED. HOW CAN I TRANSFER ALL FOUR PAGES OF SHEET ONE INTO MY ACAD FILE.
 
As far as I know, you can't. There is a bit-limit to OLEs. You have to insert two separate OLEs or reduce the file size, by making the .xls smaller.
 
tHE ONLY SOLUTIOIN IS TO COPY AND PASTE THE DATA IN SECTIONS. WHEN YOU PASTE IT SET THE TEXT TO THE SAME SIZE AND THEN SIMPLY LINE UP THE LINES OF YOUR CHARTS.

THE MAJOR DRAWBACK IS THAT AutoCAD WILL THEM AS SEPERATE ENTITIES AND WHATEVER YOU EDIT IN ONE WILL NOT SHOW IN THE OTHER.:-(
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top