Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » CopyRecords Code - Anthony

CopyRecords Code - Anthony

ResolvedVersion 2007

Thu 5 Jul 2012, 09:36 Delegate Mark said...

Mark has attended:
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel PowerPivot course
Excel Dashboards for Business Intelligence course

CopyRecords Code - Anthony

Hi Anthony,

I'm having trouble with cannibalising the code from the VBA courseware. The interface runs, but the records don't seem to be copying.

Thanks,
Mark

Fri 6 Jul 2012, 20:06 Trainer Anthony said...

RE: CopyRecords Code - Anthony

Hi Mark, I'll need a bit more information than that I'm afraid. Is it crashing out of the code at all? If it is running but not bringing records across check you are passing the right values to strName or strMan.

Anthony

Fri 13 Jul 2012: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

CopyRecords Code - Anthony

CopyRecords Code - Anthony

RE: CopyRecords Code - Anthony

Excel articles

Excel tip:

Formula for last day of month