FP2000 Table manipulation using VBA

[Jason Wood]

Hello everyone,

I've been manually updating a table on my FP2000 page and now I'm
trying to write some VBA which I can execute with a Macro button.

At the moment I do the following tasks:
1. Paste the table from Excel onto my FP page.
2. Delete the hidden columns that re-appear when the table is pasted
in FP.
3. Highlight several columns one at time and click the right-align
button.
4. Highlight the whole table, click the Table properties and apply a
.gif background.
5. Click to format button and change the text to white, bold, size 10
(my .gif background is a green grass kind of thing!).

A Macro recorder would be a dream for this, but it isn't available in
FP :-(

Clearly, task 1. can be automated! My research has enabled me (on a
test page) to use the CommandBars() object and highlight the test grid
I created and make the backgound turn red (as a test). A small step,
but I see no way of applying my .gif file to the background.

Also, I'm slightly at a loss to how I go about creating the VBA to do
the above list of tasks, as a lot is done via dialogue boxes.

Sample VBA code for table manipulation seems to be thin on the ground.
Can anyone give me some pointers, some ideas, some literature on how
to automate my tasks.

Much appreciated.

[Stefan B Rusynko]

This visual basic programming group has been discontinued. The newsgroup
you are looking for is microsoft.public.frontpage.programming
- which you have already duplicate posted to
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Jason Wood" <***@hotmail.com> wrote in message news:***@posting.google.com...
| Hello everyone,
|
| I've been manually updating a table on my FP2000 page and now I'm
| trying to write some VBA which I can execute with a Macro button.
|
| At the moment I do the following tasks:
| 1. Paste the table from Excel onto my FP page.
| 2. Delete the hidden columns that re-appear when the table is pasted
| in FP.
| 3. Highlight several columns one at time and click the right-align
| button.
| 4. Highlight the whole table, click the Table properties and apply a
| .gif background.
| 5. Click to format button and change the text to white, bold, size 10
| (my .gif background is a green grass kind of thing!).
|
| A Macro recorder would be a dream for this, but it isn't available in
| FP :-(
|
| Clearly, task 1. can be automated! My research has enabled me (on a
| test page) to use the CommandBars() object and highlight the test grid
| I created and make the backgound turn red (as a test). A small step,
| but I see no way of applying my .gif file to the background.
|
| Also, I'm slightly at a loss to how I go about creating the VBA to do
| the above list of tasks, as a lot is done via dialogue boxes.
|
| Sample VBA code for table manipulation seems to be thin on the ground.
| Can anyone give me some pointers, some ideas, some literature on how
| to automate my tasks.
|
| Much appreciated.