You have to do it cell by cell, just after you write data to cell format the table cell.
.Cell(lngY, lngX).Shape.TextFrame.TextRange.Font.Size = 10 '10pt font
.Cell(lngY, lngX).Shape.TextFrame.TextRange.Font.Bold = msoFalse 'make it NOT bold
So figured it out. I setup a means to prompt user for template file "pptfile" and then used the ".ApplyTemplate" to set the background of the new PowerPoint file being created. Not sure how to close this thread but can be closed.;)
.ApplyTemplate (pptfile) 'apply powerpoint template file...
Hello - simply trying to open an existing PowerPoint template and then add Access data to it. I started with microsoft automation vb code which opens a new file and addes data. In the code below I have noted the point where I get stuck and can't seem to add data to the existing file I just...