Excel!!!

[Anonymous]

Hello,

I am having a slight problem accessing excel.
Does anyone know how to access a specific excel file when excel is not open,
from vb.
I know how to open excel, and hide it, but I am not sure how to access a
specific file that I need info from.
Any help would be grateful!

Thanks,
Shaun

[Anonymous]

Hi Shaun,

Try this:

oXLApp.Workbooks.Open (sXlOpenName)

Where sXLOpenName is your fully qualified path/file, and oXLApp is from your
"GetObject" or "CreateObject".

Gary

[Anonymous]

Thanks Gary!

It worked great!
I was close to your code, but not quite the same.
Its amazing, one slight difference and things work properly.
Thanks again!

Shaun

"Gary McMaster" wrote in message
news:284AF30262AA4DC1D2AE72F0FB1E3DEF@in.WebX.SaUCah8kaAW...
> Hi Shaun,
>
> Try this:
>
> oXLApp.Workbooks.Open (sXlOpenName)
>
> Where sXLOpenName is your fully qualified path/file, and oXLApp is from
your
> "GetObject" or "CreateObject".
>
> Gary
>

[Anonymous]

It certainly can be stubborn.

Glad you got it running.