LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga
 
Posts: n/a
Default A questions of versions

Nel post
*Suze* ha scritto:

Hello all!
I am not a BIG excel user, so I only use an old copy of Excel 2000.
However, one problem has made me consider upgrading. When i copy
information into a block of cells, it is most important that excel
does not copy the formatting! It should keep the formatting of the
cells I am copying into. I know that you can select to copy text
only, but for some reason this just makes a mess if you copy more
than one cell. I am actually copying information from html encoded
emails into an excel worksheek. I can happily copy many cells at
once, from an html table directly into the worksheet, but it wipes
out the format of the cells I am copying in to. AARGH! So the
question is, if I buy a more recent copy of excel does this situation
improve?


No, I think it should be the same.

To import data in Excel from an HTML source I think the best way is the use
of a Web Query.

Now I don't know how/if Excel 2000 support this funcionality, so I explain
you as it is on Excel 2003.

From menu Data, Import External Data, New Web Query.

in the box Address type your URL and when the pages appear you can select
you want to copy by clicking on the little yellow square with an arrow (it
becomes green with a V) then you will click on Import.

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping status on posed questions in Excel Jaydubs Excel Discussion (Misc queries) 5 June 8th 06 05:08 AM
Excel - how can I practice formulas on financial questions? flamingformulas Excel Discussion (Misc queries) 4 February 20th 06 03:18 PM
Sharing worksheets between English and German versions Roger Nye Excel Discussion (Misc queries) 5 June 8th 05 01:49 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM
Need list of the different versions of Excel Ed Excel Discussion (Misc queries) 3 February 28th 05 06:25 PM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"