Code to open fixed with file file with variable name

[jlax34]

I need to open an excel file that is not in an excel format and requires "fixed width" parameters to open correctly. Initially I had this written to open the specific file just for myself, but am looking to modify this so that anyone can use for any file location.

Original Code:

Please Login or Register  to view this content.

Now, I am adding this to prompt the user to select the location they have their file saved

Please Login or Register  to view this content.

Where I am struggling, is what the syntax is to open the file with the fixed with settings. I tried this and get a compile error on StartRow. I know sytnax can get iffy when broken into lines and tried moving some of it up a line and breaking in a different spot, but always get the compile error.

Please Login or Register  to view this content.