Programming

Checking specific text string in excel files stored in a folder
Hi, I need to write a code that can do the following: 1) prompt user to select a particular folder 2) search for a particular text string, for e.g., ABCD in all the excel files in that folder (the number of files in the folder will vary and so does the names of the files). Is it possible to specify the string tha... 17 Mar 2010 21:13

active worksheet
Set wb2 = Workbooks("LESTER, BRENDA.xls") how do I replace the above code to set wb2 as the active sheet? ... 16 Mar 2010 00:09

Select range from ActiveCell do to Lastcell in ColumnA
Range("A10:M" & Range("A10000").End(xlUp).Row.Cut will cut a range from Cell A10 across to Column M and down to last cell in Column A How do you replace reference to Cell A10 with ActiveCell in Column A? -- Thank you Aussie Bob C Little cost to carry knowledge with you. Win XP P3 Office 2007 on Mini Mac u... 15 Mar 2010 19:30

How to use structured reference (ListColumns) in VBA
I want to do something simple...loop through a range retrieving values one at time and taking action on that value. This range is an Excel 2007 table column. Easy enough...BUT I want to use structured references to a table column by NAME, not numbers. I don't want to define new names, just use the table colu... 16 Mar 2010 13:58

Printing multi-page and multi-orientation excel tab to PDF
Could someone let me know if it is possible to print a multi-page tab in Excel to a PDF with multiple page orientations? Currently, I am setting the print area for each of the four pages and then printing each page seperatly to a PDF. Once complete I am combining each page into one PDF. I need all pages to pr... 15 Mar 2010 18:11

Fill column question
Hi group, I have a problem that I have seen similar answers for, but they are not specific enough to my problem. I have gotten close by looking at other examples, but I'm not having much luck modifying the code. What I would like to do is to create a macro that populates a certain column (J) from J2 to ... 15 Mar 2010 20:44

How do you set up backround with multiple pictures?
Thx everyone for any idea!!! I need to set up backround with multiple pictures because I have an application that requires to fill in 20 screens. I had a good ideea to make print screens as long as I go along the applications steps and set up the Excel Workbook' backround (Format/Sheet/Backround works only fo... 15 Mar 2010 17:01

Checkbox activate Combobox selection
I have a checkbox that when checked I want the user to select from a combobox and not by-pass until selection has been made. Any suggestions. Not realy a VBA programmer. Thanks in advance. ... 16 Mar 2010 11:25

macros disappear in Excel 2003
Macros I created using VBA code disappear in future sessions. They appear to have been created initially in the Personal Macro Workbook ... 15 Mar 2010 17:01

Dynamically Adding Textbox Control To Frame Object in VBA (Workshe
How do I add a textbox control to a frame object (declared as OLEObject) in vba code behind a worksheet? For example, I have tried the following that doesn't work... Dim objFrame As OleObject Set objFrame = ActiveSheet.OLEObjects.Add(ClassType:="Forms.Frame.1") With objFrame .Object.Controls.Add ClassT... 15 Mar 2010 15:51