SOLVED!
data transfer from calculation lists to word/excel/access
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2004-02-20 02:46 PM
2004-02-20
02:46 PM
to copy data from list and paste to word document. then replace spacebars
(press one time spacebar in 'find what' window) with nothing (dont touch 'replace with' at all) and replace 'I' with tab(one or more and it has to be copied from word doc. and pasted to 'replace with' ). than easyli it can be copied to table, excel or acces.
hope it will helpful.
Solved! Go to Solution.
Labels:
- Labels:
-
Data Exchange
1 ACCEPTED SOLUTION
Accepted Solutions
Solution

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2004-02-21 07:13 PM
2004-02-21
07:13 PM
Saving any Calc text output as text, and then opening in Excel specifying | as separator does even better job IMHO. The only replacement you have to do is insert formulas in the totals fileds.
Djordje
ArchiCAD since 4.55 ... 1995
HP Omen
ArchiCAD since 4.55 ... 1995
HP Omen
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2004-02-21 04:56 PM
2004-02-21
04:56 PM
I have found it very fast. easy and smooth to pre define an Excel workwook with all the appropriate sheets titles, cover sheet, fonts etc. and save the AC list as tabbed text... then import into the appropriate sheet and nothing else is required but saving as a PDF. An example can be downloaded at http://www.thompsonplans.com/plans/pages/details/1313A where it says "sample".
Solution

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2004-02-21 07:13 PM
2004-02-21
07:13 PM
Saving any Calc text output as text, and then opening in Excel specifying | as separator does even better job IMHO. The only replacement you have to do is insert formulas in the totals fileds.
Djordje
ArchiCAD since 4.55 ... 1995
HP Omen
ArchiCAD since 4.55 ... 1995
HP Omen