troubleshooting Question

I need a (small) VBScript to find Junk characters in the Excel sheet

Avatar of Venkatkp007
Venkatkp007 asked on
ASPMicrosoft Excel
7 Comments1 Solution595 ViewsLast Modified:
We have a spreadsheet upload process through the website and it is stored in one of the folders in the server. We have a separate VBscript in the server which is processing the spreadsheet. few days back we observed that the spreadsheet contained following junk/funny characters

ntent-Transfer-Encoding: 16bit      

hg±í’ß>  
and the entire spreadsheet looked corrupt with above characters. The spreadsheet got corrupted due to some Portal web server settings which we don't have access too.

Do we have a way in VBScript to check if the spreadsheet is corrupt like this? Can anyone guide me?

Pls let me know if you require more information.
Venkatkp
ASKER CERTIFIED SOLUTION
ExcelGuide
Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros