Problem with opening excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wtpcomplab - 17 Feb 2005 00:53 GMT

I’m having problems getting the programming correct using an Access Form as a
front end to open an Excel Workbook. The workbook is already is in place, but
the customer wants Access for the front end.
My problem is I can’t figure out how to set the "on open properties" for the
workbook.
I need to have the have a worksheet open maximized, and I want to hide all
toolbars.

Below is the code I have set to call Excel.

Private Sub Command0_Click()

Dim xlApp As Object
Dim FleNme As String
FleNme = "L:OFFICE SKILLS\FRONT END - DATA ENTRY.xls"
Set xlApp = CreateObject("Excel.Application")
SendKeys "{LEFT}{ENTER}"
'xlApp.Open "L:OFFICE SKILLS\FRONT END - DATA ENTRY.xls"
Set xlApp = Nothing ' set the reference to nothing

End Sub

Reply to this Message

Dave Patrick - 17 Feb 2005 02:27 GMT

Send Keys is too unpredictable. Here's a couple of ways.

http://groups.google.co.uk/groups?hl=en&lr=&frame=right&th=52f833e4a1a8ae7e&seek
m=%23EcH3D%24DFHA.2824%40tk2msftngp13.phx.gbl#link1

Ask them here about programmatically removing the toolbars for the active
workbook.

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.
public.excel.programming&cat=en_US_95c54890-3454-4fc6-b99f-9f2e75f4da08&lang=en&
cr=US

Signature

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

| I'm having problems getting the programming correct using an Access Form

as a

| front end to open an Excel Workbook. The workbook is already is in place, but
| the customer wants Access for the front end.
| My problem is I can't figure out how to set the "on open properties" for

the

| workbook.
| I need to have the have a worksheet open maximized, and I want to hide all
[quoted text clipped - 13 lines]
|
| End Sub

Reply to this Message