Re: Copying in table columns in 9

[Ken Poshedly]

I don't know if this is close to what you're doing, but I've had success with 
copying a table in Word or Excel, then pasting it as Rich Text Format directly 
into the FM doc.

Then I select the entire table and use Table  Table Designer and the other FM 
tools and techniques to make it look like I want to.

-- Kenpo in Atlanta






From: Robert Lauriston rob...@lauriston.com
To: framers@lists.frameusers.com
Sent: Mon, April 9, 2012 10:15:33 PM
Subject: Re: Copying in table columns in 9

I think that's more work than should be necessary, I'd try copying in
Excel, paste special in Word, copy, and paste in FrameMaker,
experimenting with various choices (HTML, RTF) when pasting in Word.

On Mon, Apr 9, 2012 at 10:20 AM, Writer generic...@yahoo.ca wrote:
 I can't test this idea completely at the moment, but...

 In Excel, save the file as HTM.
 Open the HTM file in Word, and then save as DOC.
 Copy or convert from DOC file.
___


You are currently subscribed to framers as poshe...@bellsouth.net.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/poshedly%40bellsouth.net

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.
___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

Copying in table columns in 9

[Ken Poshedly]

I don't know if this is close to what you're doing, but I've had success with 
copying a table in Word or Excel, then pasting it as Rich Text Format directly 
into the FM doc.

Then I select the entire table and use Table > Table Designer and the other FM 
tools and techniques to make it look like I want to.

-- Kenpo in Atlanta






From: Robert Lauriston <rob...@lauriston.com>
To: framers at lists.frameusers.com
Sent: Mon, April 9, 2012 10:15:33 PM
Subject: Re: Copying in table columns in 9

I think that's more work than should be necessary, I'd try copying in
Excel, paste special in Word, copy, and paste in FrameMaker,
experimenting with various choices (HTML, RTF) when pasting in Word.

On Mon, Apr 9, 2012 at 10:20 AM, Writer  wrote:
> I can't test this idea completely at the moment, but...
>
> In Excel, save the file as HTM.
> Open the HTM file in Word, and then save as DOC.
> Copy or convert from DOC file.
___


You are currently subscribed to framers as poshedly at bellsouth.net.

Send list messages to framers at lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscribe at lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/poshedly%40bellsouth.net

Send administrative questions to listadmin at frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.
-- next part --
An HTML attachment was scrubbed...
URL: 
<http://lists.frameusers.com/pipermail/framers/attachments/20120413/1ecd37f4/attachment.html>

Copying in table columns in 9

[Sharon Burton]

OK, all, I have a question. I have a long document in Frame 9 full of
tables. The client has decided they want to add one more column to each
table with content. The source for that content is Excel. 

 

I want to copy the column from Excel into a new column in Frame. But the
Copy won't let me paste special into a table column, even if the column in
the buffer is the same number of cells as the selected column. 

 

Thoughts? Workarounds? 

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#!/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton
http://www.linkedin.com/in/sharonvburton

 

 

___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

Re: Copying in table columns in 9

[Writer]

I can't test this idea completely at the moment, but...

In Excel, save the file as HTM.
Open the HTM file in Word, and then save as DOC.
Copy or convert from DOC file.

Just a thought.

Nadine





 From: Sharon Burton sha...@anthrobytes.com
To: 'FrameMaker Users List' framers@lists.frameusers.com 
Sent: Monday, April 9, 2012 1:06:26 PM
Subject: Copying in table columns in 9
 

OK, all, I have a question. I have a long document in Frame 9 full of tables. 
The client has decided they want to add one more column to each table with 
content. The source for that content is Excel. 
 
I want to copy the column from Excel into a new column in Frame. But the Copy 
won’t let me paste special into a table column, even if the column in the 
buffer is the same number of cells as the selected column. 
 
Thoughts? Workarounds? 
 
 
sharon
 
Sharon Burton
Content Strategy Consultant
951-369-8590
New book 8 Steps to Amazing Webinars available on Amazon and BN.com
www.sharonburton.com
IM: sharonvbur...@yahoo.com
Twitter: sharonburton
http://www.linkedin.com/in/sharonvburton
 
 
___


You are currently subscribed to framers as generic...@yahoo.ca.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/generic668%40yahoo.ca

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.


___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

RE: Copying in table columns in 9

[Sharon Burton]

I finally copied the table into a new Frame file, copy the column I need and 
then paste into the table in the frame doc I need. 

 

I was hoping someone had fewer steps. But it works and it’s only 40 or so 
tables. Sigh.

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#!/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

 

From: Writer [mailto:generic...@yahoo.ca] 
Sent: Monday, April 09, 2012 10:20 AM
To: sha...@anthrobytes.com; 'FrameMaker Users List'
Subject: Re: Copying in table columns in 9

 

I can't test this idea completely at the moment, but...

 

In Excel, save the file as HTM.

Open the HTM file in Word, and then save as DOC.

Copy or convert from DOC file.

 

Just a thought.

 

Nadine

 


  _  


From: Sharon Burton sha...@anthrobytes.com
To: 'FrameMaker Users List' framers@lists.frameusers.com 
Sent: Monday, April 9, 2012 1:06:26 PM
Subject: Copying in table columns in 9

 

OK, all, I have a question. I have a long document in Frame 9 full of tables. 
The client has decided they want to add one more column to each table with 
content. The source for that content is Excel. 

 

I want to copy the column from Excel into a new column in Frame. But the Copy 
won’t let me paste special into a table column, even if the column in the 
buffer is the same number of cells as the selected column. 

 

Thoughts? Workarounds? 

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#%21/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

 


___


You are currently subscribed to framers as generic...@yahoo.ca.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/generic668%40yahoo.ca

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.



___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

RE: Copying in table columns in 9

[Rick Quatro]

Hi Sharon,

 

If you find that this is a reoccurring task, I have a FrameScript script that 
allows you to select cells in a spreadsheet and corresponding cells in a 
FrameMaker table, and then copy the text from Excel to FrameMaker. If you are 
interested, please contact me offlist.

 

Rick

 

Rick Quatro

Carmen Publishing Inc.

*** 585-283-5045 *** NEW NUMBER

r...@frameexpert.com

http://www.frameexpert.com

 

 

From: framers-boun...@lists.frameusers.com 
[mailto:framers-boun...@lists.frameusers.com] On Behalf Of Sharon Burton
Sent: Monday, April 09, 2012 1:26 PM
To: 'Writer'; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9

 

I finally copied the table into a new Frame file, copy the column I need and 
then paste into the table in the frame doc I need. 

 

I was hoping someone had fewer steps. But it works and it’s only 40 or so 
tables. Sigh.

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#!/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

 

From: Writer [mailto:generic...@yahoo.ca] 
Sent: Monday, April 09, 2012 10:20 AM
To: sha...@anthrobytes.com; 'FrameMaker Users List'
Subject: Re: Copying in table columns in 9

 

I can't test this idea completely at the moment, but...

 

In Excel, save the file as HTM.

Open the HTM file in Word, and then save as DOC.

Copy or convert from DOC file.

 

Just a thought.

 

Nadine

 


  _  


From: Sharon Burton sha...@anthrobytes.com
To: 'FrameMaker Users List' framers@lists.frameusers.com 
Sent: Monday, April 9, 2012 1:06:26 PM
Subject: Copying in table columns in 9

 

OK, all, I have a question. I have a long document in Frame 9 full of tables. 
The client has decided they want to add one more column to each table with 
content. The source for that content is Excel. 

 

I want to copy the column from Excel into a new column in Frame. But the Copy 
won’t let me paste special into a table column, even if the column in the 
buffer is the same number of cells as the selected column. 

 

Thoughts? Workarounds? 

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#%21/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

 


___


You are currently subscribed to framers as generic...@yahoo.ca.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/generic668%40yahoo.ca

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

RE: Copying in table columns in 9

[Sharon Burton]

Thank you, Rick, but this is a one off for this client. Maybe once a year they 
need this done. 

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#!/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

 

From: Rick Quatro [mailto:r...@rickquatro.com] 
Sent: Monday, April 09, 2012 11:24 AM
To: sha...@anthrobytes.com; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9

 

Hi Sharon,

 

If you find that this is a reoccurring task, I have a FrameScript script that 
allows you to select cells in a spreadsheet and corresponding cells in a 
FrameMaker table, and then copy the text from Excel to FrameMaker. If you are 
interested, please contact me offlist.

 

Rick

 

Rick Quatro

Carmen Publishing Inc.

*** 585-283-5045 *** NEW NUMBER

r...@frameexpert.com

http://www.frameexpert.com

 

 

 

From: framers-boun...@lists.frameusers.com 
[mailto:framers-boun...@lists.frameusers.com] On Behalf Of Sharon Burton
Sent: Monday, April 09, 2012 1:26 PM
To: 'Writer'; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9

 

I finally copied the table into a new Frame file, copy the column I need and 
then paste into the table in the frame doc I need. 

 

I was hoping someone had fewer steps. But it works and it’s only 40 or so 
tables. Sigh.

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#!/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

 

From: Writer [mailto:generic...@yahoo.ca] 
Sent: Monday, April 09, 2012 10:20 AM
To: sha...@anthrobytes.com; 'FrameMaker Users List'
Subject: Re: Copying in table columns in 9

 

I can't test this idea completely at the moment, but...

 

In Excel, save the file as HTM.

Open the HTM file in Word, and then save as DOC.

Copy or convert from DOC file.

 

Just a thought.

 

Nadine

 


  _  


From: Sharon Burton sha...@anthrobytes.com
To: 'FrameMaker Users List' framers@lists.frameusers.com 
Sent: Monday, April 9, 2012 1:06:26 PM
Subject: Copying in table columns in 9

 

OK, all, I have a question. I have a long document in Frame 9 full of tables. 
The client has decided they want to add one more column to each table with 
content. The source for that content is Excel. 

 

I want to copy the column from Excel into a new column in Frame. But the Copy 
won’t let me paste special into a table column, even if the column in the 
buffer is the same number of cells as the selected column. 

 

Thoughts? Workarounds? 

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#%21/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

 


___


You are currently subscribed to framers as generic...@yahoo.ca.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/generic668%40yahoo.ca

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

RE: Copying in table columns in 9

[Rick Quatro]

No problem, Sharon. I just wanted you to know that almost any repetitive 
FrameMaker task like this can be automated. I have seen a lot of these kinds of 
tasks show up repeatedly over the last 14 years or so.

 

Rick

 

From: Sharon Burton [mailto:sha...@anthrobytes.com] 
Sent: Monday, April 09, 2012 2:38 PM
To: 'Rick Quatro'; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9

 

Thank you, Rick, but this is a one off for this client. Maybe once a year they 
need this done. 

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#!/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

RE: Copying in table columns in 9

[Sharon Burton]

And your scripts, etc are always exactly what I need and the cost is always 
very reasonable. If you all ever need any scripts from Rick, run right out and 
ask him. He’s the best. 

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#!/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

 

From: framers-boun...@lists.frameusers.com 
[mailto:framers-boun...@lists.frameusers.com] On Behalf Of Rick Quatro
Sent: Monday, April 09, 2012 11:50 AM
To: 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9

 

No problem, Sharon. I just wanted you to know that almost any repetitive 
FrameMaker task like this can be automated. I have seen a lot of these kinds of 
tasks show up repeatedly over the last 14 years or so.

 

Rick

 

From: Sharon Burton [mailto:sha...@anthrobytes.com] 
Sent: Monday, April 09, 2012 2:38 PM
To: 'Rick Quatro'; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9

 

Thank you, Rick, but this is a one off for this client. Maybe once a year they 
need this done. 

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

 http://www.sharonburton.com/ www.sharonburton.com

IM: sharonvbur...@yahoo.com

Twitter:  http://twitter.com/#!/sharonburton sharonburton
 http://www.linkedin.com/in/sharonvburton 
http://www.linkedin.com/in/sharonvburton

 

___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

RE: Copying in table columns in 9

[Owen, Clint]

Copy you new data from Excel into a separate single column table in the
same or a new FM document. Make sue the number of cells matches, then
copy and paste it into the target table.
 
Clint

 

Clint Owen | Sr. Technical Writer | Crane Aerospace  Electronics | +1
425 743 8674 | Fax: +1 425 743 8113

 



From: framers-boun...@lists.frameusers.com
[mailto:framers-boun...@lists.frameusers.com] On Behalf Of Sharon Burton
Sent: Monday, April 09, 2012 10:06 AM
To: 'FrameMaker Users List'
Subject: Copying in table columns in 9



OK, all, I have a question. I have a long document in Frame 9 full of
tables. The client has decided they want to add one more column to each
table with content. The source for that content is Excel. 

 

I want to copy the column from Excel into a new column in Frame. But the
Copy won't let me paste special into a table column, even if the column
in the buffer is the same number of cells as the selected column. 

 

Thoughts? Workarounds? 

 

 

sharon

 

Sharon Burton

Content Strategy Consultant

951-369-8590

New book 8 Steps to Amazing Webinars available on Amazon and BN.com

www.sharonburton.com http://www.sharonburton.com/ 

IM: sharonvbur...@yahoo.com

Twitter: sharonburton http://twitter.com/#!/sharonburton 
http://www.linkedin.com/in/sharonvburton
http://www.linkedin.com/in/sharonvburton 

 

 



Check out the new Crane Aerospace  Electronics Newsroom!
http://newsroom.craneae.com
Like us on Facebook!
http://www.facebook.com/home.php?#!/pages/Crane-Aerospace-Electronics/163305413682908

We value your opinion!  How may we serve you better? 
Please click the survey link to tell us how we are doing:
http://www.craneae.com/ContactUs/VoiceofCustomer.aspx
Your feedback is of the utmost importance to us. Thank you for your time.

Crane Aerospace  Electronics Confidentiality Statement:
The information contained in this email message may be privileged and is 
confidential information intended only for the use of the recipient, or any 
employee or agent responsible to deliver it to the intended recipient. Any 
unauthorized use, distribution or copying of this information is strictly 
prohibited 
and may be unlawful. If you have received this communication in error, please 
notify 
the sender immediately and destroy the original message and all attachments 
from 
your electronic files.

___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

Re: Copying in table columns in 9

[Robert Lauriston]

I think that's more work than should be necessary, I'd try copying in
Excel, paste special in Word, copy, and paste in FrameMaker,
experimenting with various choices (HTML, RTF) when pasting in Word.

On Mon, Apr 9, 2012 at 10:20 AM, Writer generic...@yahoo.ca wrote:
 I can't test this idea completely at the moment, but...

 In Excel, save the file as HTM.
 Open the HTM file in Word, and then save as DOC.
 Copy or convert from DOC file.
___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

Copying in table columns in 9

[Sharon Burton]

OK, all, I have a question. I have a long document in Frame 9 full of
tables. The client has decided they want to add one more column to each
table with content. The source for that content is Excel. 



I want to copy the column from Excel into a new column in Frame. But the
Copy won't let me paste special into a table column, even if the column in
the buffer is the same number of cells as the selected column. 



Thoughts? Workarounds? 





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

  www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:   sharonburton
 
http://www.linkedin.com/in/sharonvburton





-- next part --
An HTML attachment was scrubbed...
URL: 

Copying in table columns in 9

[Writer]

I can't test this idea completely at the moment, but...

In Excel, save the file as HTM.
Open the HTM file in Word, and then save as DOC.
Copy or convert from DOC file.

Just a thought.

Nadine




>
> From: Sharon Burton 
>To: 'FrameMaker Users List'  
>Sent: Monday, April 9, 2012 1:06:26 PM
>Subject: Copying in table columns in 9
> 
>
>OK, all, I have a question. I have a long document in Frame 9 full of tables. 
>The client has decided they want to add one more column to each table with 
>content. The source for that content is Excel. 
>?
>I want to copy the column from Excel into a new column in Frame. But the Copy 
>won?t let me paste special into a table column, even if the column in the 
>buffer is the same number of cells as the selected column. 
>?
>Thoughts? Workarounds? 
>?
>?
>sharon
>?
>Sharon Burton
>Content Strategy Consultant
>951-369-8590
>New book "8 Steps to Amazing Webinars" available on Amazon and BN.com
>www.sharonburton.com
>IM: sharonvburton at yahoo.com
>Twitter: sharonburton
>http://www.linkedin.com/in/sharonvburton
>?
>?
>___
>
>
>You are currently subscribed to framers as generic668 at yahoo.ca.
>
>Send list messages to framers at lists.frameusers.com.
>
>To unsubscribe send a blank email to
>framers-unsubscribe at lists.frameusers.com
>or visit 
>http://lists.frameusers.com/mailman/options/framers/generic668%40yahoo.ca
>
>Send administrative questions to listadmin at frameusers.com. Visit
>http://www.frameusers.com/ for more resources and info.
>
>
>
-- next part --
An HTML attachment was scrubbed...
URL: 
<http://lists.frameusers.com/pipermail/framers/attachments/20120409/0482662d/attachment.html>

Copying in table columns in 9

[Sharon Burton]

I finally copied the table into a new Frame file, copy the column I need and 
then paste into the table in the frame doc I need. 



I was hoping someone had fewer steps. But it works and it?s only 40 or so 
tables. Sigh.





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#!/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton





From: Writer [mailto:generic...@yahoo.ca] 
Sent: Monday, April 09, 2012 10:20 AM
To: sharon at anthrobytes.com; 'FrameMaker Users List'
Subject: Re: Copying in table columns in 9



I can't test this idea completely at the moment, but...



In Excel, save the file as HTM.

Open the HTM file in Word, and then save as DOC.

Copy or convert from DOC file.



Just a thought.



Nadine




  _  


From: Sharon Burton <sha...@anthrobytes.com>
To: 'FrameMaker Users List'  
Sent: Monday, April 9, 2012 1:06:26 PM
Subject: Copying in table columns in 9



OK, all, I have a question. I have a long document in Frame 9 full of tables. 
The client has decided they want to add one more column to each table with 
content. The source for that content is Excel. 



I want to copy the column from Excel into a new column in Frame. But the Copy 
won?t let me paste special into a table column, even if the column in the 
buffer is the same number of cells as the selected column. 



Thoughts? Workarounds? 





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#%21/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton






___


You are currently subscribed to framers as generic668 at yahoo.ca.

Send list messages to framers at lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscribe at lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/generic668%40yahoo.ca

Send administrative questions to listadmin at frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.



-- next part --
An HTML attachment was scrubbed...
URL: 
<http://lists.frameusers.com/pipermail/framers/attachments/20120409/e950a4a1/attachment.html>

Copying in table columns in 9

[Rick Quatro]

Hi Sharon,



If you find that this is a reoccurring task, I have a FrameScript script that 
allows you to select cells in a spreadsheet and corresponding cells in a 
FrameMaker table, and then copy the text from Excel to FrameMaker. If you are 
interested, please contact me offlist.



Rick



Rick Quatro

Carmen Publishing Inc.

*** 585-283-5045 *** NEW NUMBER

rick at frameexpert.com

http://www.frameexpert.com





From: framers-bounces at lists.frameusers.com 
[mailto:framers-boun...@lists.frameusers.com] On Behalf Of Sharon Burton
Sent: Monday, April 09, 2012 1:26 PM
To: 'Writer'; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9



I finally copied the table into a new Frame file, copy the column I need and 
then paste into the table in the frame doc I need. 



I was hoping someone had fewer steps. But it works and it?s only 40 or so 
tables. Sigh.





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#!/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton





From: Writer [mailto:generic...@yahoo.ca] 
Sent: Monday, April 09, 2012 10:20 AM
To: sharon at anthrobytes.com; 'FrameMaker Users List'
Subject: Re: Copying in table columns in 9



I can't test this idea completely at the moment, but...



In Excel, save the file as HTM.

Open the HTM file in Word, and then save as DOC.

Copy or convert from DOC file.



Just a thought.



Nadine




  _  


From: Sharon Burton <sha...@anthrobytes.com>
To: 'FrameMaker Users List'  
Sent: Monday, April 9, 2012 1:06:26 PM
Subject: Copying in table columns in 9



OK, all, I have a question. I have a long document in Frame 9 full of tables. 
The client has decided they want to add one more column to each table with 
content. The source for that content is Excel. 



I want to copy the column from Excel into a new column in Frame. But the Copy 
won?t let me paste special into a table column, even if the column in the 
buffer is the same number of cells as the selected column. 



Thoughts? Workarounds? 





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#%21/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton






___


You are currently subscribed to framers as generic668 at yahoo.ca.

Send list messages to framers at lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscribe at lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/generic668%40yahoo.ca

Send administrative questions to listadmin at frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

-- next part --
An HTML attachment was scrubbed...
URL: 
<http://lists.frameusers.com/pipermail/framers/attachments/20120409/1c2f1f66/attachment.html>

Copying in table columns in 9

[Sharon Burton]

Thank you, Rick, but this is a one off for this client. Maybe once a year they 
need this done. 





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#!/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton





From: Rick Quatro [mailto:r...@rickquatro.com] 
Sent: Monday, April 09, 2012 11:24 AM
To: sharon at anthrobytes.com; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9



Hi Sharon,



If you find that this is a reoccurring task, I have a FrameScript script that 
allows you to select cells in a spreadsheet and corresponding cells in a 
FrameMaker table, and then copy the text from Excel to FrameMaker. If you are 
interested, please contact me offlist.



Rick



Rick Quatro

Carmen Publishing Inc.

*** 585-283-5045 *** NEW NUMBER

rick at frameexpert.com

http://www.frameexpert.com







From: framers-bounces at lists.frameusers.com 
[mailto:framers-boun...@lists.frameusers.com] On Behalf Of Sharon Burton
Sent: Monday, April 09, 2012 1:26 PM
To: 'Writer'; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9



I finally copied the table into a new Frame file, copy the column I need and 
then paste into the table in the frame doc I need. 



I was hoping someone had fewer steps. But it works and it?s only 40 or so 
tables. Sigh.





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#!/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton





From: Writer [mailto:generic...@yahoo.ca] 
Sent: Monday, April 09, 2012 10:20 AM
To: sharon at anthrobytes.com; 'FrameMaker Users List'
Subject: Re: Copying in table columns in 9



I can't test this idea completely at the moment, but...



In Excel, save the file as HTM.

Open the HTM file in Word, and then save as DOC.

Copy or convert from DOC file.



Just a thought.



Nadine




  _  


From: Sharon Burton <sha...@anthrobytes.com>
To: 'FrameMaker Users List'  
Sent: Monday, April 9, 2012 1:06:26 PM
Subject: Copying in table columns in 9



OK, all, I have a question. I have a long document in Frame 9 full of tables. 
The client has decided they want to add one more column to each table with 
content. The source for that content is Excel. 



I want to copy the column from Excel into a new column in Frame. But the Copy 
won?t let me paste special into a table column, even if the column in the 
buffer is the same number of cells as the selected column. 



Thoughts? Workarounds? 





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#%21/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton






___


You are currently subscribed to framers as generic668 at yahoo.ca.

Send list messages to framers at lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscribe at lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/generic668%40yahoo.ca

Send administrative questions to listadmin at frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.

-- next part --
An HTML attachment was scrubbed...
URL: 
<http://lists.frameusers.com/pipermail/framers/attachments/20120409/037195a4/attachment.html>

Copying in table columns in 9

[Rick Quatro]

No problem, Sharon. I just wanted you to know that almost any repetitive 
FrameMaker task like this can be automated. I have seen a lot of these kinds of 
tasks show up repeatedly over the last 14 years or so.



Rick



From: Sharon Burton [mailto:sha...@anthrobytes.com] 
Sent: Monday, April 09, 2012 2:38 PM
To: 'Rick Quatro'; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9



Thank you, Rick, but this is a one off for this client. Maybe once a year they 
need this done. 





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#!/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton



-- next part --
An HTML attachment was scrubbed...
URL: 
<http://lists.frameusers.com/pipermail/framers/attachments/20120409/e785cb26/attachment.html>

Copying in table columns in 9

[Sharon Burton]

And your scripts, etc are always exactly what I need and the cost is always 
very reasonable. If you all ever need any scripts from Rick, run right out and 
ask him. He?s the best. 





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#!/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton





From: framers-bounces at lists.frameusers.com 
[mailto:framers-boun...@lists.frameusers.com] On Behalf Of Rick Quatro
Sent: Monday, April 09, 2012 11:50 AM
To: 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9



No problem, Sharon. I just wanted you to know that almost any repetitive 
FrameMaker task like this can be automated. I have seen a lot of these kinds of 
tasks show up repeatedly over the last 14 years or so.



Rick



From: Sharon Burton [mailto:sha...@anthrobytes.com] 
Sent: Monday, April 09, 2012 2:38 PM
To: 'Rick Quatro'; 'FrameMaker Users List'
Subject: RE: Copying in table columns in 9



Thank you, Rick, but this is a one off for this client. Maybe once a year they 
need this done. 





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

 <http://www.sharonburton.com/> www.sharonburton.com

IM: sharonvburton at yahoo.com

Twitter:  <http://twitter.com/#!/sharonburton> sharonburton
 <http://www.linkedin.com/in/sharonvburton> 
http://www.linkedin.com/in/sharonvburton



-- next part --
An HTML attachment was scrubbed...
URL: 
<http://lists.frameusers.com/pipermail/framers/attachments/20120409/87724c81/attachment.html>

Copying in table columns in 9

[Owen, Clint]

Copy you new data from Excel into a separate single column table in the
same or a new FM document. Make sue the number of cells matches, then
copy and paste it into the target table.

Clint



Clint Owen | Sr. Technical Writer | Crane Aerospace & Electronics | +1
425 743 8674 | Fax: +1 425 743 8113





From: framers-boun...@lists.frameusers.com
[mailto:framers-bounces at lists.frameusers.com] On Behalf Of Sharon Burton
Sent: Monday, April 09, 2012 10:06 AM
To: 'FrameMaker Users List'
Subject: Copying in table columns in 9



OK, all, I have a question. I have a long document in Frame 9 full of
tables. The client has decided they want to add one more column to each
table with content. The source for that content is Excel. 



I want to copy the column from Excel into a new column in Frame. But the
Copy won't let me paste special into a table column, even if the column
in the buffer is the same number of cells as the selected column. 



Thoughts? Workarounds? 





sharon



Sharon Burton

Content Strategy Consultant

951-369-8590

New book "8 Steps to Amazing Webinars" available on Amazon and BN.com

www.sharonburton.com <http://www.sharonburton.com/> 

IM: sharonvburton at yahoo.com

Twitter: sharonburton <http://twitter.com/#!/sharonburton> 
http://www.linkedin.com/in/sharonvburton
<http://www.linkedin.com/in/sharonvburton> 







Check out the new Crane Aerospace & Electronics Newsroom!
http://newsroom.craneae.com
Like us on Facebook!
http://www.facebook.com/home.php?#!/pages/Crane-Aerospace-Electronics/163305413682908

We value your opinion!  How may we serve you better? 
Please click the survey link to tell us how we are doing:
http://www.craneae.com/ContactUs/VoiceofCustomer.aspx
Your feedback is of the utmost importance to us. Thank you for your time.

Crane Aerospace & Electronics Confidentiality Statement:
The information contained in this email message may be privileged and is 
confidential information intended only for the use of the recipient, or any 
employee or agent responsible to deliver it to the intended recipient. Any 
unauthorized use, distribution or copying of this information is strictly 
prohibited 
and may be unlawful. If you have received this communication in error, please 
notify 
the sender immediately and destroy the original message and all attachments 
from 
your electronic files.

-- next part --
An HTML attachment was scrubbed...
URL: 
<http://lists.frameusers.com/pipermail/framers/attachments/20120409/f0d62f2e/attachment.html>

Copying in table columns in 9

[Robert Lauriston]

I think that's more work than should be necessary, I'd try copying in
Excel, paste special in Word, copy, and paste in FrameMaker,
experimenting with various choices (HTML, RTF) when pasting in Word.

On Mon, Apr 9, 2012 at 10:20 AM, Writer  wrote:
> I can't test this idea completely at the moment, but...
>
> In Excel, save the file as HTM.
> Open the HTM file in Word, and then save as DOC.
> Copy or convert from DOC file.