In Word under the File menu there is Properties section which shows things like Author, Comments, Category etc. for the file. I am looking for a way to automatically populate the Summary fields using VBA, but can't seem to find any methods available to do it.(they seem to be read only). Has...
If you haven't found out by now try using
ActiveChart.Shapes.AddLabel
This seems to use a different set of co-ordinate system than that used by the chart. Don't ask me why, it's a real pain.
I have written a VB application in Excel which automatically draws a diagram based on the data given in a worksheet. The problem I am having is that every time the drawing objects are deleted and a new figure generated, the objects (Lines, textboxes) are automatically named with an increasing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.