Codes

[A1silsila]

Hi All,

Is there a way to obtain or export codes from modules from a closed workbook.
The modules do not have password protection.

Thanks for your help.

A Silsila

 

[Tom Ogilvy]

for a start, how would you reference a closed workbook.

so no, I doubt you can do that.

 

[Bob Phillips]

If the data is structured, you could read it using ADO.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Rob van Gelder]

Can ADO really read source code from a closed Workbook? Amazing!

 

[Bob Phillips]

Yes, it is just another data source. There is an ODBC and an OLEDB Data
provider that can provide the access. You can even read text files, even
Active Directories.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Steve Garman]

Does this mean I have to rewrite my VBA in columns or is there some
other way of structuring it?

 

[Rob van Gelder]

I won't believe it until I see it
I've seen OLEDB pull data from worksheets cells, but have never seen OLEDB
pull VBA code from modules.

I would be interested in seeing samples which extracts VBA code from a
closed workbook. Which OLEDB provider handles this?

 

[Bob Phillips]

I think we are talking cross-purposes Rob<vbg>. I interpreted codes from
modules as data from worksheet modules, you (probably correctly now that I
read it again) as code (as in the collective singular) from VBE modules.

If you are right (probably correctly now that I read it again) forget what I
have said. I thought it odd that you were not aware of that <G>. Oh well,
all good fun.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)