View Single Post
  #33   Report Post  
Posted to alt.computer,microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.printing,microsoft.public.excel.programming
Robert Baer Robert Baer is offline
external usenet poster
 
Posts: 93
Default Excel print object?

Paul wrote:
Robert Baer wrote:
Paul wrote:
Robert Baer wrote:
GS wrote:
* Page breaks will not show in a chart because a chart is "in
front" or overlays cells.

PageBreaks don't show at all; - they reside in the cell where they
are inserted!

** Furthermore, a chart can take a rather large number of cells
(C6..Q38).

** Again, what code is needed to print a chart?

Again, you can't print a chart (or any other object) apart from its
position on the worksheet. *Excel only prints sheet contents in
their respective location on a sheet*
* Not true; easy and simple when done manually:
* 1) Select the chart
* 2) File-- Print
* Done.

https://docs.microsoft.com/en-us/off...mbedded-charts


*** Paul

* No charts found; cannot work as-is.
* If i change the word chart to shape i can find 16 shapes, which is
correct; it is the 4th shape, but one the activate crashes.
* Then there is the problem of assigning a name to the print file.
* Noodling around on that site was worse than not trying.
* Tying the baby bird Goo-Gull,got nowhere.

* Once upon a time, in one version of Excel,this worked:
ActivePrinter:="Acrobat PDFWriter", PrintToFile:= True, PrintToFile:=
True, _
PrintOut Copies:= 1, Preview:= False, Collate:= False, _
PrToFilename:=pPath + vNam + ".PDF"

* Excel barfs.
* Also, i was able to derive the above sequentially, comma to comma or
entry to entry from a pulldown in Excel - i think in edit.

* No more; NO help even for ActivePrinter, were i started (i think).

* Thanks.


I tried to set myself up a trial version of Office 2003
to test, but that didn't work. Wouldn't activate.

What if you were to use the menus in Excel, to print the
entire document to PDF. So that you know all the
objects are in the document.

Then, use a PDF editor to re-arrange the content,
removing the parts you don't want.

You could try LibreOffice Draw as a PDF Editor of sorts.
Just print off one page as a test first, and experiment
with that.

** Paul

I certainly do not want to do manual fiddling for each desired result
200 times!
Do not like the idea even for one result.

So far, the best i have squeezed out is initially set Print Area
C12..Q66, use my program to calculate and place shapes in iobj.3, STOP
program, manually file/print/name, then continue so program can then
"erase" the work to restore original inserted picture.

Good for onseies but far from ideal.
Would be VERY nice to have Excel do that manual part.....

Thanks.