Thread
:
Excel should allow me to screen scrape the data only
View Single Post
#
5
October 18th, 2004, 02:25 AM
RWN
external usenet poster
Posts: n/a
In addition to the responses posted to you query.
I note that you said that you had some hidden data and did not want it
in the copy.
In that case you'll want to select "Visible Cells Only" before you copy
and paste.
Once you've highlighted (selected) the data to be copied;
"Edit-GoTo..-Special.." and select "Visible Cells Only" & ok.
Then Copy and Paste Special-Values only.
Ignoring this step will cause the hidden rows/columns to be pasted as
well.
--
Regards;
Rob
------------------------------------------------------------------------
"Les Ferrington" Les
wrote in
message ...
When dealing with business partners I have a need to send them price
lists in
excel format so they can 'use' the data meaningfully, however I don't
want
them to see all the underlying formulae and hidden rows/columns.
Right now I
have no option but to convert the spreadsheet into an Acrobat document
making
it less useful to them
What Excel needs is a way of deleting all the underlying formulae and
functions in a spreadsheet while keeping the visible data in the
spreadsheet,
a 'snapshot' if you will. I could then send the visble data to my
business
partners in 'usable' spreadsheet format. Does anyone know how to
achieve this
I am presently using Office 2003 but this comment applies to all
versions of
Excel
RWN