A tip about using Excel VBA with OneDrive

		Microsoft Office Forums > Microsoft Excel > Excel Programming
A tip about using Excel VBA with OneDrive

FAQ

Thread Tools

Display Modes

08-12-2024, 12:09 AM

MartinGM

Windows 11 A tip about using Excel VBA with OneDrive

Office 2021

Competent Performer

Join Date: May 2023

Location: England

Posts: 108

Quote:

Originally Posted by ArviLaanemets

In my experience, VBA can't change the contents of files on OneDive - probably the security issue.

The workaround is to store all such files on shared local network drive instead.

I *can* do file operation in OneDrive folders with Excel VBA - but I have to build in significant delays.

The absence of error messages is a pain.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel, hyperlink to OneDrive file, is this possible	The9codgerDrove	Excel	0	08-15-2022 04:32 AM
Word-OneDrive-Excel link not working when Word file re-opens	Prakash-Gautam	Word	0	05-02-2019 07:35 PM
Problem with hyperlinks to Excel workbooks on OneDrive	rjxb	Excel	0	08-28-2018 10:06 AM
OneDrive + iPhone Excel: Cannot Update Workbook?	markg2	Excel	0	12-07-2014 09:02 AM
Excel function does not work in OneDrive for Business	Laibiang	Excel	0	11-04-2014 07:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 AM.