future queries

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Future queries.

Future queries.

resolvedResolved · Low Priority · Version 2003

Kanchan has attended:
Excel VBA Intro Intermediate course

Future queries.

Will i be able to get any guidance on particular databases related to my current job role in future?

RE: Future queries.

Hello Kachan

Thank you for your question and welcome to the forum.

You are welcome to post questions through relating to databases you are using at work, however it will depend on the amount of time that it would take to answer a post as to whether the forum would be an appropriate channel for us to provide assistance.

Kind regards
Amanda

RE: Future queries.

Hi Kanchan,

I have fixed the code and will send you the revised code in my next email.

In your mainMakeReport procedure you coded:

if blnPivot=true then call PivotAnalysis

It should have been:

if blnPivot=true then call PivotAnalysisMake

I also changed the name of the table in the MakeReport to Make Info.


Regards

Simon


Attached files...

Kanchan Dora Training file to be fixed for Make report.xls

Tue 23 Jun 2009: Automatically marked as resolved.

 

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:

Rotating Text in an Excel 2010 Worksheet

Maybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting!

One of the things you might consider is, rotating the text in a particular cell or set of cells.

1) Select a cell you would like to rotate
2) Click the ''Home'' tab in the Ribbon
3) Click ''orientation'' in the ''Alignment'' section
4) A pop up menu will appear with a few choices, if you want to decide yourself how many degrees to rotate the text, then click ''Format Cell Alignment.''

View all Excel hints and tips


Server loaded in 0.07 secs.