Powerpoint macro to update OLE paths
€50-150 EUR
Πληρώθηκε κατά την παράδοση
There is a customer PPT which is pulling data via an OLE object from one XLS file. Sometimes over 100 inserts are done.
Problem:
Everytime we move the file to a different path / file-location, the path is not correct anymore. There are errors and PPT cant refresh the OLE data from XLS file. We manually have to correct the file location for hundrets of datapoints in settings.
Goal:
I would like to have a macro which has two steps when file is opened:
Step 1:
Do you want to refresh the data from XLS file?
- Yes – Go to step 2
- No – leave everything a it is.
Step 2:
Let customer search for the XLS-File:
Save the new paths in PPT and refresh all the data in the OLE objects.
Looking forward for your help.
Ταυτότητα Εργασίας: #17230021
Σχετικά με την εργασία
Ανατέθηκε στον:
Hello, You should enumerate the OLEObjects properties and find the correct one for the path, mostly it is called as [login to view URL], and then do the RefreshAll sub for updating them all. Thats it
Hello , Previously also i have worked on similar project of move data into PPT from Excel. I have 5 years experience in Excel VBA programming and can complete task within time with 100% accuracy.I am v Περισσότερα
12 freelancers κάνουν προσφορές κατά μέσο όρο €89 για αυτή τη δουλειά
Hello, I can help with you in your project Powerpoint macro to update OLE paths . I have more than 5 years of experience in Excel, Powerpoint, Visual Basic, Visual Basic for Apps. We have worked on several similar p Περισσότερα
Hi, Why you should hire me? o 100% client satisfaction guaranteed. o Provide help even after the project has been marked Completed. o Work 7 days a week and available online on CHAT 24x7 for any queries o Proper Περισσότερα
- Have expertise in automation using VBA and macros in Excel, Powerpoint, Outlook and Word. - Can get the the Powerpoint data to be refreshed from the path of the xls based on the steps mentioned. - Can get complet Περισσότερα
Hello dear , I recently came across your jobs for a " Powerpoint designer " and would like to design all type of graphic for you like logo ,banner,flyer,brochure,tshirt,catalog,label ,poster etc . I am the Freela Περισσότερα
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can write VBA programme for you that will update path in ppt following the given steps. Please come on chat for more details. Awa Περισσότερα
Hi there, I am a recent graduate from SOAS University London and completed my bachelors in Business Administration from University College London prior to that, I assure you that the quality I will provide, if not exce Περισσότερα
A dynamic, self-motivated, and experienced senior programmer with diverse knowledge of programming languages, applications creation, and software engineering. Independently, I have been able to manage projects and pr Περισσότερα