Set Variable = File Path generates "Object Required" Error

**Brian48072** · 05-30-2013, 11:33 AM

HI,

Seems to me this should work, but it doesn't: I get an "Object Required" error message.

Dim FPath As String
Set FPath = "C:\Macros\Pyramid File Extractions\HPES_Asset_Reconciliation_Data_PyramidAP_1.xlsx"

Any ideas?

Thanks.

Brian

**TMS** · 05-30-2013, 11:37 AM

As you have defined it, FPath is a string, not an object. So you don't use "Set".

Dim FPath As String
FPath = "C:\Macros\Pyramid File Extractions\HPES_Asset_Reconciliation_Data_PyramidAP_1.xlsx"

Regards, TMS

**Brian48072** · 05-30-2013, 11:42 AM

Thanks TMS, I knew it had to be simple, but I just couldn't see it.

Re: Set Variable = File Path generates "Object Required" Error