VBA EXCEL - TEMPLATE - open to bidding

ยกเลิก โพสต์แล้ว Jun 9, 2014 ชำระเงินเมื่อจัดส่ง
ยกเลิก ชำระเงินเมื่อจัดส่ง

Hi I really need expert help in this project. I already made a part of my project working. I have an excel file with client data and tracking of missed service. We send report per client, so I put a field with a drop down list with all our client name plus a field for date. We enter all our data in a table with header. When we want to pull out a report we enter the client name and desired date for the report and it create a PDF. Until there everything is perfect. We want Excel to give us the choice to save the file or to open Outlook with a temporary generated report PDF (without saving).

On another hand 2 of our client request us to used their specific report template (Excel Template file) and sent it in an excel file following their template ... So I want to put a condition in the PDF Macro , that if client A is specified it will copy content from some specific column, open the template file, copy info in desired row than show us a pop up to save excel file or send it by email with outlook. Same thing for client B.

Ex : Client A is selected, Macro will filter result than copy text from Range A13,C13,E13,F13 to Client template File one Line under Range (A13 --> D6 , C13 --> E6, E13 --> B6 ... )

I can give you part of the macro I did, Let me know if you need more details or explanation.

Thanks for your help,

Excel Visual Basic

หมายเลขโปรเจค: #6046993

เกี่ยวกับโปรเจกต์

23 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer 23 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $122

bouslimi1979

Dear, can you please send me your Excel file with macro + the new report template. Thanks *************************************************

$44 USD ใน 3 วัน
(334 รีวิว)
7.9
zExcel

Hi, I'll be happy to help you with this project. I will start as soon as you have awarded me the project Please feel free to message me if you need to discuss any questions

$111 USD ใน 1 วัน
(257 รีวิว)
7.7
maverick44000

Hi. I have delivered several Excel VBA projects which involved created PDF reports based on selected data and sending them as an email via outlook. I can manage you project in hopefully a day's time. Kindly discuss and เพิ่มเติม

$160 USD ใน 1 วัน
(93 รีวิว)
7.1
aarifakhtar

Hi: Please read my project reviews to know about my experience in Excel and the quality of my work. I have 100% completion rate with 5-star feedback. I would be happy to discuss your requirement in more detail. Please เพิ่มเติม

$100 USD ใน 3 วัน
(171 รีวิว)
7.1
svet63

Hi. There is no such option to attach a file to Outlook message without saving it first. This however, can be mimicked by automatically deleting the file after message was sent. Regards, Svet.

$150 USD ใน 3 วัน
(80 รีวิว)
6.8
koolsidz

Easy Job :) Hello I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that เพิ่มเติม

$66 USD ใน 1 วัน
(173 รีวิว)
6.6
chriskerpini

Hello, Your description is very clear, no more details or explanations needed. I will need a sample of your Excel file and the 2 template files for the customers who want the reports on their own templates. I can do เพิ่มเติม

$70 USD ใน 1 วัน
(77 รีวิว)
6.6
vikas0903

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on excel and VBA in my job and here on freelanc เพิ่มเติม

$98 USD ใน 3 วัน
(38 รีวิว)
5.6
jawadaman

Hi, I am interested in this project. I can do the job for you. I am proficient in MS-Excel/VBA programming. if interested in hiring me then please let me know so that we can discuss it further. Thanks. Regards, J เพิ่มเติม

$55 USD ใน 3 วัน
(52 รีวิว)
5.3
tomislav1975

Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. Thanks, Tom

$111 USD ใน 3 วัน
(34 รีวิว)
5.3
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my เพิ่มเติม

$170 USD ใน 5 วัน
(35 รีวิว)
5.0
pavellint

Hi! A little more information is needed before we can start the project. Can you show a demo of what's supposed to happen? Cheers!

$311 USD ใน 3 วัน
(5 รีวิว)
5.2
adim

Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. I'm waiting for detailed project description. I am Top 1% in VBA on Freelancer and lot of experience เพิ่มเติม

$111 USD ใน 3 วัน
(17 รีวิว)
4.8
MuradMurad

Hi, I have lots of experience with excel automation with vba macros and can help you in short terms with this project.

$244 USD ใน 3 วัน
(7 รีวิว)
4.8
dank111

Hi, My name is Dan. I am an expert in excel vba and I understood your requirement. I can add the code to your existing as well as amend it to fit those clients who needs an excel sent instead of pdf. Please messa เพิ่มเติม

$50 USD ใน 1 วัน
(10 รีวิว)
4.3
excelsolution

Hi, I an Excel Expert and work exclusively on Excel / VBA related projects in Freelancer. Please on I have gone through the requirements in detail and I will be deliver the required macro/program in 5 days. Please r เพิ่มเติม

$100 USD ใน 3 วัน
(17 รีวิว)
4.1
ExcelManipulator

hello. I can handle any excel macro that pertains to userform and printing. If you like my bid, hit me up. Chris.

$94 USD ใน 2 วัน
(3 รีวิว)
1.6
binitabiswas9

Hi, I am a professional Visual Basic Application Developer, Visual Basic 6.0, expert in Advanced VBA Macros development looking out for part time/freelancing jobs in same field. Kindly forward me your macro so th เพิ่มเติม

$77 USD ใน 5 วัน
(2 รีวิว)
0.2
darshanbshah

Hi, Really i am interested to work this as already i have good enough experience for this. But still want more clarification to complete this task.

$185 USD ใน 8 วัน
(0 รีวิว)
0.0
pendaflex

Hi I can definitely help with the task of creating a specific report--my bosses request this of me everyday at my day job. I can get client A and B the right PDF report from the Excel template. Thanks!

$111 USD ใน 3 วัน
(0 รีวิว)
0.0