O
Olaf Rabbachin
Hi folks,
a pretty strange project, really (interesting though
.
A client will receive (formats and optics varying) analytical data coming
from an intranet-site (HTML). On the page there'll be a button that will
simply copy everything being displayed into the clipboard.
There's loads of stuff (like tiny images) that's being unusable and will
have to be removed prior to being able to make any use of it.
I have now created a VB6-app along with an Access-DB that will handle all
those formatting issues by pasting the clipboard's contents into an
Excel-Sheet where i.e. rows will be removed, contents will be moved from
here to there, formats will be applied, etc. Thought that Excel would be
the simplest means to achieve that. That's fine already - after all the
stored changes have been applied, the Excel-instance will be shown and the
user will be able to handle additional changes if required. Upon closing
the workbook, my App will fetch back control and may go on and handle PP.
Here's where I'm getting lost: The ultimate goal is to have a
"ready-to-go"-presentation - which wouldn't be very hard as I could simply
copy'n'paste the sheet as a picture), but they would like to add hyperlinks
to certain cells within the sheet which should then lead to other slides.
So I thought I'd copy the excel-sheet into a table - but that seems like an
impossible task. Would there be any way of copying the sheet's contents
into a new table (created with as many columns and rows as there are on the
sheet) without loosing the formats (backcolor, fonts, column-widths and
row-heights, etc)?
Anybody dealt with something like this before?
Thanks for any suggestions!
Cheers,
Olaf
a pretty strange project, really (interesting though
.A client will receive (formats and optics varying) analytical data coming
from an intranet-site (HTML). On the page there'll be a button that will
simply copy everything being displayed into the clipboard.
There's loads of stuff (like tiny images) that's being unusable and will
have to be removed prior to being able to make any use of it.
I have now created a VB6-app along with an Access-DB that will handle all
those formatting issues by pasting the clipboard's contents into an
Excel-Sheet where i.e. rows will be removed, contents will be moved from
here to there, formats will be applied, etc. Thought that Excel would be
the simplest means to achieve that. That's fine already - after all the
stored changes have been applied, the Excel-instance will be shown and the
user will be able to handle additional changes if required. Upon closing
the workbook, my App will fetch back control and may go on and handle PP.
Here's where I'm getting lost: The ultimate goal is to have a
"ready-to-go"-presentation - which wouldn't be very hard as I could simply
copy'n'paste the sheet as a picture), but they would like to add hyperlinks
to certain cells within the sheet which should then lead to other slides.
So I thought I'd copy the excel-sheet into a table - but that seems like an
impossible task. Would there be any way of copying the sheet's contents
into a new table (created with as many columns and rows as there are on the
sheet) without loosing the formats (backcolor, fonts, column-widths and
row-heights, etc)?
Anybody dealt with something like this before?
Thanks for any suggestions!
Cheers,
Olaf