Search results for query: *

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...

Thanks Skip The Insert/Name/Define was the key I was looking for. I looked in the FAQ's first but did not know about Insert/Name/Define table function as this is my first time at Excel VBA. Thanks again it was very helpful Definitely deserves a star

I have a blank user form which a user uses for data entry. I would like a combo box to load the values from a different worksheet in the same workbook. The worksheet is called called "BackorderName". I also need to have the list load alphabetically as the "BackorderName" worksheet is...

mmilan I have had a few hours today to figure this out and used your idea about the array. It works great. Thanks again for the hint and the idea certainly deseves another star --Micheal

strongm and mmilan Thanks for your assistance on this one. Due to time pressures I opted for an easy way out and created the second combo box to pass the parameter. I will try to go with your suggestions in the future when I have more time to apply to this problem Thanks again

strongm Thank you for your response. Forgive me for my ignorance but I am fairly recent to Visual Basic. The collection looks like it would work but I need to loop through the recordsets to populate the data as the MinistryID and Ministry Name are dynamic and changing all the time. Is this...