Open different date of text file

[Linda Lo]

Dear all,

I want to open a text file with following but it doesn't work. Please help to point out.

Dim Ag as Variant

Ag = Format (Cells(2,4), "YYYY-MM-DD")

ChDir: "T:\TEMP\Stock Closing Pr\backup\2024\Ag"
Workbooks.OpenText Filename:_
"T:\TEMP\Stock Closing Pr\backup\2024\" & Ag & "\CTFCLOSPRIC",Origin:=950, StartRow:=1, DataType:=x1FixdWidth, FieldInfo:= Array(0,1), Array(1,1), Array(5,1), TrailingMinusNumbers:= True

Thanks,
Linda

 

[Joe4]

Are you getting a specific error, or is it just not working?
If you are getting an error, what is the exact error message?

What is the EXACT FULL file path and name of the file?
Does the file have any extension on it (like . TXT, .CSV, .TAB, .DAT, etc)?

 

[Linda Lo]

Please ref to my uploaded image. Thanks a lot!

 

[Joe4]

Please ref to my uploaded image. Thanks a lot!

There isn't one.

 

[Linda Lo]

First of all thank your reply, you can't view my image?

 

[Joe4]

I see your VBA code, but no image in the first post.
Do you see an image in the first post?