Summary: I do not know your answer but I do know that you are using the worksheet property instead of a workbook property so your macro is limited to the works...
Summary: You have to open an instance of Access from Excel VBA and then open the database to make your changes. You should get a book on VBA if you don't have...
Summary: I have failed to find a comprehensible method of writing data to a serial and parallel port on a PC using Excel VBA. I wish to send control code (ESC/...
Summary: Hi All, I want to take a loan. Following are the input details: 1) I want to pay EMI max upto 5000 per month 2) Terms in months = 60 (5 years) 3) Inte...
Summary: My first thought relates to how many profane words there are and how could you possibly check for every one, including variations (e.g. d*mn, sh!t, et...
Summary: Hello, I am having problems with excel VBA. I have a spreadsheet which will return a cell value of "Over Due" via a formula when certain information ...
Summary: Hi there! I'm just beginning the long road in learning VBA and already have an immediate need for some code that is quite beyond me. I have an excel w...
Summary: I have an excel programming problem I can't seem to get. I have a spreadsheet with the following cell formula that works fine: =IF(C20="","No Quote",...
Summary: I have an excel sheet containing a list of items by country, region and then town. I have given the user the ability to filter the list (using form dr...
Summary: Thanks, but please accept my novice knowledge which seems inadequate here. I tried your suggestion but am not getting the results. what do i put wh...
Summary: Your examples and explanation are excellent. What books or reference material can you suggest for someone who is not logically minded, but who would ...
Summary: Hi, I have a macro file in the old format (pre2003) that does a lot of complicated automated things. Since then (with help) I have developed some VBA ...
Summary: Hello, I am looking for an excel VBA script that scans my worksheet and will combine rows based on a duplicate value of a field. I have a customer s...
Summary: I've Excel VBA macros which repetitively open 100+ data files (no more than 4 open at once), do heavy number-crunching, save results, then do it all o...
Summary: Clomper, There are a couple of folks here on this board that are more familiar with VBA but I see they must be on vacation. If Jen's offering was not ...
Summary: Impossible? Not necessarily but I do not know how to do it. I have used a macro to find more than one occurrance using a VLOOKUP but you have the addi...
Summary: If your two worksheets contain only the Fans and Cars then the following will work to Combine the worksheets. The two worksheets must be in the same W...
Summary: From Excel VBA Help: Syntax expression.SpecialCells(Type, Value) expression Required. An expression that returns a Range object. Type Required Lon...
Summary: I try make adding form to add new person information into my regular personal form. I wish just click under name line, then adding form can come out. ...
Summary: hi i am havin a problem opening ams word document using a macro in excel this is the code i am using but it only opens word and dosent open the docume...
Summary: Geiri, I may not know how to accomplish what you are wanting but if it can be done then the folks at OzGrid's Excel/VBA forum board will know how. The...
Summary: Sam, I tried my code but it will only allow the selection of a single .txt file at a time. I suggest you post another thread asking the same question ...
Summary: Tony, I did not see your other request but have now. The formatting does not come out so good on this forum board. The macro was written by Derk at th...
Summary: I am assuming that you are getting a dialog box telling you that the workbook contains macros. If you "tried" to write the macro, then you probably ha...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
