Re: [ExcelVBA] Handling of carriage returns from html or word

 

the specific workbooks and site no i can't but any site that has multi sentence
(ie line break) in one column  it's a blank sheet it's being pasted into where a
macro manipulates it after it's on the sheet .. it's getting it on the sheet
where the table cell on the html page is put into one cell on spreadsheet that
i'm working on.

i'll try the pase special but i do not think it's worked in the past...

thank you

________________________________
From: ashish koul <akoul.blogspot.com@gmail.com>
To: ExcelVBA@yahoogroups.com
Sent: Fri, July 8, 2011 9:26:52 AM
Subject: Re: [ExcelVBA] Handling of carriage returns from html or word

 
HI

have you tried using paste special as value .

can you share ur workbook and site if possible

Regards
Ashish

On Fri, Jul 8, 2011 at 6:04 PM, ohtechie <ohtechie@yahoo.com> wrote:

> **
>
>
> Hello everyone i've been banging my head off and on for a long while now on
> this problem and i hope someone can help.
>
> I have a couple of situations where i need to copy a table from different
> websites and put the information into a spreadsheet. the information in the
> table varies in size and punctuations. when i try to just copy and paste the
> returns with in the table cells cause excel to create new rows.
>
> same with trying to go through word the hard/soft returns cause multiple
> rows. so my current fix is to copy to word then replace the returns with - -
> then copy to excel...
>
> My question: is there a way to copy/import without the returns causing so
> much trouble?
>
> Thanks for any help or guidance.
>
> Keith
>
>
>

--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++

My Blog http://akoul.blogspot.com/

My Twitter http://twitter.com/#!/ashishkoul

Facebook Group http://www.facebook.com/ExcelLover

Facebook Page1 http://www.facebook.com/pages/Excel-Lovers/153712591367883

Facebook Page2 http://www.facebook.com/pages/Excel-Lovers/153712591367883

Facebook Page3
http://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/151803898222297

LinkedIn Group 1
http://www.linkedin.com/groups?gid=3111652&trk=myg_ugrp_ovr

Linkedin Group 2
http://www.linkedin.com/groups?gid=3111630&trk=myg_ugrp_ovr

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___