Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi and Welcome to JA!
In order to solve this I will need to see the workbook.
You can upload it to me here. www.wikisend.com. After upload give me the File ID or download link :)
Just reply to this chat when you are ready to begin and I will join you soon after.
It's asking me to "sign in". I uploaded, but it's asking me for a FILE ID that I don't see.The template has the data showing when the problem began. Go to the very bottom of the sheet to the "SUBMIT" button and click, and the Error 400 msg appears.
I can't sign in. no password
Where do I find the File ID?
Theres no need to sign up its Free :) Click the Browse button and locate your file. Then click Upload. It will direct you to the Download page. At the top left of the Download page it says File ID. its a 6 digit number. Copy and paste it here :)
Full Size Image
Lost the page. Have to try again. There was no file ID that I saw.
Ok great :)
Just a few minutes while I look at the file
Where can I find the Error?
You may have to "enable macros" at the top
Go to very bottom of template to "SUBMIT" button, click, and error msg appears
I had input 5 entries already with no problem of this kind.
Whats the password XXXXX unprotect the sheet?
Amex has that I guess, not me.
I get the template from them. Or is something else happening? Is the sheet picking up a password XXXXX my computer?
I found it :)
Great ! Can you pass that along to me??
Did the error msg appear for you?
I found the error is due to the named ranges
I am narrowing it down now :)
I guess that's a lot to narrow
Ok i got it
These two Named Ranges are no longer valid.
No, it got me :)
'ElseIf Range("PONo") = "" Then 'MsgBox ("The PO No or DA No is required. Please input information") 'Range("PONo").Select 'Exit Sub 'ElseIf Range("Invoiceno") = "" Then 'MsgBox ("The Invoice No is required. Please input information") 'Range("Invoiceno").Select 'Exit Sub
They dont exist
Rename them to the proper names and your set :)
uhm... what do I do with that info?
Ohh lol. Its just error checking.. I can simply remove them and it will work fine :)
I'm new at this. thanks.
Where do I "go" to "rename" these cells?
Im uploading the finished workbook now :)
To access the code. Press Alt + F11
Then select the Input Page
On the actual Input page name the Ranges then rename the Ranges in the VBA editor
http://wikisend.com/download/941432/K & C template.xlsm
After looking at the workbook Im not sure those 2 ranges would be missed,
do I copy/paste the link?
You can click it.
Try it out and make sure it works right. :)
Ok, was able to submit. Looks good for now. Thanks, XXXXX XXXXX
Your very welcome
And thanks :)
Dont forget to Rate my answer and feel free to request me for your next question :)