File path issue gets tougher

[kelly mort]

Hello I have this issue here and I need help :

Sub pdfCreate  ()
Dim FolderPath As String 
FolderPath = ThisWorkbook.Path & "\PDF FILES"
ChDir ThisWorkbook.Path & "\PDF FILES"
Sheet10.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Sheet10.Range("F4").Text, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False 
End Sub

I want the files saved in that pdf files folder yet it keeps saving it in the documents folder.

I am sure I am messing up with something but can't see it yet.

Point that out for me please.

Thanks in advance
Kelly

 

[RoryA]

I'm guessing you don't have the path in the cell, so:

Sheet10.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FolderPath & Application.Pathseparator & Sheet10.Range("F4").Text, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

 

[kelly mort]

I'm guessing you don't have the path in the cell, so:

Sheet10.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FolderPath & Application.Pathseparator & Sheet10.Range("F4").Text, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

Error :

Object required

 

[kelly mort]

ChDir ThisWorkbook.Path & "\PDF FILES"

'I Wana know what this line is doing there, I am thinking that's what is causing the issues maybe

 

[RoryA]

Error :

Object required

There are only 2 objects in that code - Sheet10 and Application. The latter cannot be missing and if your code worked before, Sheet10 must be valid, so I do not see how you could get that error on that line.

 

[kelly mort]

Oh okay I think my windows need some updates because most of my scripts are behaving strangely

 

[kelly mort]

Hello again, I have done the update but still the script is not running. Can someone help me out with why it's not working.

I want it saved to the "pdf files" folder yet it's saving to the "documents " folder.

Thanks

 

[RoryA]

What is the current code you are using?

 

[Dryver14]

what is the filepath of thisworkbook.path if its the documents folder then you need to change the file path and not use thisworkbook.path

 

[kelly mort]

What is the current code you are using?

I am using the original one I posted.