Search results for query: *

Thanks!

Hi lynch or anyone available, Is this code to add to the workbook of the VB editor? Excel doesn't recognize the word SELECT. Thanks,

Hi Everyone, I would like to filter a column based on more than 1 citeria. When the criteria is meant I would like the filtered data to be copied to a new spreadsheet. For example: If I wanted to filter the data where the age is 20 and 30, then copy these rows to a new spreadsheet. A...

Thanks, I added Microsoft DAO 3.6 Object Library and it works. It does use an Access database. How do I ensure it will be readly for DAO?

I have tried to package the program. But, I receive the error that "These files are needed for this package but cannot be found. Click Browse to locate the file. "Setup.EXE". I tried browsing and selecting a setup.exe from another program and it will complete the package. But when I try to...

Hello, I am trying to make changes to some very old VB code. I made the changes and tried to set up an installation package. I received an error message that no "setup" existed. Is there a way to create a new setup ... not the project's exe? Thanks a lot, New Programmer

Hello, I am trying to make changes to some very old code. i am opening the program using VB6. I tried to run the code and receive the following error message. I don't see anything wrong. Any suggestions would be appreciated. Dim dbStat as Database Compile error: User-defined type not defined...

Thanks strongm for the suggestion on Feb 10. I didn't understand how it would work so I tried the other suggestion. I still don't understand the "Join(Split(Replace". After I set the reference gmmastros suggested and put my file name, it worked like a charm. HughLerwill thanks for your...

Hi, this helps a lot. But, the code only puts double quotes around the last field of the entire string. It does not add quotes to the last field of each line. Does anyone know why it is not working? Thanks! Here is the data in adpattendMOD... "XXX","BROWN","JOE","02/07/2006 05:53:00...

Thanks, I tried that and received a compile error message -"expected end of statement". I removed the $ sign when declaring and didn't receive an error msg. I am getting ready to test. Wish me luck. Dim a as String Dim b as String Dim c as String Dim d as String Thanks everyone!

Thanks gmmastros! How are the other variables suppose to be defined? a$ b$ c$ d$

Thanks everyone, HughLerwill, I really like your code and I am going to try it. I'll let you know how it turns out!!! Thanks again. Does anyone know what the Lof is for? a$ = input$(Lof(2),2) Thanks, New Programmer

Thanks, fredericofonseca: This is a file that is generated automaticaly from our Payroll system. I don't know if I could go back and change the file so that it would be made easier than just adding the quotes. HughLerwill: I don't understand some things about your code. My data is not fixed...

Hello Everyone, I have a flat file, which is comma deliminted. Each field has double quotes around it. Except for the last field in the file. The last field of the file has no double quotes weather there is text there or not. This causing a Run time error '62' input past end of file. So, I went...

Hello Everyone, Does anyone know how to print a user form in landscape? Below is the code that I am using. Private Sub cmdPrintGeneral_Click() Me.PrintForm End Sub Thanks, NewProgrammer

How do I install or reference the MS ADO Data Control 6.0 and Microsoft Data Grid Control 6.0? They are missing on the computers I am trying to run the program on. Is there a way to work around this problem?

Hello, I have added an ADO data control and a datagrid to my form by adding them to the toolbox and draging them to the form. This allows me to get data from a table and display it in the datagrid. The problem is that I have tried to run this program on two other Windows XP computers and the...

Hello Everyone, I am having two problems (that I am aware of) when closing my program. First, I have created an exit command button on a VB form. When the exit button is clicked, I need to close the VB form, Excel, and the Excel workbook. The code below leaves Excel open; however, it closes...

Thanks Todd, I moved the line objExcelapp.Visibile = True like you suggested and it worked fine.

Hello, I would like to open an excelworkbook (named strfile). The code will eventually open the workbook. But, before it opens the workbook it will display the error message that "MS Excel is waiing on another application to complete an OLE action". Does anyone know what is wrong with my code...