MS VBA - Save-As via Macro to OneDrive fails

Tom_84 · 24. März 2022

Hi Community,I hope someone can help me out...I have a file with a Macro that would generate a filename, open the Save-As Dialog and prompts the user to save the file to a specific folder on a Shared Drive on OneDrive.However, since a few weeks this is not working anymore, the macro fails and debug shows the Application.DialogsxlDialogSaveAs.Show command is faulty, after I confirmed to save. If I change the destination folder to anything outside OneDrive it works just fine, the rest of the macro runs without any issues.Have there been any changes with the most recent updates that might preve

Thomas Löwe

Hallo Susanne,

vielen Dank für deine Nachricht.

Ausführliche Informationen findest du hier:

http://technet.microsoft.com/en-us/library/cc179230.aspx

Bitte stelle deine Anfrage in ein besser geeignetes TechNet Forum ein:

http://social.technet.microsoft.com/Forums/de-de/home?forum=office_generalde&filter=alltypes&sort=lastpostdesc

Es wäre sehr hilfreich, wenn du den Link zu deiner dortigen Anfrage hier bereitstellen würdest, damit auch andere Personen diese finden können.

Bei Fragen zu Microsoft Office stehen wir dir jederzeit gern zur Verfügung.

Bernd P.

So sollte es gehen:

https://thewincentral.com/how-to-save-copy-of-class-staff-notebook-onedrive/

Bernd

Pauline R.

Hallo Häns,

du könntest alle Termine per Hand in deinen Hauptkalender kopieren (über die Listenansicht). Wenn du das Kopieren per VBA machen möchtest, schau ob dir diese Seiten weiterhelfen:

http://www.slipstick.com/developer/copy-new-appointments-to-another-calendar-using-vba/

http://www.slipstick.com/developer/save-appointments-to-a-non-default-calendar-folder/

Gruß,

Pauline

sajju2

.. enterd following as feature request.

SkyDrive App

- It should be possible to sync Windows Live Mesh data with Apple IPad! E.g. through Skydrive App.

- Should be possible to save to SkyDrive App from ios devices (e.g. from Mail, webpage, etc. >> with save as/to skydrive app functionality.

SkyDrive on Web

- Also on SkyDrive the synced Live Mesh Data and "normal" uploaded data to skydrive should be combined in one place/structure/view.

Only then we can start using skydrive instead of our local harddrive.

Torsten Schwanitz

Dear Charles,

First of all, thank you very much for your elaborate answer!

However, could you also let me know how to do the same via a macro solution? My customer requires the macro in a template format.
The desired outcome is the following:
Information entered by the customer should appear in any place on the page.

In addition, the information should only be entered once and then be automatically updated on all pages.

This is why I can neither use autotext, or bookmarks, nor fields. Since the document properties, such as author, status etc. in the ribbon
"insert" / quick function block/ document properties" fulfill this requirement, I would prefer to use this option.

In the end the customer should be able to insert the author into the document as often as needed. If the author is changed however, all instances should have changed automatically as well.

I hope I was able to explain my problem properly. If not, please do not hesitate to reach out again.

Best wishes from Germany,

Torsten

Hi,

willkommen im Windows Forum!

MS VBA - Save-As via Macro to OneDrive fails - Similar Threads - VBA Save via	Forum	Datum
How to get SharePoint Available for "Save As" function How to get SharePoint Available for "Save As" function: Hi ThereFor one of our customer, we are unable to save directly to SharePoint. The users are following certain SharePoint Sites. However they are not showing up in the Save As location. Is there...	Microsoft Office	3. Dezember 2024
Office Programme "save as" ausgegraut Office Programme "save as" ausgegraut: Hallo, ich habe auf meinem Mac M1 Pro OS 13.6.4 Microsoft 365 und Office installiert, aktiviert und bin eingeloggt.Ich kann bei den Apps aber keine Dokumente speichern "save as" ist ausgegraut....	Microsoft Office	16. April 2024
MS Access 365 can't save report as PDF/A sometimes MS Access 365 can't save report as PDF/A sometimes: I've switched from Access 2013 to Microsoft® Access® für Microsoft 365 MSO Version 2308 Build 16.0.16731.20052 32 Bit and now can't reliably save an Access report as PDF/A. I can reliably save the...	Microsoft Office	15. September 2023
VBA und Macro VBA und Macro: Hallo liebe Community!ich habe eine Frage und zwar: Wo liegt ist der unterschied zwischen VBA und Macro?Also ich habe es so verstanden, dass man VBA verwendet, wenn man sozusagen den ganzen...	Microsoft Office	19. August 2021
MS Word macro MS Word macro: Hi there, I would like to write a WORD macro that sends words to an API parallel to typing. Is that possible? A similar mechanism could possibly underly the MS Word spell checker. Is there any...	Microsoft Office	14. September 2020
CDO VBA Excel Macro CDO VBA Excel Macro: Hello Community! I am testing a excel macro which suppose to send emails. It was done with CDO which access SMTP server. But I am getting the following error message: "The tronsport failed to...	Microsoft Office	16. April 2020
Excel macro run when save file Excel macro run when save file: hello, I need one vba code, that will do this: I open today the file, change what I need and when I press to save the file, it should write the date in the sheet. Tomorrow when I open the...	Microsoft Office	13. Februar 2018

MS VBA - Save-As via Macro to OneDrive fails

MS VBA - Save-As via Macro to OneDrive fails

GOP Save as

Kursnotizbücher in OneDrive speichern

Mehrere Kalender im angehefteten pop up anzeigen lassen

OneNote mit mesh bidirektional synchronisieren

Word 365: Einfügen eines Schnellbausteins in ein Textfeld

User Advert

MS VBA - Save-As via Macro to OneDrive fails - Microsoft Office

MS VBA - Save-As via Macro to OneDrive fails - Similar Threads - VBA Save via

How to get SharePoint Available for "Save As" function

Office Programme "save as" ausgegraut

MS Access 365 can't save report as PDF/A sometimes

VBA und Macro

MS Word macro

CDO VBA Excel Macro

Excel macro run when save file

MS VBA - Save-As via Macro to OneDrive fails solved