Button open worksheet

[Newbie_Movie]

Hello everyone,

I have searched the whole internet and many books for a issue about a button combined with excel but unfortunaly i cannot do it.

This is what i want:

I have a workbook (Excel) with 10 worksheet and a form with list box with items (same name of the 10 worksheets). I want that when i select a item in the list box and i hit the button right side (on the same form) then the workbook must open and go to the worksheet that has the same name of the item in the list box.

Can someone help me?

Greetings,

Michel

 

[namliam]

That shouldnt be to hard...

There are many samples on the forum to open and minipulate Excel from Access. A quick search should get you a long way.

 

[Newbie_Movie]

Unfortunaly it didn't help..

 

[namliam]

Try this:
http://www.access-programmers.co.uk/forums/showthread.php?t=147390&highlight=Call+Excel
Or
http://www.access-programmers.co.uk/forums/showthread.php?t=136976&highlight=Call+Excel

Either will get you started, just searched Call Excel and found these two.

If you have more specific questions, ask them again in this thread.
*lovely feature this search*

 

[Newbie_Movie]

It didn't help and answer my questions..

 

[Elie00]

Did u try the "link tables" option in the file menu?

File>Get External Data>Link tables

whenever u fill the tables in access they will be added to the excel file

hope this helps

 

[Newbie_Movie]

Did u try the "link tables" option in the file menu?

File>Get External Data>Link tables

whenever u fill the tables in access they will be added to the excel file

hope this helps

Hello Elie,

That is not my question. See my first post. Thanks

 

[namliam]

It didn't help and answer my questions..

How do those examples not help??? They contain pretty explicit examples of manipulating Excel from access???!!!

Both open a workbook and select a worksheet! How doesnt help?

 

[Newbie_Movie]

How do those examples not help??? They contain pretty explicit examples of manipulating Excel from access???!!!

Both open a workbook and select a worksheet! How doesnt help?

It didn't help i am not an advanced user.. my database-application is finished but i only need this part to Finished it totally. Could anyone help me please and explain to me how i can do this?

 

[twoplustwo]

Didn't this get solved in an epic thread the other week? Is this the same OP?

 

[namliam]

OK then copy paste from the code in the links:


'Start a new workbook in Excel
Dim oApp As New Excel.Application
Dim oBook As Excel.Workbook
Dim oSheet As Excel.Worksheet

Set oBook = oApp.Workbooks.Add
Set oSheet = oBook.Worksheets(1)

With some imagination, some trail and error and maybe recording a macro in Excel and looking at that ... You should be able to get ahead quite some way.

I am happy to help you along if you get stuck, but I am NOT going to give you "pre-fab" code you can copy paste.

 

[secretcrowds]

WWW.TEK-TIPS.COM