Exporting shape and sub-shape texts to Excel

[Paul Herber]

I'm retiring.

[Yacine]

I'm retiring.

Well, you could be the one who types in Chapt-GPT's orders in the PC.

[Yacine]

Our end will be when the AI reads the needs from internet activities of the end-users and offering them pro-actively solutions to the problems they haven't even formulate yet.


"I've detected that you're spending a lot of time on a chart for your boss, would like to switch to a 'speech-to-drawing' version? (See below the pricing table)"

[Paul Herber]

...  the needs from internet activities of the end-users ...

Apparently there is a large segment of the internet that provides for these needs. Or so I've been told.

[wapperdude]

Very interesting... but...

1) this is somewhat off topic now, so that can hinder those searching for solution to original post
2) this new info is of sufficient merit to warrant its own, focused topic.

What do you think?

[Yacine]

Sorry mr. W., that won't Happen again. 😆

[wapperdude]

@Yacine:  No worries.  It started as a BTW deviation, which often becomes a topic of its own merit.  This is one of those.  Considering the exponentially increasing interest in AI, it seems to me Visio Guy ought to add another category to the forum.

[Paul Herber]

@Yacine:  No worries.  It started as a BTW deviation, which often becomes a topic of its own merit.  This is one of those.  Considering the exponentially increasing interest in AI, it seems to me Visio Guy ought to add another category to the forum.

Last active here on 26th May.

[Nikolay]

Hi guys, I am just back from a chat with Chat-GPT. I am overwhelmed.
Have a read, it's worthwhile.
https://chat.openai.com/share/8b2bac74-19ac-499b-a2be-a30f80e2955e

Does the last solution really work? I have checked and VBA gives an error at the below line ("Object" is not allowed to have "WithEvents"). Maybe ChatGPT is simply hallucinating here?
I've seen before how it invents non-existing functions and non-working solutions... Maybe, there is still some room left for meatbags?

Code Select Expand

Private WithEvents visApp As Object ' Late-bound Visio Application object

You must declare WithEvents variables to be object variables so that they can accept class instances. However, you cannot declare them as Object. You must declare them as the specific class that can raise the events.

https://learn.microsoft.com/en-us/dotnet/visual-basic/language-reference/modifiers/withevents

The text in bold assumes early binding is required in VBA

[Yacine]

You're absolutely right. The conversation continues later on with many corrections. I'm now at a point where I gave up the late binding and trying early binding.

[LeighH]

Hello all, I am using the vba below in Excel which works to a point but some data overwrites itself when importing and I am not getting all text.
See example below attached

Example : MB-103-92-B Imports then gets overwritten by IE-2000-8TC-G-E

I have attached VBA code also (note, this is runinng from Excel)

Any help would be greatly appreciated.

[LeighH]

***Correction, some of the symbols it extracts the text but not all, any idea why?

[wapperdude]

You can copy/paste your code using the "#" formatting icon.  That way, your code can be copied and executed as written.  In addition, uploading simple Excel & Visio files would also help.

Finally, is there a reason to avoid early binding.  Late binding, unless required, brings many debugging issues.and other complications.

[LeighH]

Thanks for your reply :-)

Please see attached Excel Template and Visio document.

It is not pulling all text from Visio document and especially all the switch data "MB-******"

Thanks in advance for any help :-)

[wapperdude]

Can you upload just your code?  Use the # icon to paste code directly.