Problem with powerpoint range

  • Thread starter Thread starter excalibur
  • Start date Start date
E

excalibur

I'm trying to fill a powerpoint datasheet from an array that's been
filled with data from a database but get a 'Type Mismatch' error

The line I'm using is
oGraph.Application.datasheet.Range("A0:D5").Value=dataArry
dataArry is an array of Objects

I'm guessing it's something quite simple I just don't know what it is.
Any suggestions appreciated.

Thanks
 
Excalibur said:
I'm trying to fill a powerpoint datasheet from an array that's been
filled with data from a database but get a 'Type Mismatch' error

The line I'm using is
oGraph.Application.datasheet.Range("A0:D5").Value=dataArry
dataArry is an array of Objects
Click to expand...

1) Can't fill a data sheet with Objects, I don't think. Try something numeric
instead. Longs, Integers, Singles, Doubles ...

And if that doesn't help ...

2) Can you quote a bit more of the surrounding code? Enough that this can be
replicated elsewhere?
 
You must log in or register to reply here.

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

Similar Threads

Remove (or Hide) Points in a Graph with VBA 0
Setting the first row in a table in PPT using VBA 2
MS Office 2007 PowerPoint won't group tables + lines + equations 5
Excel VBA 1
Powerpoint charting from excel 1
Extracting data from Powerpoint datasheet/MSgraph to Excel 8
Excel chart does not visualize correctly in PowerPoint? 1
Controlling Excel range imported into Powerpoint 1

Back
Top