Suoritettu

Simple Excel Macro

A) THIS SPREADSHEET, [url removed, login to view], WILL BE THE MASTER SPREADSHEET

B) IT HAS 1 TAB (PRODUCTION)

C) IT WILL BE STORED ON A NETWORK

D) WHEN SOMEONE GOES IN TO MAKE AN UPDATE, I WANT THE MACRO TO DO THE FOLLOWING:

1) SAVE THIS ORIGINAL MASTER FILE ON THE NETWORK (I'LL UPDATE THE ACTUAL PATH, BUT I'LL NEED YOU TO SIMPLY WRITE C:\PATH\ IN YOUR MACRO, OR SOMETHING SIMILAR)

2) COPY THE PARTICULAR SHEET THE END-USER IS CURRENTLY EDITING TO A NEW SHEET

3) MOVE THE CURSOR TO CELL B68

4) COPY THE TEXT IN CELL B68 TO THE CLIPBOARD

5) SAVE THE NEW FILE AS "PASTE THE TEXT FROM THE CLIPBOARD AS THE FILE NAME"

6) SAVE THE NEW FILE

7) EMAIL THE FILE AS A PDF TO THE EMAIL IN CELL F56 (I PRESUME THROUGH THE FILE MENU AND SHARE, EXPORT AS PDF, BUT MY MACRO KEEPS FAILING WITH THE TEMP PATH…???)

8) ALLOW THE END-USER TO TYPE ANY TEXT IN THE EMAIL THEY WANT TO

9) THE END-USER WILL PUSH SEND ON THE EMAIL

10) THE END-USER WILL THEN BE RETURNED TO EXCEL

11) **IF THIS IS NOT TOO HARD TO PROGRAM, YOU CAN ADD IT** -- A POP UP MESSAGE BOX THAT SAYS "YOUR EMAIL AND REQUEST FOR APPROVAL HAS BEEN SENT" WITH AN OK BUTTON

12) MOVE CURSOR TO CELL A4

13) SAVE FILE IN SAME DIRECTORY

14) CLOSE FILE

Taidot: C# -ohjelmointi, tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic

Näytä lisää: macros in excel examples, how to create a macro in excel 2007, how to create a macro in excel 2010, how to create a macro in excel 2016, how to create a macro in excel 2013, macros in excel for beginners, use of macros in excel, excel macros for dummies, excel macro close firefox, close excel macro, close external application excel macro, excel macro close internet, excel macro close, excel macro send tab internet explorer, macro close excel internet explorer

Tietoa työnantajasta:
( 5 arvostelua ) Dallas, United States

Projektin tunnus: #16299330

Myönnetty käyttäjälle:

polarjin2017

````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````

$80 USD 1 päivässä
(44 Arvostelua)
5.8

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

Webxpert4u

Hello, I am ready to create macro to update data. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writing Microsoft Excel M Lisää

$210 USD 3 päivässä
(167 arvostelua)
7.3
liangjongai

Hi! I'm interesting your project very well. I am mastering vba and excel. And also I have many experience and good skill about web development. Let's go ahead with me

$150 USD 3 päivässä
(173 arvostelua)
6.8
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD 3 päivässä
(240 arvostelua)
6.9
asin1987

Dear Employer, I am a macro/excel/vba expert. Request you to please check my reviews once. Can you please give me an opportunity. I will 100 percent do your job. Thanks and Regards, Ash

$155 USD 3 päivässä
(48 arvostelua)
6.1
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll code in your current xls Lisää

$222 USD 3 päivässä
(33 arvostelua)
5.8
Lionanaimal

I checked the attached excel file i read all the 14 points, and ready to start now and deliver amazing excel file Regards

$150 USD 2 päivässä
(11 arvostelua)
4.7
soltecke

Regards, We have a vast experience developing tools for SMEs in different platforms such as Excel and Python. In addition we are also dedicated to the analysis of data, data science and data mining. We are loo Lisää

$222 USD 6 päivässä
(2 arvostelua)
3.1
FarhanmGood

Hi, I am currently working as a DATA ANALYST in IPSOS company. I have read your job description and i can optimize and automate your excel macro. It will work according to your needs let me handle it. Feel free to co Lisää

$100 USD 3 päivässä
(9 arvostelua)
3.2
sultanarime90

Hello, I saw your project and its details. I have skills that your project needs. I am ready to work with you .please send message and discus over chat. Thank you

$200 USD 3 päivässä
(0 arvostelua)
0.0
somnath8726

Hi, We have an experience team work this kind of project. Please come on chat so we can discuss more about the project. Thank you.

$111 USD 1 päivässä
(0 arvostelua)
0.0
Khaledfarhat

A proposal has not yet been provided

$155 USD 3 päivässä
(0 arvostelua)
0.0
$144 USD 5 päivässä
(0 arvostelua)
0.0
emresurmeli

I am expert in MS Office especially in excel. I can use VBA language in excel. I have experience about 2,5 year in decision support reports to board members. I am good at making up documents,excel report for board mem Lisää

$122 USD 2 päivässä
(0 arvostelua)
0.0
$111 USD 3 päivässä
(0 arvostelua)
0.0
VinitM11

A proposal has not yet been provided

$188 USD 10 päivässä
(0 arvostelua)
0.0
gyogeshwar

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$83 USD 3 päivässä
(0 arvostelua)
0.0