Export all VBA code to text file

[grahamj42]

I have 2 versions of the same spreadsheet from a 3rd party.

The visual changes are easy to see but I need to check if there are code changes.

The logicical process seems to be to export all code from each app to a text file and the run the 2 text files through a file compare program.

Can this be done, please?

Graham

 

[riaanjbt]

Site cannot be reached

 

[Ruddles]

Which one? www.rula.pwp.blueyonder.co.uk or

 

[Spyros13]

There was a virus malware tojan ransome ware type thing & page horrible that came out of one these links.

Just letting admins know.

 

[Ruddles]

For the record, and to save anyone trying for themselves, it wasn't the Blueyonder site. That was mine and has been down for many years.

 

[Fluff]

For the record, the dodgy link has now been removed.

 

[Ruddles]

For the record, the dodgy link has now been removed.

Thank you. I didn't know you could do that. You may as well remove the other one, since it goes nowhere.

I know this thread is over a decade old, but I wonder if there's any value in posting my code for exporting all the VBA code from Excel/Access/Word files?

Or I could start a new thread?

 

[Spyros13]

Thank you. I didn't know you could do that. You may as well remove the other one, since it goes nowhere.

I know this thread is over a decade old, but I wonder if there's any value in posting my code for exporting all the VBA code from Excel/Access/Word files?

Or I could start a new thread?

Well I wouldn't complain!!!

 

[Fluff]

I know this thread is over a decade old, but I wonder if there's any value in posting my code for exporting all the VBA code from Excel/Access/Word files?

Sounds like a good idea to me.

 

[Ruddles]

Well I wouldn't complain!!!

I'll start a new thread with the subject line Exporting VBA code from Excel/Access/Word to text file. I'll drop you a PM with the link. I just need to add a few comments in the code in case anyone wants to hack it about. Couple of days max (he says).

 

[Spyros13]

Cool. Take your time. Knackered. It can wait. But I'd really appreciate it when / if you can.