Search results for query: *

To decrease the size of a very large worksheet, I would like to decrease the DPI of pictures using VBA. These pictures are just B&W line drawings. What is a good way to do that? Thanks very much

I would like to use ADO in Excel, but when I try to use Dim conn as ADODB.Connection I get a compile error. I have added several references to my VBA macro, but I must not have found the correct one. Which reference(s) should I be adding? Thanks!

I do have all those at this time, but I am still getting the error on the New property of the DIM statement. "Invalid use of NEW Keyword" I have to work on another project at this time, but I will get back to this. I certainly appreciate all your help. C

Mike, I have never used ADO, but it looks like it will give me what I need. I am having trouble executing the code. I have looked through the websites you referred me to and also in the Microsoft Knowledge Base. They have showed me that I needed to add the following references to Excel...

Mike, I will check with the AS400 people which are 1200 miles from us. Unfortunately, I can not get onto the AS400 itself. The thing that is confusing to me is that I do get matches to the query. Sometimes all I do is add the table name prior to the field name, just to get more characters for...

Mike, I tried the simple SELECT as you stated 1. When I was less that 256 characters it returned 80 records. 2. As soon as I exceeded 256 characters, it returned no records. Here is my code databasename = "drg;USID=R_KIPFER;PWD=RR787410"...

Mike, Sorry, I was out of the office yesterday and today we have a vendor coming in for an all day meeting. I will try to test this during a break either today or 1st thing tomorrow morning. Thanks very much for your help. Ron

Mike, What happens is that when I add more than 256 characters to my Select statement, it doesn't return any information. As soon as I drop to 256 or less, I get the data I need. I have not printed the error message, since I know that 256 is the magic number. I wonder if it is a problem with...

I am writing SQL statements to accesss data from an AS400. They work very well, but there seems to be an upper limit of 256 characters for the SELECT statement. Is there any way around that? Or am I doing something wrong? Here is my statement. "SELECT...

I'm not certain if I am in the right forum or not, but here are my questions. Is it possible to convert AS400 RPG code into Microsoft .NET? If it is, does the conversion work fairly well or is there a lot of clean up afterward? Thanks very much.

Thanks for the suggestion. I did try it, but my computer still runs slowly. HOwever, when I moved to another computer the macro, with your suggestions included, ran very quickly. It is quite confusing. My new laptop is a Dell Latitude D505 with a 600MHZ Intel M Processor. This is supposed to...

I did add the command you suggested; however, I still have a problem. Possibly I am thinking incorrectly. I thought the following code would not populate the cells until I issues an Application.ScreenUpdating = True command. However, when running this code each worksheet is being updated as it...

Several months ago I started a thread when my excel macro was running very slowly. Some of you gave me very good advice. I have just upgraded to a new laptop and this macro is now running very slowly again. The two things that I did several months ago, using your advice, were the followng 1...

Thanks, I will try that.

I actually embedded the single quotes in Proj_Truncated, so 445566 now is '445566'.

I have been using a simple select statement in a VBA macro querystring = _ "SELECT Project_Number,Desc,Designer,Product_Type,On_Sale_Date,Product_Code,Pages FROM Filemaker WHERE (Project_Number=" & Proj_Truncated & ")" It has been working very well until now, when the Project_Number has now...

Thanks to all of you, it is now working! I have used the Declarations section statement, the string comparison and the LCASE and now the macro works well. Again, many thanks!

Sorry, I got tied up and did not respond to this earlier. I did try the LCASE and did get the same results. What I am trying to do is to look for company names from two different Excel spreadsheets. Both are sorted in ascending order using the normal Excel sort. However, when I use logic as...

I am having trouble with the following code. I am comparing two different worksheets and adding a record to one if it does not have a correspoinging vendor name. This logic seems to work, except for embedded apostrophies. At that time the > does not seem to work properly. Do I need to do...

A few months ago we came up with a form that prints a ticket for one job (one record in a job table). The form prints out very well and several customer service reps are using it. Now we have added a sub form which contains all the ship to names for each job. That could range from 1 to 10. The...