Issues with thisworkbook.path

[AndreasL]

I've searched everywhere and I've tried using the tips I've come across, however I still run into isses using Thisworkbook.path.
This code works fine if I use $Environ(username), and put the path, but I'm not sure the other ones in my office has the onedrive folder saved in the same location.
It would then also only work if synced to PC, so I'm trying to work around this solution.
Turning off sync to cloud is not an option as there are several working with this sheet daily.

My code is as follows now, please help me locate the issue. (I get path/access error (75) even tho Thisworkbook.path works in other macros exporting PDF to folders in the same location).
It seems neither the Exportpath or the LoadPicture is working with this at the moment, but first of all I'm stuck with this line:

.Export Filename:=Exportpath, FilterName:="bmp"

 Set oWs = Ark3
 Set oRng = oWs.Range("A1:O36")
 Exportpath = ThisWorkbook.Path & "/" & "temp" & "/" & "PLAN.bmp"

 oRng.CopyPicture xlScreen, xlPicture
 lWidth = oRng.Width
 lHeight = oRng.Height
    Worksheets("PLAN").Unprotect
 Set oChrtO = oWs.ChartObjects.Add(Left:=0, Top:=0, Width:=lWidth, Height:=lHeight)

 oChrtO.Activate
 With oChrtO.Chart
  .Paste
  .Export Filename:=Exportpath, FilterName:="bmp"
 End With

 oChrtO.Delete
 
 IMGplanen.Picture = LoadPicture(ThisWorkbook.Path & "/" & "temp" & "/" & "PLAN.bmp")

 

[rlv01]

 Exportpath = ThisWorkbook.Path & "/" & "temp" & "/" & "PLAN.bmp"

Is there a reason you are using forward slash ("/") instead of back slash ("\") in the path?

 

[AndreasL]

 Exportpath = ThisWorkbook.Path & "/" & "temp" & "/" & "PLAN.bmp"

Is there a reason you are using forward slash ("/") instead of back slash ("\") in the path?

I've tested and they both seem to work equally. I've always been confused as to what to use since url's and cloud saved paths have forward and explorer has backward.
Don't know if it's a region thing or what. Most online seem to use backwards, but forward also works for me.

I've gotten the Environ to work now, so it's a fix I guess, but it really annoys me that I seemingly can't use "ThisWorkbook.Path" in my coding.

 

[GWteB]

Have you checked what the final result looks like? It could tell you and us a lot.

Exportpath = ThisWorkbook.Path & "/" & "temp" & "/" & "PLAN.bmp"
MsgBox Exportpath

 

[AndreasL]

C:\users\myusername\Onedrive\Pakkeavdelingen\Produksjonsplan, Forbruk og Kontroll/temp/PLAN.bmp

Looks wonky with "/" and "\" in the same path, but it works.
Msgbox ThisworkbookPath gives a sharepoint path with only "/" in it. So local storage is "\" while url's are "/".

 

[GWteB]

So why not change it like

Exportpath = ThisWorkbook.Path & "\" & "temp" & "\" & "PLAN.bmp"

 

[AndreasL]

So why not change it like

Exportpath = ThisWorkbook.Path & "\" & "temp" & "\" & "PLAN.bmp"

Okay, now I'm embarrassed. It works. I'm pretty sure I've tested all possibilities with "/" and "\" but this may have eluded me.
For future knowledge, is it always "\" in vba coding or is it depending on the direction they face in the path when I check using msgbox?
Also, is: ThisWorkbook.Path & "\temp\Plan.bmp" not a viable way to enter this? Should it always be like you posted or can I chain together the entire remaining path?

 

[AndreasL]

Okay, now I'm embarrassed. It works. I'm pretty sure I've tested all possibilities with "/" and "\" but this may have eluded me.
For future knowledge, is it always "\" in vba coding or is it depending on the direction they face in the path when I check using msgbox?
Also, is: ThisWorkbook.Path & "\temp\Plan.bmp" not a viable way to enter this? Should it always be like you posted or can I chain together the entire remaining path?

Nevermind.

Changed

IMGplanen.Picture = LoadPicture(ThisWorkbook.Path & "\" & "temp" & "\" & "PLAN.BMP")

to ThisWorkbook.Path now and I get path/access error 75 on this line:

 .Export Filename:=exportpath, FilterName:="BMP"

 

[GWteB]

On logical drives, whose path starts with a letter (like C: for instance), folders that are part of the path are always separated by a "\".
You may compose a path name any way you want, as long as you meet the above condition, and for both folder names and file names no invalid characters are used: <>"/:\|?*

 

[GWteB]

now and I get path/access error 75 on this line:

The full folder path must exist and the target file, if it already exists, must be able to be overwritten, so a read-only attribute has to be cleared.