Codes

A

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
 
T

Tom Ogilvy

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

so no, I doubt you can do that.
 
B

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)
 
B

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)
 
S

Steve Garman

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

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?
 
B

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)
 
Top