Powerpoint macro to update OLE paths
€50-150 EUR
Paid on delivery
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.
Project ID: #17230021
About the project
Awarded to:
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 More
12 freelancers are bidding on average €89 for this job
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 More
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 More
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 More