how to disassociate vba code from onedrive?

Question

how to disassociate vba code from onedrive?

Stephen Thompson 0

modle1 attempts to: ChDir "C:\Users\sthom\OneDrive\Wordle." i don't have a onedrive account. this code, which i did not write, causes my vba code to hang up while fixing errors in my code. to overcome this hang up i need to save and reload the file.

0 comments

2 answers

Your answer

Answer 1

Damien Pham (WICLOUD CORPORATION) 2,215 Microsoft External Staff Moderator

Hello @Stephen Thompson ,

Thank you for sharing the details. Based on the code shown, this does not appear to be an association between VBA and OneDrive. The macro contains a hard-coded OneDrive folder path:

ChDir "C:\Users\sthom\OneDrive\Wordle"

According to Microsoft’s ChDir statement documentation, ChDir changes the current directory or folder to the path specified in the statement.

Please open the Visual Basic Editor and locate this ChDir line. If the macro does not require a specific working folder, you can remove or comment out the line. Otherwise, replace the OneDrive path with the path of an existing local folder on your computer.

I hope this helps clarify why the macro is referencing OneDrive. If you found my response helpful or informative, I would greatly appreciate it if you could follow this guidance or provide feedback.

Thank you.

Damien Pham (WICLOUD CORPORATION) 2,215 Reputation points Microsoft External Staff Moderator

2026-09-17T09:33:08.72+00:00

Hello @Stephen Thompson ,

Thank you for providing the additional details.

Since the current spreadsheet was created as a copy of the previous version, the VBA project, including the Module1 code and its hard-coded OneDrive path, would also have been copied. The presence of that line does not by itself mean that OneDrive or Microsoft automatically added it.

You should not need to recreate the deleted OneDrive folder solely because of this ChDir statement. Updating or removing the line in the affected workbook, as discussed earlier, should prevent the macro from trying to use a folder that no longer exists. Adding VBA code to other Excel or Word files would not normally add this specific path automatically.

After testing the updated version, could you let me know whether the hang-up still occurs? If the issue has been resolved, please also let me know whether you need any further assistance with this question.

I hope this helps clarify why the macro is referencing OneDrive. If you found my response helpful or informative, I would greatly appreciate it if you could follow this guidance or provide feedback.

Thank you.

Answer 2

Barry Schwarz 6,111

Change the statement to

ChDir "C:\Users\sthom\Documents"

or to any other folder you have access to.

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Stephen Thompson 0 Reputation points

2026-09-15T13:56:34.7933333+00:00

In the process of trying to avoid the 10 minute minimum time required it takes to reload this file (its huge and requires 10+GB in memory) I tried to completely uninstal OneDrive. It takes about 20 minutes if I need to save changes (when I have corrected an error in my VBA code). When uninstalling OneDrive I deleted the the OneDrive user's folder and noticed that it did not contain a Wordle subfolder. The VBA project code in module1 (that I didn't write) must be Microsoft code. My concern is what other files could be affected by deleting the OneDrive user's folder(s). My first encounter of this hang up has been very recent. I added activeX controls to the Wordle spreadsheet several revs ago. I didn't write much code for the activeX controls and may have missed the hang up - if encounterred. I have many personal files in Excel and Word which do not contain VBA code that I wrote. I wonder how many of these files could have VBA project module1 code referencing the user's OneDrive folder that no longer exists. Do I need to add the user's OneDrive folder back to my hard drive? Will other files (Word or Excel) add this reference when I add VBA code to them?
Stephen Thompson 0 Reputation points

2026-09-15T14:47:12.28+00:00

In the process of trying to avoid the 10 minute minimum time required it takes to reload this file (its huge and requires 10+GB in memory) I tried to completely uninstal OneDrive. It takes about 20 minutes if I need to save changes (when I have corrected an error in my VBA code). When uninstalling OneDrive I deleted the the OneDrive user's folder and noticed that it did not contain a Wordle subfolder. The VBA project code in module1 (that I didn't write) must be Microsoft code. My concern is what other files could be affected by deleting the OneDrive user's folder(s). My first encounter of this hang up has been very recent. I added activeX controls to the Wordle spreadsheet several revs ago. I didn't write much code for the activeX controls and may have missed the hang up - if encounterred. I have many personal files in Excel and Word which do not contain VBA code that I wrote. I wonder how many of these files could have VBA project module1 code referencing the user's OneDrive folder that no longer exists. Do I need to add the user's OneDrive folder back to my hard drive? Will other files (Word or Excel) add this reference when I add VBA code to them? The previous version of this file (this file started as a renamed copy of the previous version) has exactly the same path change VBA code in module1. The previous version which has some of my debugged VBA code and runs as expected and has for at least a month. Appearently the path change instruction only tries to execute when error(s) are detected. I don't like to make changes to any operating software without changing the version number. Since the previous version runs I don't intend to fix its non-existant path in module1. I will change the VBA code in module1 for this version of my spreadsheet as you suggested and see if the hang ups go away. I need to make more changes to my VBA code and surely I'll make some new error(s) to test your solution.
Stephen Thompson 0 Reputation points

2026-09-18T21:00:39.1966667+00:00

i changed the path in question to an existing path (the path where i store the Excel file) and i thought this corrected the hang ups. After debugging several errors in my code (and some functionality) that i just added the whole thing hangs up again. one of my subroutines triggers on a date change in a specific cell. after detecting a date change the sub counts prior dates in a range. it displays the count of prior dates in the cell below the new date. this code has functioned properly for months. this is the next rev for my spreadsheet (save a copy with the new name). another is trigged by an activeX pushbutton. this sub is supposed to do some calculations and output the results in several places in the Excel workbook. To troubleshoot this new date change code i change the date to trigger the sub (F8 seems to trigger the first private sub for this worksheet) and i know that the sub did not execute when the count of prior dates doesn't update (i clear the cell expecting the sub to write the new count). when the count doesn't display i know the sub didn't execute. prior to changing the path statement, at least twice the debugger pointed to the path change statement in module1 - it shouldn't be a problem with the revised path. it is beyond frustrating finding what i must do to troubleshoot vba code.