 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / February 2005Excel object
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 > 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 [quoted text clipped - 4 lines] > > thanks in advance for your assistance. Yes this worked. I had applicaton.WindowState = xlMaximize that failed. Removing the "application" was successful. Much much thanks. > 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 [quoted text clipped - 4 lines] > > thanks in advance for your assistance. 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 > Yes this worked. > I had applicaton.WindowState = xlMaximize that failed. [quoted text clipped - 10 lines] > > > > thanks in advance for your assistance. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.