Opening Different Programs using Excel.

[ronaldo444]

I am not sure whether this is possible or not. I have created a front end screen so that I can open a series of spreadsheets I need throughout the day. However, there are a couple of problems I need help with.

1) Is it possible to open a 'Project' file using this front end?
2) Is it possible I can create it so that just the front end comes up rather than the spreadsheet it was created on.

Any help would be much appreciated.

[[email protected]]

When you say a front end screen do you mean a User Form in Excel?


ronaldo444 wrote:
> I am not sure whether this is possible or not. I have created a front
> end screen so that I can open a series of spreadsheets I need
> throughout the day. However, there are a couple of problems I need help
> with.
>
> 1) Is it possible to open a 'Project' file using this front end?
> 2) Is it possible I can create it so that just the front end comes up
> rather than the spreadsheet it was created on.
>
> Any help would be much appreciated.
>
>
> --
> ronaldo444
> ------------------------------------------------------------------------
> ronaldo444's Profile: http://www.excelforum.com/member.php...o&userid=36233
> View this thread: http://www.excelforum.com/showthread...hreadid=564672

[ronaldo444]

Yes, I am sorry if it was not clear. It's just that i need to get this sorted fairly soon as I am due to take on a managerial role at work and I will need to use these spreadsheets a lot.

[JonR]

Never tried it with Project, but here's some code that I use to open an MS
Access database. Might give you an idea. You might have to modify the
"oApp.OpenCurrentDatabase" line to suit MS Project.

Sub OpenAccess()

Dim LPath As String
Dim LCategoryID As Long

Application.DisplayAlerts = False


'Path to Access database
LPath = "C:\Reporting.mdb"

'Open Access and make visible
Set oApp = CreateObject("Access.Application")
oApp.Visible = True

'Open Access database as defined by LPath variable
oApp.OpenCurrentDatabase LPath

'Open form called Categories filtering by CategoryID
'LCategoryID = Range("A2").Value
'oApp.DoCmd.OpenForm "Categories", , , "CategoryID = " & LCategoryID

Application.DisplayAlerts = True

End Sub
--
HTH

JonR


"ronaldo444" wrote:

>
> I am not sure whether this is possible or not. I have created a front
> end screen so that I can open a series of spreadsheets I need
> throughout the day. However, there are a couple of problems I need help
> with.
>
> 1) Is it possible to open a 'Project' file using this front end?
> 2) Is it possible I can create it so that just the front end comes up
> rather than the spreadsheet it was created on.
>
> Any help would be much appreciated.
>
>
> --
> ronaldo444
> ------------------------------------------------------------------------
> ronaldo444's Profile: http://www.excelforum.com/member.php...o&userid=36233
> View this thread: http://www.excelforum.com/showthread...hreadid=564672
>
>