VBA loop to create named .csv files for all worksheets and workbooks in a folder

Hi all I don't have a great deal of experience with VBA, but can usually muddl my way through. I have drawn a blank with the following, however. I have a folder containing multiple excel workbooks, all of which are o the same structure. The ...

Message posted on the May 5th, 2012 - 7:24 AM ET

VBA to create series of workbooks need to add code to skip creating a report if no lines meet criteria

Hi All, I need some assistance as where I'm at with this report is far beyond my level of knowledge and I'm hoping that someone can point me in the right direction. I've created a template that creates a report and displays variances based on the ...

Message posted on the November 30th, 2009 - 3:55 AM ET

VBA - loop that arranges rows

Hi I need to generate quite a few distinct "notices" (like more than 1,000 or so). The contents of the notices are already in excel cells, arranged as follows: each row contains the notice number, the message on the front of the notice, ...

Message posted on the June 24th, 2009 - 4:09 PM ET

Excel VBA Macro Training

VBA MACRO Training Visual Basic For Applications (VBA) & Macro Traning Microsoft Visual Basic for Applications (VBA, Macros) when use with Microsoft Excel can build powerful automated business tools quickl and minimum cost. If you sit in front ...

Message posted on the September 21st, 2012 - 3:35 AM ET

Create individualized employee email messages

We have a vendor who manages the web-based presentation of some required compliance training. To improve the process, we would like to send out an individualized URL to every employee (probably using their Employee ID in the URL) instead of the ...

Message posted on the April 19th, 2010 - 6:54 PM ET

How to use a combo box variable in a VBA module

I have an Access/Outlook Email Sending application in which am having a problem with and looking for help. In the application I have a form with combo boxes to select a group name (cboGroup), a Year (cboYear) and a Month (cboMonth). The purpose of ...

Message posted on the January 19th, 2010 - 4:51 PM ET

Create a collection of custom classes in another custom class

Greetings: I created two custom classes, clsEmployee and clsStaff. I want clsStaff to hold a collection of employee objects. When I try to instantiate clsStaff, VBA returns RTE 91 "Object variable or With block variable not set." ...

Message posted on the June 10th, 2011 - 1:49 PM ET

Create Graphs using VBA

Hello, I trying to implement a routine to create Powerpoint slides using a function from Microsoft Knowledge base 200551. There are 2 prolblems I am having with this that I'm hoping someone here can help. I have included the code from this site ...

Message posted on the March 30th, 2010 - 12:09 AM ET

Trying to create a list of prices from a web page

I haven't written an excel macro since the early days of macros. With that said I am trying to look up and update a number of prices from lumber retailers online and then post to an excel spreadsheet. I can probably fumble my way through creating a ...

Message posted on the September 3rd, 2012 - 12:05 AM ET

Runtime Error 1004 on Linest in VBA

I'm trying to create a VBA macro that calculates the coefficients/T-stats and R-square for each variable with in a regression. The trick is that I have 10 candidate independent variables and I'd like to be able to test each combination of these ...

Message posted on the July 27th, 2011 - 2:53 PM ET

VBA or Macro Help: Create new files based on dynamic text in a tab

I have 7 tables in a Word doc. Each table has a cell for "Owner". Suzy is the owner in 4 of the tables, John is the owner in 3. I want to loop through all possible owners (in this case, 2), find each table that belongs to them, and ...

Message posted on the January 13th, 2010 - 7:37 PM ET

Stuck on VBA Web Automation

Hi Folks I am having trouble trying to get VBA to click on an image on a web page. The HTML java code is as follows: (sendsmsform is a function) <!--<input type="button" name="submitsms" value="send your ...

Message posted on the September 6th, 2009 - 9:12 AM ET

Need VBA Help...adding and deleting 40 sheets

I'm stuck. I am hoping someone can point me in the right to resolve this. I am working on a project using Excel 2003. I am programmatically adding about 40 worksheets to the workbook, loading them with data from text files. I am using a hidden ...

Message posted on the August 5th, 2009 - 9:02 AM ET

VBA Takes Longer Each Time Through

I have a fairly simple VBA PowerPoint tool that reads in some data from an Excel worksheet and "charts" it by creating a new PowerPoint slide and then adding drawing objects, text boxes, etc to the slide, creating a simple schedule chart. ...

Message posted on the March 29th, 2010 - 1:49 PM ET

vba loop create