Hello there,

i need some support please, as i have an issue that considered too odd somehow, I exported a PDF file from a system called "Teleopti", i exported these file from system 32 Bit once and 64 Bit once, when copy the data from 2 files then paste it with "Values and number formats" side by side, the pasted data are visually matched, but any other verification or process via VBA or logic, the data that exported from system 32 Bit, haven't any problem ever, but which exported from system 64 Bit didn't processed or verified via VBA or equations

i uploaded the both of 2 PDF file and the pasted data in Excel sheet, need to get a concrete solution as i haven't see something like that before :),

The ZIP file called "Export.ZIP"

Gratefully,

  

     

 

• Edited by Ahmed M Abdel Kader Wednesday, April 08, 2015 9:20 AM

Hi Ahmed M Abdel Kader,

Could you tell me whats the meaning of system 32 Bit and 64 Bit? The system is Windows system or the Teleopti" system?

Based on my test, this problem might be caused by the blank space when you export the data from the third-party program to PDF. The blank space neither values nor numbers, so the formatting didnt change in excel spreadsheet that you cant match the data between version 64 bit column with the blank space in version 32 bit.

If this is the result you want to get as shown in the following figure:

You can delete all of the blank space to get the result.

Or you can also replace all of blank space in version 64 bit column/version 32 bit column with the blank space in version 32 bit column/version 64 bit column.

Hope its helpful.

If the result is incorrect, please let me know.  I am glad to help and forward to your reply.

Regards,

Hello guGuuuMy,

>> the version 64 is the both of windows/Teleopti version

>> i need to depend on 64 bit exported sheet which has a problem, when i calculated the length of both of the 2 version, they are matched.

there is a valid solution can i apply to get valid result, via VBA or some logics

 

Hi Ahmed M Abdel Kader,

Did you want to modify 64 bit sheet via VBA or logics to get the result, so that they can match with data in 32 bit sheet?

As my said before, you can replace the blank space in bit 64 sheet manually, Home-Editing-Find-Replace

.

If you have to via VBA or logics to get result automatic, please post it to the MSDN forum for Excel, they can help you.

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

BTW, if my understanding is incorrect could you be at bit more precise explain your problem? I am glad to help and forward to your reply.