0

I am absolutely new at VBA. What I want to do is exactly same with this person Excel data into PowerPoint slides

  1. make slides at ppt for each row of excel
  2. make texts box at each slides for columns of each row

what's the problem is, while I tried this code (the page saying this is "a really weird thing to want to do" but this is what I really wanted for last 4 years...)

i got a error message saying

"Compile Error, syntax error"

highlighting

"Dim OWB As New Microsoft Excel:" (line 3)

(unlike the person above, who use Office 2011 on Mac, got error massage for line 4)

I am using Windows/office 365

Sathyajith Bhat
  • 62,374
Circle Example
  • 1

1 Answers1

0

This all certainly sounds very doable in VBA - you only have to find the correct magic set of windows / office object names to reference and ta-da it will work. Eventually.

Or perhaps not do it with VBA at all. Your problem sounded a lot like the "mail merge" feature in Word that pulls names and addresses from an excel file to automatically generate personalised letters to multiple recipients. I remember my mom doing this as a teacher in the 80's to write letters to parents... using lotus 123 and word perfect! And sure enough, someone else has already typed up a nice how-to for you: https://georgejmount.com/mailmerge/

The concept is quite simple:

  1. Insert Excel data into fields in Word outline using "Mail Merge"
  2. Import Word outline into PowerPoint using New slides > Slides from Outline
ExcelEverything
  • 3,194