Powerpoint macro to update OLE paths
€50-150 EUR
Paiement à la livraison
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.
Nº du projet : #17230021
À propos du projet
Décerné à:
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 Plus
12 freelances font une offre moyenne de 89 € pour ce travail
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 Plus
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 Plus
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 Plus
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 Plus