Extract "Command Text" from Excel Data connection

I have 50 + Excel Macro reports that pulls data from SQL Server and SQL SERVER Cubes. I would like to pull the text from command text  data connection properties of excel file.
I tried google and found similar requirement but the solution was not quite working.
Appreciate your help
Who is Participating?
Nitin SontakkeDeveloperCommented:
Can you possibly post a mock file with just a couple of them, just to experiment with?

Something else came to my mind just as I type this, have tried saving your Excel file as an XML file? If that succeeds, rest all is very easy I guess.
IdleGuysAuthor Commented:
Thanks Nitin, I understand what you were referring to. I will try to convert the files to xml and commandtext tags to extract text. thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.