Recent content by traveller4

We do something similar where I work. I use the file scripting object to copy the database (which is 50 megs) from a folder on the network to a folder on the users computer, when the user logs in. It takes about 5 seconds to copy on our network.

MrBill Thank you so very much for all your help. The GrpNum was the key. It work perfectly. If I could give you more than one star I would Thanks again

Mr Bill Sorry for the shading goes sideways" comment I should be more discriptive of the problem than annoyed by it. What I am after is a way to shade the parentgroup filename and its child personname as one area and then have the next set parentgroup filename and its child personname as not...

I have a report where the shading is working like it should. This report only has one grouping level which is "FileName". Now I have to have a secondary grouping level called "PersonName". When I add this grouping level the shading goes sideways. I am trying to shade in every other...

Thanks a million PHV That was exactly what I was looking for. Thanks again

Is there a way to get all open workbook names using VBA. Currently I have an Excel Workbook that is distributed to users that updates a workbook kept on the user's workstation. My problem is some users workbook's are not the required workbook name and the users never keep the workbook in the...

Thank for the response it is similar to what I did Set appExcel = CreateObject("Excel.Application") Set newBook = appExcel.Workbooks.open(strFullPath) Set oSheet = newBook.Worksheets iSheetCount= oSheet.count appExcel.quit If iSheetCount <> 5 Then f2.Copy (sBadSheetlPath)

Thanks PH It was what I was after. I was actually able to incorporate into a DTS package on SQL Server 2000. Thanks again

I am trying to load workbooks into a database that contain 5 required worksheets with distinct names contract contractorinfo contractdetails contractstatus validuntil These workbooks are supplied from outside sources. The problem is: not all the workbooks contain all 5 worksheets. The load...

Thank to both of you for the reply. That was I needed. APPRECIATE THE HELP Thanks again

I have a package that I designed through DTS designer and I saved a visual basic file, made the changes I needed. My question is: Is it possile to import the file back into SQL Server 2000 as a package without retooling it through DTS designer. Thanks in advance

PHV Thanks again for yous help I thought I tried Msg = lstSetCase.Column(1) & " - " & lstSetCase.Column(2) and got an error. Obviously I forgot Arrays are zero based Thanks again

I have populated a list box that has two columns. I want to display both columns in a message box but all that comes up is the first column Here is my load code Dim intrCount As Long Dim i As Long Dim arFill() Sheets("CaseSetup").Select Range("A2").Activate Set...

Thanks PH The ReDim worked perfectly for what I need Have a star for that one. --Thanks again

I have a user form in excel that has a list box. I am populating it with an array that has two columns. There are currently 12 records but this will increase over time. If I use the following code there is no error Dim intrCount As Long Dim i As Long Dim arFill(1 To 1000, 1 To...