Where's the extra character coming from?

Following is part of the code I am using to import data from spreadsheets into my database.
    Debug.Print sExcelFileName
    Debug.Print sShortFileName
    DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel97, _
         "SiteData", "C:\BOSlink" & "\OldDataFiles\" & sExcelFileName, False, _
         sShortFileName & "!"

When I try it with most spreadsheets I get output that looks like the following in the immediate window in response to the debug,print commands and the code works perfectly:
030515.xls
030515

However when I tried it with the latest series of spreadsheets that have arrived I get the following output from the debug.prints which looks right
s190715s.xls
s190715s

The transfer function then trips out with an error that says:
's190715s$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
Where did the $ sign come from? Can anyone help me figure out why/how this is happening?
LVL 1
Rob4077Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
The dollar sign is needed for some Excel sheet names to reference them correctly.
Rey Obrero (Capricorn1)Commented:
open your excel file s190715s.xls and make sure that there is a sheet that is named  "s190715s"

your error is stating the it can not find the worksheet "s190715s", because it don't exists

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
...and just a wild guess/solution/workaround here...
If this "$" is being added for some strange reason, you can try simply removing it with an expression roughly similar to this:
    YourVariable= IIf(InStr(YourVariable,"$")>0,Replace(YourVariable,"$",""),YourVariable)
Rob4077Author Commented:
Thanks for all your comments. Rey hit the nail on the head. My user didn't follow procedure and I didn't realize till Rey picked it. Thanks for your help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.