Excel data not presented correctly

Dell Dell latitude d400, d500, d600, d80...
April 23, 2012 at 10:03:30
Specs: Windows XP, 2.4GHz /8Gb
Hmmm...this is going to be a tricky one. I don't have any programming knowledge or experience and no one is sure what the user did and now he left.

So what happens
Everyday a piece of software on 'server 1' generates a CSV file filled with information from a database. Basically, the building is filled with sensors measuring temperature, humidity and the like. The software receives all the data and then runs a report export to CSV. This all works OK.

Now someone takes this CSV file and puts it on a normal file server
Then the person opens a specially prepared excel spreadsheet with programmed buttons. They click on one of the buttons, can't remember what the button is called and it prompts them to open the CSV file they just copied. Having done this, then then click on the second button that then runs something that they then have to save out as another CSV. When they have done this and they open the just save, processed CSV it should display all the data 'correctly'

Now. This is the tricky bit. This excel spreadsheet works perfectly on a PC i had removed for scrapping. It was out of warranty and had to be replaced. i was just about to wipe the PC when i got distracted and so i was going to do it the following day. This was when someone came into our office with rather strained expressions. They have to run this report monthly and a report was due today. Trouble was the program wasn't working correctly. It was kind of working, but for some of the timings had 12 hours knocked off.

we turned on the old PC, ran the report again from the PC with the file on the server and it worked out fine.

Naturally i do get the idea there must be some sort of code on the PC that is doing this, but what? and where? i tried looking for VB scripts that we could copy onto the new PC, but all the VB scripts i found were microsoft or specific vendor related, nothing the user could have been using. I did notice that micirosoft c++ 2005 redistributable was installed, but how do i look for C++ files.

i asked around the office and no one knows anything. i created an image of the PC and basically i have had to go and put the PC back on the desk. It is still working thank goodness, but i am stumped as what to investigate. There can't be anything in the spreadsheet itself because then it would be independent of the machine it is working from. The spreadsheet is using some kind of hidden code on the PC, but i don't know what it is or where it is.

your help would be much appreciated

See More: Excel data not presented correctly

Report •

April 23, 2012 at 10:16:20
I'm sorry, but my Magic 8-Ball of TechProgramming Support only answers Yes/No questions, and my physic powers were never that strong.

At a minimum, you should post the VBA behind the buttons, any special formating or functions on the sheet, some valid sample data, and the desired output.

How To Ask Questions The Smart Way

Report •
Related Solutions

Ask Question