Excel object

B

Bret

My Access program opens up an Excel workbook and specific worksheet. I can't
get the Excel workbook to maximize on screen. It appears in the task bar but
it doesn't appear fullscreen or maximized over the Access program.

I've used the excel object in code with ".activate" and
"application.windowstate = xlmaximize" but still not working. Help please.

thanks in advance for your assistance.
 
M

M.L. Sco Scofield

Hard to say without seeing all of your code.

I just tried this and it works just fine. (It does require a reference to
Excel.)

'<CodeSample>
Sub OpenXL()

Dim xl As Excel.Application
Set xl = New Excel.Application

xl.Visible = True
xl.WindowState = xlMaximized

'*** Your code...

xl.Quit
Set xl = Nothing

End Sub
'</CodeSample>

Let us know if this works.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
B

Bret

Yes this worked.
I had applicaton.WindowState = xlMaximize that failed.
Removing the "application" was successful.

Much much thanks.
 
M

M.L. Sco Scofield

You're most most welcome.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Top