Advertisement

1 - 10 of 1042 containing alltags:("Excel VBA") (0.004 seconds)
Hi, I am pretty good with excel VBA but when it comes to opening excel through VB I fall flat on my face. Can someone guide me through the opening of excel and the basic manipulation of the applica...
Zones: Visual BasicDate Answered: 02/23/1998 Grade: A Views: 0
I am not sure whether Access or Excel would be best for this situation.  I have a listing (in Excel currently) of people along with their id and type code.  I need to make seating arrangements at 1...
Zones: Ms Office SuiteDate Answered: 05/21/1998 Grade: C Views: 0
This is the problem: A VBA process should assemble the registrations of a list that coincide in one of their fields and extract each group toward a new file. Then, in order to construct the criteri...
Zones: Ms Office SuiteDate Answered: 03/30/1999 Grade: B Views: 0
I need to be able to format some cells in Excel based on what number is typed in another cell.  Here's my example: If the number in Cell C3 is a 1, then I need it to shade cells Z9:AP9.  I also nee...
Zones: Visual BasicDate Answered: 07/27/1999 Grade: A Views: 0
I have 100 textboxs named textbox1 to textbox100 and I want to use a for loop to place values in the textboxs.  Is this possible?
Zones: Ms Office SuiteDate Answered: 08/16/1999 Grade: A Views: 0
ID         Org 789884     AA 092093     AA 809023     BB 093894     BB 988492     AA Above is an example of what the sheet looks like.  What I need is to filter by "org" and copy to another...
Zones: Ms Office SuiteDate Answered: 11/19/1999 Grade: A Views: 0
Through VBA, is it possible to save the open workbook/worksheet as a new file, *without* the userforms or macros that are contained within it?
Zones: Ms Office SuiteDate Answered: 11/06/1999 Grade: A Views: 0
After sending an Excel workbook to print the user will see a small dialog box informing them of the print progress (page no/total pages etc etc). I have incorporated a print routine into a small...
Zones: Ms Office SuiteDate Answered: 04/06/2000 Grade: B Views: 0
Hi, i need to know how to copy the data in cells as text and not with the extra formatting it usually copies as well. Basically, what I need to do is the same as copying a range of cells and the s...
Zones: Visual BasicDate Answered: 05/15/2000 Grade: A Views: 0
   Have an Access97 application that needs to load Excel97, load a Worksheet and set/unset options that will protect the worksheet from update and changes.  Also would like to create a "button" fo...
Zones: Ms Office SuiteDate Answered: 08/10/2000 Grade: C Views: 0