List open xls files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 05 Oct 2007 01:43 GMT

Hello

Is it possible to show a list of currently open excel files that the user
can then choose from which one to import information?

David

Reply to this Message

Alex Dybenko - 05 Oct 2007 08:29 GMT

Hi,
yes, you can, once you get a reference to excel.application object - check
it workbooks collection

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

> Hello
>
> Is it possible to show a list of currently open excel files that the user
> can then choose from which one to import information?
>
> David

Reply to this Message

David - 06 Oct 2007 00:47 GMT

Hi Alex

I haven't worked with Objects before.
Can you let me know the process or point me to a place that can get me
started on what you are talking about here?

Thanks
David

> Hi,
> yes, you can, once you get a reference to excel.application object - check
[quoted text clipped - 6 lines]
> >
> > David

Reply to this Message

AnandaSim - 06 Oct 2007 01:36 GMT

> Hi Alex
>
[quoted text clipped - 4 lines]
> Thanks
> David

Have a look at the Office Automation helpfile:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c4f953c8-fbee-4164-b8e9
-589464f3fcad&DisplayLang=en

Reply to this Message

David - 06 Oct 2007 06:06 GMT

This is a very full resource. Thanks!

> > Hi Alex
> >
[quoted text clipped - 8 lines]
>
> http://www.microsoft.com/downloads/details.aspx?FamilyID=c4f953c8-fbee-4164-b8e9
-589464f3fcad&DisplayLang=en

Reply to this Message

David - 06 Oct 2007 07:05 GMT

Addendum

I have learnt a lot about Objects.
I still am having trouble seeing a list off all currently open Workbooks.

Also I would like to be able to grab a range out of the currently open
workbook without knowing the name.
What will happen is that the user will open an email attachment and in
access click an import buton to grab information from only that workbook.

Is this possible?

> > Hi Alex
> >
[quoted text clipped - 8 lines]
>
> http://www.microsoft.com/downloads/details.aspx?FamilyID=c4f953c8-fbee-4164-b8e9
-589464f3fcad&DisplayLang=en

Reply to this Message

Alex Dybenko - 06 Oct 2007 19:35 GMT

Hi,
yes, I think this is possible. Once you learn how to work with excel
automation - you will find how to do this

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

> Addendum
>
[quoted text clipped - 20 lines]
>>
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=c4f953c8-fbee-4164-b8e9
-589464f3fcad&DisplayLang=en

Reply to this Message

David - 07 Oct 2007 00:45 GMT

Thanks for pushing me.
I have really got into this and I have figured out my problem.
Still, issues, but I am learning a lot by playing around.
No dead-ends yet...

> Hi,
> yes, I think this is possible. Once you learn how to work with excel
[quoted text clipped - 24 lines]
> >>
> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=c4f953c8-fbee-4164-b8e9
-589464f3fcad&DisplayLang=en

Reply to this Message