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...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10040188.html
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_100...
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_101...
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...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10187739.html
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?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_101...
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_102...
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?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_102...
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_103...
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...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10347465.html
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_104...
