How to have a scroll bar work on a Powerpoint Table?

[srpatel]

Hello,

I need to create a table in Microsoft PowerPoint 2007 which is capable of having a vertical scrolling bar. When I go Insert a table, I can't seem to integrate the scroll bar which is available in the VB toolbox with the table.

I have tried searching for solutions but have struggled to find a way forward.

The table has 7 columns and will have multiple rows added due to weekly results.

Using an Excel sheet has been tried but that means we loose graphics quality.

Any help would be appreciated.

Many thanks
SP

 

[SkipVought]

Hi,

"When I go Insert a table..."

How are you inserting your table?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[srpatel]

Hi Skip,

In Microsoft Powerpoint 2007 I go to the Insert Tab on the ribbon and select Insert Table. Drag my mouse over the number of columns and rows and the table gets populated.

If the table option does not work do I need to create a table with Vb code?

Or is there a way of using an Excel Spreadsheet with the scroll Bar?

Thanks
SP

 

[mintjulep]

Well, I suppose that to do what you are asking you would need to place the table behind some other shapes on the slide, forming a "window" to expose a part of the table. Then use the slider bar to change the POSITION of the table, thus exposing different rows.

I can't imagine why you would want to do this however.

PowerPoint is a presentation tool - not a data storage tool.

 

[SkipVought]

I would think that you'd have a database somewhere or even an Excel workbook with a TABLE to store the data.

The ScrollBar control is used to point to a "window" of data in the table, and that data then gets loaded in YOUR TABLE in the PP. When you scroll up or down, the pointer changes and the corresponding data from the table gets written to YOUR TABLE. That's how it works.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[combo]

As Skip suggested, you could store data in separate excel file. With WebBrowser control (ieframe.dll, SHDocVw library) and commandbutton on the slide, if both (powerpoint and excel) files are in the same directory:

Private Sub CommandButton1_Click()
Me.WebBrowser1.Navigate URL:=Me.Parent.Path & "\ExcelFile.xls"
End Sub

You can format excel cells and window.


combo

 

[srpatel]

Hi

Many Thanks for all the help above.

Combo, I added a WebBrowser control and a command box. However everytime i click the commnad button, a windows box pops up requesting me to open the excel file. If I click cancel the browser has the Page not Displayed error. If I click open the excel file opens up in Microsoft Excel 2007.

Is the above happening because i have not added the dll file? If so how do I add the Dll files in 2007 as I am finding it difficult to find.


Regards
SP

 

[SkipVought]

You actually have to QUERY the table, using ActiveX DAta Objects, and then map the resultset.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Or open Excel, read the table into an array, close Excel.

Then use the array to populate the table.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[combo]

The 'dll' file is necessary to create WebBrowser control, if you made it work, no other action required.
The solution above is similar to opening excel file in a web browser, actually it is a web browser control embeddeed in slide. When you click the button, the control opens excel file when the presentation runs.
I work with lower excel version, where I can see only formula bar and tabs bar. All except formula bar can be removed for single workbook/worksheet, so I it is possible to customise the worksheet and view and show it in a window with (excel) scrollbars. The customisation can be done directly in excel.


combo

 

[srpatel]

Hi,

Skip thanks for your suggestions. I may think of trying to use that.

Combo, what is the purpose of the web browser? Is not to open the excel file within the browser itself as opposed to opening the actual file in MS Excel.

The version of Excel and Powerpoint are 2007 but I can use the 97-2003 compatibility version.

Regards
Shreekant

 

[combo]

There are some pros:
- you can use it in powerpoint show mode (edit, scroll, navigate between sheets - CTRL +PgUp/PgDn when tabs hidden), in opposite to embedded excel,
- you separate data + report in excel file, what is easier to handle when data is changed,
- you do not activate browser.

combo