For Steve Easton

A

AA Smith

Hi, again, Steve;

It seems as though I'm missing something somewhere. I opened an .xls file
in Excel, saved it as a .htm file (Excel 2003 would not let me save it as an
..html file) by clicking File>Save in Excel 2003. Then, I imported the saved
..htm file into the html folder in FP2002. But when I tried to drag the
..htm into an open page, it only allowed me to insert a hyperlink or open the
file, neither of which were what I wanted. All I need is to get the text
out of five columns in an Excel file. I don't want the file itself and I
don't want the file to serve as a web page.

How can I import or copy or duplicate by any means necessary to get the text
out of an .xls file into a single large cell of one page in FP2002?
--
With kindest regards,

Dick Smith
=================================================================================
with the Excel file open in Excel, click File > Save as, and then save the
page as html.
Then import the html page into your web.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer
 
S

Steve Easton

Aah, I thought you wanted the entire file.

To only get "part" of the text from an Excel file, highlight the part you want, copy, and then paste
into Notepad, and then copy and paste from Notepad to your web page.

You will probably have to do some formatting of the text afterwards.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer
 
S

Steve Easton

Or:
Copy and paste the "section" into a new .xls file, and then save the new .xls file as a html file.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer
 
A

AA Smith

Is there any way to do that and still maintain the separate column structure
that I have in Excel?
 
S

Steve Easton

The next answer should do it. "I think"

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer
 
A

Andrew Murray

you need to go File > Save As > web page.

AA Smith said:
Hi, again, Steve;

It seems as though I'm missing something somewhere. I opened an .xls file
in Excel, saved it as a .htm file (Excel 2003 would not let me save it as
an .html file) by clicking File>Save in Excel 2003. Then, I imported the
saved .htm file into the html folder in FP2002. But when I tried to drag
the .htm into an open page, it only allowed me to insert a hyperlink or
open the file, neither of which were what I wanted. All I need is to get
the text out of five columns in an Excel file. I don't want the file
itself and I don't want the file to serve as a web page.

How can I import or copy or duplicate by any means necessary to get the
text out of an .xls file into a single large cell of one page in FP2002?
--
With kindest regards,

Dick Smith
=================================================================================
with the Excel file open in Excel, click File > Save as, and then save the
page as html.
Then import the html page into your web.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
.......................with a computer
 
S

Stefan B Rusynko

FYI
Excel lets you save the selected range as a html page too




| Aah, I thought you wanted the entire file.
|
| To only get "part" of the text from an Excel file, highlight the part you want, copy, and then paste
| into Notepad, and then copy and paste from Notepad to your web page.
|
| You will probably have to do some formatting of the text afterwards.
|
| --
| Steve Easton
| Microsoft MVP FrontPage
| 95isalive
| This site is best viewed............
| .......................with a computer
|
| > Hi, again, Steve;
| >
| > It seems as though I'm missing something somewhere. I opened an .xls file
| > in Excel, saved it as a .htm file (Excel 2003 would not let me save it as an
| > .html file) by clicking File>Save in Excel 2003. Then, I imported the saved
| > .htm file into the html folder in FP2002. But when I tried to drag the
| > .htm into an open page, it only allowed me to insert a hyperlink or open the
| > file, neither of which were what I wanted. All I need is to get the text
| > out of five columns in an Excel file. I don't want the file itself and I
| > don't want the file to serve as a web page.
| >
| > How can I import or copy or duplicate by any means necessary to get the text
| > out of an .xls file into a single large cell of one page in FP2002?
| > --
| > With kindest regards,
| >
| > Dick Smith
| > =================================================================================
| > with the Excel file open in Excel, click File > Save as, and then save the
| > page as html.
| > Then import the html page into your web.
| >
| > --
| > Steve Easton
| > Microsoft MVP FrontPage
| > 95isalive
| > This site is best viewed............
| > .......................with a computer
| >
| > | > > I copied a rather sizeable (though not immense) Excel 2003 table into an
| > > FP2002 web page. After doing so, I find that FP responds very slowly with
| > > regard to any point-&-click, changes, scrolling and opening and closing of
| > > the page. So, apparently I've gone about transferring the table into FP
| > > the
| > > wrong way. There are 5 columns of text in that table, no formulas, just
| > > alphanumeric text. And that's all I need in FP, though I do need to
| > > maintain the existing columnar framework. Is there a better way to
| > > transfer
| > > a table from Excel than simply copying & pasting? If so, I'd greatly
| > > appreciate your help with this.
| > > --
| > > With kindest regards,
| > >
| > > Dick Smith
| > >
| > >
| >
| >
| >
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top