Excel VBA to run through a dropdown list, printing pdfs of each option.

I am after a bit of VBA for excel written up that will:

On click of a button:

- Refresh the following data sheets:

------Project Actuals

------Project Budgets

------Project Forecasts

------PPO List

------Benefits List

------ICT PMO List

(These worksheets will remain hidden in the final version. They pull from an internal SharePoint server, so it will likely throw an error for you.)

- It will the ask where the user wants to save the produced reports

- It will then save/print to pdf the print area for worksheet 'Report (1.1)' for each option in the dropdown list found in cell N2 of the 'Report(1.1)' worksheet.

- Each pdf will be saved with the text that is found in cell N3 of the 'Report(1.1)' worksheet as the title.

The VBA should have a status indicator to show the user the progress over how many have been completed.

Taidot: tietojenkäsittely, Excel, Sharepoint, Visual Basic, Visual Basic for Apps

Näytä lisää: how to print all options in a drop down list in excel, excel print data validation list, how to print filter drop down list in excel, loop through excel drop down list and copy/paste the value, how to print drop down list in excel, macro to cycle through drop down list, loop through drop down list vba, printing all options from a drop down list, list files ftp excel vba, run excel vba select update filed based criteria, excel vba directory tree file list, excel vba run external program, run external windows application excel vba, excel vba list web files, excel vba connect iseries run query, excel vba list files directory, run program run script word excel vba, excel vba create loop list, excel vba run sheet macro sheet, excel vba find value list

Tietoa työnantajasta:
( 4 arvostelua ) WENTWORTH FALLS, Australia

Projektin tunnus: #18028400

Myönnetty käyttäjälle:


Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop a macro to ask you for the location where you want to save converted pdf file then save the printable a Lisää

$30 AUD 1 päivässä
(69 Arvostelua)

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


Hi, I am an Excel VBA expert with more than 15 years of experience in this field. I propose to deliver a functional Excel VBA code meeting your requirements. Let me know. Regards, Arul

$200 AUD 3 päivässä
(218 arvostelua)

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Lisää

$80 AUD 1 päivässä
(165 arvostelua)

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Lisää

$150 AUD 3 päivässä
(56 arvostelua)

Hello, we are a team of excel experts that are experienced in handling Visual Basic programmes if you are interested in hiring us drop a message.

$500 AUD 2 päivässä
(37 arvostelua)

Hello There, I am Microsoft certified SharePoint developer and have 15+ years of experience working with Microsoft and Sandisk in US. I can develop, customize, migrate & integrate your SharePoint portal. I have deep Lisää

$25 AUD 1 päivässä
(14 arvostelua)

Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.

$30 AUD 1 päivässä
(34 arvostelua)

Hi Good Day! A serious freelancer here! I can help you to complete this work in less than a day. I have a lots of available time for this work, but need to know the full requirements to assess how long would it Lisää

$30 AUD 1 päivässä
(14 arvostelua)