Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel courses - vba programs running microsoft

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » microsoft excel courses - VBA programs running in Microsoft SQL Server DTS package

microsoft excel courses - VBA programs running in Microsoft SQL Server DTS package

ResolvedVersion Standard

Gope has attended:
Excel VBA Intro Intermediate course

VBA programs running in Microsoft SQL Server DTS package

Is it possible to run VBA programs/macros in Data Transformation Services (DTS) Packages that are used in Microsoft SQL Server?

If so what code do I write in the DTS package to call a VBA program?

RE: VBA programs running in Microsoft SQL Server DTS package

i suggest you contact the office to have one of our vba specialsists talk to you

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.