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

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

so no, I doubt you can do that.

--
Regards,
Tom Ogilvy

"A1silsila" wrote in message
...
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

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)

"A1silsila" wrote in message
...
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

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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
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)

"A1silsila" wrote in message
...
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

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)

"Rob van Gelder" wrote in message
...
Can ADO really read source code from a closed Workbook? Amazing!

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
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)

"A1silsila" wrote in message
...
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

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

Bob Phillips wrote:

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.

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?


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
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)

"Rob van Gelder" wrote in message
...
Can ADO really read source code from a closed Workbook? Amazing!

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
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)

"A1silsila" wrote in message
...
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

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)

"Rob van Gelder" wrote in message
...
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?


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
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)

"Rob van Gelder" wrote in
message
...
Can ADO really read source code from a closed Workbook? Amazing!

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
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)

"A1silsila" wrote in message
...
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