Open Text File For Output On OneDrive

Hi Folks,

I have some code that I use to output to a text file.
It works fine if the file it is located in is stored on a local drive.
However, if the file is stored on OneDrive it generates a "Bad file name or number" error.
Can I adapt this code to work when the file is located on OneDrive?
The file is used by numerous people so it needs to handle the OneDrive path dynamically.

Open ActiveWorkbook.Path & "/" + strOutputFileName For Output As f

Hi Marc L,

I can't do that.
The file is used by random members of a sporting organisation.
The path is not static.

Do I understand correctly that this is a file being shared via one of the members' personal OneDrive?

Hi AliGW,

No, that's not correct.
The file is being distributed to various members of a sporting organisation.
They populate the original file and then generate the *.TXT file which is used in a downstream process.

The file is being distributed to various members of a sporting organisation.

How?

They populate the original file

How? If the file is being 'distributed' to them, then they must be working on a copy. If not, what do you mean by 'distribute'?

then generate the *.TXT file which is used in a downstream process.

What TXT file?

I think you need to be more detailed about your set-up.

Sorry if I have not been clear enough.

The file is being distributed to members of a sporting organisation via email.
They store a copy locally and populate it.
Once the file is fully populated they run a VBA procedure, via a button in the worksheet, that creates a .TXT file.
The.TXT file is located in the same Folder as the parent Excel workbook.
The .TXT file is then forwarded, via email, to the event Administrator.
The Administrator imports the contents into a database.

The issue I have struck is creating the .TXT file.
If the original, populated Excel file is saved on a local drive my code works fine.
If it is located on OneDrive it generates a "Bad file name or number" error.

The following code creates the "Output.txt" file.
Can it be adapted to create this .TXT file irrespective of where the parent Excel workbook is located?
I can test the location of the parent file and act accordingly.

Open ActiveWorkbook.Path & "/Output.txt" For Output As f