Excel object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Yes this worked.
I had applicaton.WindowState = xlMaximize that failed.
Removing the "application" was successful.

Much much thanks.
 
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
 
Back
Top