+ Reply to Thread
Results 1 to 2 of 2

Need someone to program / help program a VBA / Excel Macro

  1. #1
    Registered User
    Join Date
    09-04-2013
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    1

    Need someone to program / help program a VBA / Excel Macro

    *NOTE: THE FILES/SCREENSHOTS MENTIONED BELOW CAN ALL BE FOUND AT THE BOTTOM OF MY POST*

    I would like to pay someone to do this for me. If this against forum rules, please delete and I will find the correct place to post. My example is vague and smaller scale than what I will eventually need, but it should get me someone who can do what I'll eventually require. PM me to discuss further, and to discuss a fee.

    What needs to be done:

    1) A prompt pops up, asking a series of questions. (e.g. What's the customer's name, what is the column for the input data, what is the start and stop row for relevant data...)About 15 questions or so, total.

    2) The "DestinationFile(Begin)" file is opened, the "quote" number is increased by an increment of one (In the example, Quote 1 would become Quote 2), the file is saved but left open.

    3) A "Source" excel file is opened (the exact file is designated in the questions from requirement 1), and the information is pulled from the rows/columns specified in requirement 1), and placed into the "DestinationFile(Begin)" file.

    4) The end result, would look like the "DestinationFile(End)" screen print.

    5) The "DestinationFile(End)" file is "saved as" both a PDF and Excel sheet, the name of the file to be whatever is located in the C1 cell...So in the "DestinationFile(End)", it would be Quote 2.pdf and Quote 2.xlsx respectively.

    6) A new outlook e-mail is opened, with the PDF created above as an attachment, the subject to match the C1 cell (Again, Quote 2 in this case). The e-mail address is whatever is asked in requirement 1, so in this case, [email protected]

    7) An Outlook task is set, 3 weeks from the date of "Quote 2" being sent, with the subject and body of the e-mail to be "Quote 2".

    That's all I can think of for now...I'm hoping this makes sense, but again, please PM me if you need more information.

    Thanks so much!

    Joe
    Excel/VBA Rookie

    DestinationFile(Begin).pngDestinationFile(End).pngSourceFile.png

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Need someone to program / help program a VBA / Excel Macro

    Joe,
    There is a fee based forum section . This is free-fee section. Go back to the main page and find the section and post it there.
    Link

    http://www.excelforum.com/commercial-services/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Controlling an outside program from excel macro
    By amotto11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2012, 09:04 AM
  2. excel macro basic program
    By pjiman1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2010, 11:27 AM
  3. Excel Macro/VBA Program That Converts To CSV
    By np123345 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-23-2008, 02:53 PM
  4. [SOLVED] help needed with excel macro program
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2006, 10:20 PM
  5. how do I run a macro program on Excel?
    By Michael in forum Excel General
    Replies: 3
    Last Post: 02-12-2006, 12:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1