Replies

Thanks a lot for the code snippet, I will test it and let you know if I run into problems.

Kislany

I am trying to run the code in Office 2003 right now.

Oups, sorry, I intended to post the error message, and I forgot.
I get ‘Run-time error ‘424’. Object required’

Kislany

Ok, thanks a lot for confirming.

Cheers,

K.

I think it is an msgraph type, when I click on the chart I have in the formula bar: =EMBED(“MSGraph.Chart”,””)

I am good at modifying existing code but I can’t, for the life of me, write a code from scratch. Thanks a lot again, it was a life saver

Thanks a lot, it works now. I’ve only changed to split based on spaces rather than “;” as the number right after the semicolon belongs to the first set of numbers.
Again, big thanks for such a fast and great help.

Thanks a lot, I did it, however the very first number got copied over and over, it ignored the rest of the numbers. Please have a look at the attached image… I cannot reattach the file as it’s over 100k already.
Thanks again!

Well, this is the file with the numbers in one cell. Converting to columns is not much help as it cuts off at the end of the last column. However if there is no easy solution to this, I am not sure how could I do it as my VBA knowledge is quite limited
Anyway, thanks for the comments.

Hans, so far this is perfect! I am sending the file to a few users to test it on their computers, to be sure it works in different environments, and will let you know of the outcome of if they get a problem with it, etc.
Once again big thanks!
K.

Thanks a lot for your quick reply. I ran the macro, and it added the very first chart, however it stopped there. I am attaching here a sample ppt file, maybe it is easier to see why it doesn’t continue?
Just a thought on the names, is it possible to give the chart types particular names, rather than the one specified in the macro, so that the users when they work on their own presentations and want to quick-format their own chart, will know which custom type to select from available names (ex. ‘trended line’ if it’s a line chart, ‘pie’ if it’s a pie chart, etc)

Thanks again,
K.

Please ignore, I found the setting. I accidentally clicked on the ‘picture placeholder’ in the Options menu.
Thanks for reading anyway.

K.

Please ignore, I found the setting. I accidentally clicked on the ‘picture placeholder’ in the Options menu.
Thanks for reading anyway.

K.

Ok, thanks a lot for the answer!

Regards,
K

Ok, thanks a lot for the answer!

Regards,
K