Excel VBA to delete records in Access table and reset the Autonumber

Being a newbie to Access I would like clarification on the following Excel VBA code. The intention is to delete all records in Table1 in MyDatabase.mdb and reset the autonumber. Sub TableDeleteRecordsAndResetAutonumber() Set db = ...

Message posted on the October 9th, 2012 - 3:12 AM ET

Research and Markets: Hedge Fund Modeling and Analysis Using Excel and VBA

Dublin - Research and Markets (http://www.researchandmarkets.com/research/htcdg4/hedge_fund_modelin) has announced the addition of John Wiley and Sons Ltd's new book "Hedge Fund Modeling and Analysis Using Excel and VBA" to ...

Press published on the June 12th, 2012 - 5:08 AM ET

New Version of Excel Linear Stock Cut Optimizer from Optimalon Software Introduces Layouts Minimization and Automation Support

The new release of the linear stock-cutting optimization add-in (1DCutX) for Excel from Optimalon Software got two major improvements. Users can now minimize the number of different cutting layouts generated by ...

Press published on the March 28th, 2012 - 2:33 PM ET

Research and Markets: The Best Excel Tips & Techniques for Business Development Executives

Research and Markets (http://www.researchandmarkets.com/research/aa3dc5/the_best_excel_tip) has announced the addition of the "The Best Excel Tips & Techniques for Business Development Executives - What Other Business ...

Press published on the February 22nd, 2011 - 12:29 PM ET

Research and Markets: The Best Excel Tips & Techniques for General Counsel

Research and Markets (http://www.researchandmarkets.com/research/e71738/the_best_excel_tip) has announced the addition of the "The Best Excel Tips & Techniques for General Counsel - What Other General Counsel Find Most ...

Press published on the February 7th, 2011 - 9:22 AM ET

Research and Markets: Excel Tips, Templates & Money-Saving Techniques for Administrative Executives

Research and Markets (http://www.researchandmarkets.com/research/effc52/excel_tips_templa) has announced the addition of the "Excel Tips, Templates & Money-Saving Techniques for Administrative Executives" ...

Press published on the August 24th, 2011 - 6:45 AM ET

ebrary Announces New Corporate Computing E-book Collection

Corporations around the world can now easily and affordably provide unlimited, multi-user sales of an instant digital library of essential computing e-books that serve the practical information needs of both ...

Press published on the June 8th, 2011 - 6:00 AM ET

SkillSoft’s Books24x7 List of Popular Titles Reveals that Interest Continues in Cloud Computing and Tablets, Self-Help, Project Management, Business Analytics and Leadership/Management

Books24x7 Top Reads Indicative of Overall Business and IT Trends.

Press published on the September 20th, 2011 - 7:30 AM ET

How write into text file at first and last line with excel vba?

Hi, I need help to complete my project, thru excel vba i need to open text file. Inside this file contain text with CSV which is consist multiple line. The problem now I need to put something at 1st line and last line as a header and footer. Please ...

Message posted on the March 22nd, 2012 - 10:09 AM ET

Excel VBA - Using same code to apply to multiple textboxes on Userform

Hi Excel VBA'ers, Via Google I found some great code (see below) that enables MouseDown to paste what's in clipboard. I want this code to apply to ALL of the textboxes in my Userform. Instead of repeating this code multiple times for every textbox, ...

Message posted on the February 10th, 2011 - 9:03 PM ET

Excel VBA - How to maximize a minimized workbook - the workbook name is dynamic

Hi Excel VBA'ers, I am working with two workbooks (both have current date & time appended to their filenames every time the macro is run). One is active and the other is minimized. I need to know how to maximize the minimized one. I don't know ...

Message posted on the February 6th, 2011 - 5:22 AM ET

Excel VBA - Force 4 commas into a text field on userform

Hi Excel VBA advisers! I have a userform where there are two text boxes (drugdesc1 & drugdesc2) that I want to force 4 commas to be keyed into both fields. 4 commas are MANDATORY in each text box & are used to separate the type of input ...

Message posted on the February 2nd, 2011 - 7:58 PM ET

Referencing other Office programs in a Excel VBA App

I din't like the way my previous post sounded, so i'm reposting... All, My Excel VBA programming is decent enough when I'm only working with Excel. However, I'm trying to expand my knowledge base and frequently I wish I could better interact with ...

Message posted on the March 11th, 2010 - 11:24 AM ET

VB.NET with Excel VBA

I want to consider accessing the Excel Object Model from Visual Studio using VB.NET. Can the Excel Object Model be accessed from the Visual Studio VB.NET IDE in essentially the same manner as I currently do this from the built-in Excel VBA IDE? ...

Message posted on the October 7th, 2009 - 10:34 AM ET