trying to transfer module from ThisWoork to strPath file

[dmcgov]

when i check the locals and watches windows, the variables are all correct. yet i am getting a Runtime error 9: subscript out of range. what am i doing wrong?

Please Login or Register  to view this content.

FNametxt shows as "C:\Users\dmcgovern\Documents\Excel\Module_Code\code.txt" and strPath shows as "C:\Users\dmcgovern\Documents\Excel\Chapter 1 - Strings.xlsm", yet it errors out on this line:

Please Login or Register  to view this content.

note that strPath is a public variable

[dmcgov]

any help for why i am getting a run time error?

[dmcgov]

so i changed this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

and its working now

[rorya]

You don't include the path when using an index into the Workbooks collection - you just use the file name.

[dmcgov]

thanks rorya, i should know better by now.