Recent content by thelocaluk

Thanks mrmovie, it works a treat.

Hi, I use the following VB script to start my application CODE Dim objXL Set objXL = WScript.CreateObject("Excel.Application") objXL.WorkBooks.Open "\\Oxfsrv1\USERS\Common\Andre's Work Folder\IQuaTracker\IquaDemo.xls" I don't want this script to run if the applicaion is already open, how do I do...

Hi, I use the following VB script to start my application Dim objXL Set objXL = WScript.CreateObject("Excel.Application") objXL.WorkBooks.Open "\\Oxfsrv1\USERS\Common\Andre's Work Folder\IQuaTracker\IquaDemo.xls" I don't want this script to run if the applicaion is already open, how do I do that?

Cheers Skip :-)

Is there a way to automatically overwrite an existing workbook to avoid this message "WorkBook already exists, do you want to replace it?", without the need to select yes.

Thanks Mike, this is what I did If Me.cmbReason.ListIndex <> -1 Then If Me.cmbDes.ListIndex = -1 Then Me.cmbDes.SetFocus MsgBox "Please enter Description" Exit Sub End If End If Fumei, how do I go about adding an explanatory item to the top of a list?

I'm a bit lost for what I put in place of the ? in this code. I want to check if combobox1 selection has been made but combobox2 has no selection then to bring up message. If Me.cmbReason.Value = ? And Me.cmbDes.Value = "" Then Me.cmbDes.SetFocus MsgBox "Please enter Description" Exit...

I have tried that but I won't let me select to calculate at teh end of a month, only at date change

Hi everyone, I have an Excel form written in vb that adds data onto a sheet. How do I get subtotals automatically added to the sheet at the end of each month? Thanks

Thanks combo....Does the job, it's not the best solution but like you say this is as good as it gets.

Hi guys, with your help I've created a nice form in XL using VB code. I'm looking at giving it that professional look so I can distribute it around the company I work for. I would like it to look like a stand alone program if this is possible. At the moment I'm using the following code in the...