VBA OneDrive issues

Hello all,

My company just migrated over to One Drive from a corporate shared drive, our inventory spreadsheet would use ThisWorkbook.path to save a copy each time someone would email it, now with One Drive using an HTTP protocol I get the run time error. Would someone please help me with what I need to change up or insert in my code?
Thanks ahead of time.

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

Try this...

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

For some reason, I keep getting a bad file name or number on this statement.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however we recommend that you include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags. I have added them for you this time. You have already been warned about this - please don't forget again!

Rest of your code is missing and not possible to ascertain reasoning...You cannot just plug that snippet in and leave all else as is...Upload a sample file and explain in step by step detail what it is you are trying to achieve...see top yellow banner...

Is there a URL in the code? If so, replace it with xxxx.

I've attached the entire code that I have, when I run it and it hits (Do While Dir(ThisWorkbook.Path & "" & wbsf1) <> "") I get the error, I only assume this is because of ThisWorkbook.Path gives back a URL for OneDrive. I've tried a bunch of different options all giving me the same results. I can't hardcode a path because it will be used by a host of users all using different OneDirve or SharePoint per facility.

Please Login or Register  to view this content.

Tampa inventory 1.7.24 sales date. Folio 5.xlsm

I gave you the answer in Post 2...

Please Login or Register  to view this content.

Then you need to implement it correctly...Replacing All your code snippets of

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Cannot access your code as your file vb project is password protected...don't feel like running code to crack now...
Try closng the wbsf workbook first before attaching it...

Sorry about that, I thought maybe it would be a quick fix.

it should be...did you try closing the file before ... in other words moving the

Please Login or Register  to view this content.

to above the

Please Login or Register  to view this content.

Or just upload a file which is not password protected...

To be honest with you...That code is a mess...and not easy to follow...
What do you get when you run this...
Place it before your outlook code...

Please Login or Register  to view this content.

and then

Please Login or Register  to view this content.

I don't have your setup so I cannot recreate your issue...and like I said, your code is a mess...
If I were you, I would redo it...Expalin in detail what is is you are wanting to achieve...step by step and just perhaps someone will be able to simplify it without errors...