I have an excel file with the macro inside the Personal.xls vba
project, when I open the the file from vb6, it does not open the
vbaproject(Personal.xls), but, when I open the file anywhere else, it
show the vbaproject.

What could I be doing wrong in vb6 code.

Your help will most be appriciated.

When Excel is opened via automation it does not open any workbooks or add-in
automatically. You would have to add code to your app to open specific
workbooks.

--
Jim Rech
Excel MVP
"Diehard" wrote in message
om...
|I have an excel file with the macro inside the Personal.xls vba
| project, when I open the the file from vb6, it does not open the
| vbaproject(Personal.xls), but, when I open the file anywhere else, it
| show the vbaproject.
|
| What could I be doing wrong in vb6 code.
|
| Your help will most be appriciated.

Hi

How do I add code to open specific workbooks?

Regards

"Jim Rech" wrote in message ...
When Excel is opened via automation it does not open any workbooks or add-in
automatically. You would have to add code to your app to open specific
workbooks.

--
Jim Rech
Excel MVP
"Diehard" wrote in message
om...
|I have an excel file with the macro inside the Personal.xls vba
| project, when I open the the file from vb6, it does not open the
| vbaproject(Personal.xls), but, when I open the file anywhere else, it
| show the vbaproject.
|
| What could I be doing wrong in vb6 code.
|
| Your help will most be appriciated.

"Diehard" wrote in message
om...
Hi

How do I add code to open specific workbooks?

Regards

Dim xlbook as Excel.Workbook

Set xlbook = xlapp.Workbooks.Open("WorkbookFilename.xls")

Keith




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---