Can Access Hyperlink Maximize Excel workbook?

[UnsolvedCoding]

Hey all -

I am rather frustrated on this one. We have a couple of Access databases that house a table listing Excel workbooks. The Access tables have hyperlinks that when clicked open the correct workbook in Excel. The workbooks need to open maximized in Excel and so far nothing has been found to say how to do this.

Trying to resave the workbooks is out, there are over 100,000 on the server and the workbooks come from a client and are read only which means any Excel coding is out. Also, there are to many users to try and have them change the run properies with the Excel icon.

I have to find a way to have Access tell Excel to open a workbook as maximized when the hyperlink is clicked.

Anyone know how?

 

[tqeonline]

I'm not sure it's the solution however you can set Excel to always open Maximized by right click on the Programs Shortcut/Icon and clicking "Properties" then on the "Shortcut" tab there is a "Run" command and you can select "Maximized".

By default it is "Normal" which remembers the last state the window was in.

Do your links currently open Excel just not maximized?

- Matt

"If I must boast, I will boast of the things that show my weakness"

- Windows 2003 Server, 98 SE, XP
- VB.NET, VSTS 2010, ASP.NET, EXCEL VBA, ACCESS, SQL 2008

 

[UnsolvedCoding]

Can do the shortcut method because of the number of users.

I found this code online

Dim obXL As New Excel.Application
obXL.Visible = True
obXL.WindowState = xlMaximized
obXl.Workbooks.Open "Filename to open"
Set obXL = Nothing


However, I am not certain how to convert from a hyperlink to having a file open in such a manner that will keep the requirements in tact.

Right now the hyperlink shows the original document path and name, when clicked opens the document from its new location and when the mouse is hovered shows the documents name. I need all those features.

 

[tqeonline]

Can you get me an example of the hyperlink?

- Matt

"If I must boast, I will boast of the things that show my weakness"

- Windows 2003 Server, 98 SE, XP
- VB.NET, VSTS 2010, ASP.NET, EXCEL VBA, ACCESS, SQL 2008

 

[UnsolvedCoding]

Do you want an example that looks as it is created for import into the Access table or as it shows in Access?

 

[tqeonline]

as it shows in access - from my current understanding it seems that the link works just doesn't open as a maximized window - correct?

- Matt

"If I must boast, I will boast of the things that show my weakness"

- Windows 2003 Server, 98 SE, XP
- VB.NET, VSTS 2010, ASP.NET, EXCEL VBA, ACCESS, SQL 2008

 

[UnsolvedCoding]

Yes

 

[UnsolvedCoding]

There are a couple of parts that happen in Access -

This is what the user will see

C:\Month\Dept\Document\Workbookname.xls

This is what gets opened when the user clicks on the hyperlink.

\\Server\Directory\Folder\Subfolder\Workbookname.xlsx#Tabname!Cell_To_Activate

The "Screen Tip" as Access calls it is what happens when the mouse hovers and it is Workbookname.xls

 

[tqeonline]

Did you try making Excel default to maximized everytime a file is opened? (As i stated at the beginning?)

- Matt

"If I must boast, I will boast of the things that show my weakness"

- Windows 2003 Server, 98 SE, XP
- VB.NET, VSTS 2010, ASP.NET, EXCEL VBA, ACCESS, SQL 2008

 

[UnsolvedCoding]

Excel can not be set to default to maximized by using the shortcut properties method because of the number of users involved.