Advertisement

07.23.2008 at 10:49PM PDT, ID: 23591093 | Points: 500
[x]
Attachment Details

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

Asked by Venkatkp007 in Active Server Pages (ASP), Microsoft Excel Spreadsheet Software

Tags: , ,

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.
VenkatkpStart Free Trial
[+][-]07.24.2008 at 01:11AM PDT, ID: 22076951

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 01:31AM PDT, ID: 22077047

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 06:12AM PDT, ID: 22078700

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 06:33AM PDT, ID: 22078886

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 06:55AM PDT, ID: 22079104

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 07:11AM PDT, ID: 22079279

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.25.2008 at 12:08AM PDT, ID: 22086533

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628