PowerPoint Macros in VBA

Budget N/A
Bids 6
Average Bid $88

Specifications for PowerPoint Template modifications. Please provide a quotation and expected delivery date.


On creating a new presentation in PPT 2003 on using the Template:

An Input form to display asking:

Do you want to add the presenter’s name and date of presentation to the Title slide?

If user click’s no: remove bottom text box from Title slide which contains the words “Add name here Day Month year”.

If user click’s yes:
Display another input form with the following fields:

Date of presentation: ____________________

Presenter’s name: ____________________


Please control the date format to display as 3 June 2009 but not 03 June 2009 (ie month and year in full – single digit for 3). The user should be able to type 3 space 6 and when they tab to the next field date converts to the above format.

They should also be able to type: 3 Jun or 3 June or 3/6 and it should convert to the above format and default to the current year.

When the user click’s OK, the text box to be filled in with the results of the date and presenter’s name fields.

It is important that the code will run from anywhere in the presentation and it will insert the Presenter’s text box on the Title Slide only.

Accelerator keys for input fields.

Cancel button on input form.


The text box measurments are to be:

Position – horizontal 2.2 from Top left corner
Position – Vertical [url removed, login to view] from top left corner

Text box internal margin:
Left .25 Right .25 Top .13 bottom .13

No Fill No Line

Box [url removed, login to view] cm long to match one in ‘Remove text [url removed, login to view]’ template.

Font in text box:

‘Add name here plus 3 spaces using spacebar after this text’ = White Arial 25 point bold.
‘Day Month Year’ = Colour R150 G150 B150 Arial 25 point (regular)



New macro

Scenario
The user has now been working on the presentation for some time. They change their mind regarding having the Presenter’s name text box on the Title Slide and need to remove it. Or have removed it and now want to insert it again.

Is it possible to create code that will check the Title Slide and if the Presenter’s text box is present, delete it.

If the text box is not present, insert Presenter’s text box as per code above, displaying the input form for the fields etc.

The button to run this macro to be named: Show/Hide text box on Title Slide. Position the button on the Formatting toolbar to the right of the location of the default ‘New Slide’ button.


We recorded macros and stored in the ‘Remove text [url removed, login to view]’ file – this is what they are doing – they are to help you understand what we are wanting to achieve.
Macro3 – inserts text box on Title Slide.

This is a recorded macro – can you code as per above? Ie when the button
It is important that the code will run from anywhere in the presentation and it will insert the Presenter’s text box on the Title Slide only.

Macro 1 – Remove text box

This pre-recorded macro doesn’t work because the text box number is modified each time a new text box is added via Macro3.

Please create code that will consistently delete the Presenter’s text box (that has been inserted by Macro3 above) at the bottom of the Title Slide only.

New Macro

Create an autonew and autopen macro (or whatever is required) that will remove the New Slide button and Bullets button found on the Formatting toolbar in PowerPoint on creating a new presentation based on attached template or opening a presentation based on the attached template.

Create an autoclose macro (or whatever is required) that will on closing presentation based on the above template, reinstate the above buttons (ie reset the Formatting toolbar). This code will be added to three templates named: [url removed, login to view], [url removed, login to view] and [url removed, login to view] so must not refer to ‘Remove text [url removed, login to view]’ in the code.

_____
Please confirm how we distribute this code to end-user, ie. PPA or embedded in templates?

This peoject is urgent and must be completed within 7 days.

Post a Project Like This

This project was awarded to

johnsinit

John was great. He showed initial interest in the project and that is why I chose him. If you do a quick web-search, you will see he is extremely qualified for any type of CAD/3D engineering work. He was also able to provide suggestions and improvements for successful prototyping. He completed the project quicker than anticipated and performed very high-quality work. I will look to him for future CAD work and engineering questions. I highly recommend John.
About the Freelancer
johnsinit Profile Picture

After over 8 years in Engineering Industry, I have switched (4 years ago) towards programming (mostly VBA) and content writing. I am writing regularly for a credible knowledge website (Brighthub.com), online magazine (priceformmonthly), SEO-blog (seomoves.org/blog) and news-related website (hotnewsmakers.com). I have a degree in Aerospace Engineering with 8 years of experience in Aerospace and Mechanical Engineering. Working with SolidWorks, SolidEdge, Cimatron. Experienced Finite Element Analyst (both linear and non-linear structural, modal, thermal and multiphysics). ANSYS and FEMAP Expert in the above areas (including APDL). Also have experience with SW Cosmos and NX NASTRAN. Have knowledge and experience in writing MACRO's and templates for MS Office (EXCEL, WORD, Outlook etc.) - using Visual Basic for Applications (VBA). Expert in internet data extraction and data entry automation. Also familiar with programming in C, VB, Pascal, Html. Have experience in copywriting and translation: English, Russian and Hebrew.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • johnsinit Profile Picture

    johnsinit

    Haifa,  Israel

    After over 8 years in Engineering Industry, I have switched (4 years ago) towards programming (mostly VBA) and content writing. I am writing regularly for a credible knowledge website (Brighthub.com), online magazine (priceformmonthly), SEO-blog (seomoves.org/blog) and news-related website (hotnewsmakers.com). I have a degree in Aerospace Engineering with 8 years of experience in Aerospace and Mechanical Engineering. Working with SolidWorks, SolidEdge, Cimatron. Experienced Finite Element Analyst (both linear and non-linear structural, modal, thermal and multiphysics). ANSYS and FEMAP Expert in the above areas (including APDL). Also have experience with SW Cosmos and NX NASTRAN. Have knowledge and experience in writing MACRO's and templates for MS Office (EXCEL, WORD, Outlook etc.) - using Visual Basic for Applications (VBA). Expert in internet data extraction and data entry automation. Also familiar with programming in C, VB, Pascal, Html. Have experience in copywriting and translation: English, Russian and Hebrew.

    C Programming, Visual Basic, Copywriting, and Data Processing

  • srinichal Profile Picture

    srinichal

    hyderabad,  India

    Perfection and dedication are the way we deal with projects on freelancer. There have been many clients all over the world that are satisfied with the solutions provided.All types of automation works along with web based solutions are our expertise. Looking to provide solutions in the Mobile markets as well. Some of the automation tools are listed in portfolio and here as well: * AutoBidder tool for Madbid like sites * Automation tools For all emails and social Bookmark sites * Social Bookmarking tools * Facebook Likes Automation * Webbased Versions of tools tailored to custom needs * Desktop apps tailored to customer needs * Proxy tools tailored to your requirements. A dedicated team that can literally deliver any project solution with high expertise. Please don't hesitate to contact us via freelancer. Satisfaction guaranteed solutions delivered all over the world. The Skill Set ranges from C# to PHP, Iphone to Andriod. We can deliver almost any solutions for your needs. We can also take up any type of work based on web design to desktop or mobile in the broad spectrum as we always strive to learn and perfect.

    PHP, Perl, Java, and JSP

  • crajeshbe Profile Picture

    crajeshbe

    Chennai,  India

    Highly experienced professional in various technologies and who offers a wide range of services for your Internet business. I having expert level Knowledge in developing, server administration, linux and ethical hacking,I will do utmost to help you keep your business safe and secured. Admin services Offered: - Server management (Linux, Windows & BSD) - Initial server setup - Server Hardening - Server monitoring Security services Offered: - Web application security testing - Penetration testing - Ethical hacking - Secure coding programming -

    PHP, ASP, C Programming, and Javascript

  • ioanaprof Profile Picture

    ioanaprof

    Sibiu,  Romania

    I'm a professional full-time programmer, with 20 years corporate experience and a strong professional background maintained by a significant investment in professional development & training. Programming is my profession...and my hobby! I am expert in Google Apps, JavaScript, HTML5, CSS3. I am expert in VBA & MS Access & SQL, MS Excel, Power Point, Word. Also I am expertise in Networking, XML, FTP... Back office works, Data Processing, Data Entry, with high skilled. I am highly skilled in database knowledge namely Ingres, MySQL, MSSQL/ SQL Server, also. I can offer everything from design to implementation to support. I produce a professional product because that's what I am. I am motivated, dedicated and very creative. I am guaranteed with an on-time and within budget delivery of projects. Making your company successful is my focus. I listen to your ideas, take the time to learn about your business and work hard at putting my experience to work for you.

    PHP, Javascript, XML, and Visual Basic

  • nmppatel Profile Picture

    nmppatel

    EDISON,  United States

    PHP, ASP, JSP, and Javascript

  • arlee04 Profile Picture

    arlee04

    tarlac city,  Philippines

    C Programming, Adobe Flash, Visual Basic, and .NET