XLsheet Button Control to Lauch form the Public Drive

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am using Office XP Professional, outlook 2002.

I am designing a custom form, using the contact template. In this template I
have used a button control on a tab in my contact form to launch an XL ***.

I originally wanted to imbed an xl*** on the page in the template but I
couldn't get the code to work even with an amazing amount of help (thanks
again for all the notes Sue) to save the data. So I have opted for this
alternate solution.

The problem with this option is the command code launches the pre-set
XL-*** from the D drive of my computer. This contact form design is to be
used on the public drive and I would need the code to instruct the XL-***
to launch from the public drive so all who have access can get the same
information. Is this possible?

If it is easier to get working then I would go this route and forget my
original design. I have the code that launches from the D-drive for this
alternate option if it
helps? Can it be changed to launch an ex-*** from the public drive? If So
HOW? Please help, I am very lost with codes and it is quite outside of my
edcutation levels.

Sub GroupINFO_Click

Set objExcelApp = Item.Application.CreateObject("Excel.Application")
objExcelApp.Workbooks.Open("GroupINFO.xls")
Set objExcelBook = objExcelApp.ActiveWorkbook
Set objExcelSheets = objExcelBook.Worksheets
Set objExcelSheet = objExcelBook.Sheets(1)
objExcel***.Activate
objExcelApp.Application.Visible = True

End Sub

-
IT Girl

.

Quantcast