Has anyone Experienced this before Q

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have an Excel file that pulls various values from an MSAccess database, it
has worked fine, but now it returns indesribable code within the cell A1. A
snap shot of some of this code is as follows

'{\rtf1\ansi\ansicpg1252\paperh16834\paperw11904\margl1077\margr851\margt1134\margb1134\psz9{\colortbl\red0\green0\blue0;\red255\green255\blue255;\red0\green0\blue128;}{\fonttbl\f0\fcharset0\fnil
Arial;\f1\fcharset0\fnil Times New Roman;\f2\fcharset0\fnil
Arial;\f3\fcharset0\fnil Times New Roman;\f4\fcharset0\fnil Times New
Roman;\f5\fcharset0\fnil Times New Roman;\f6\fcharset0\fnil
Arial;\f7\fcharset0\fnil Times New Roman;\f8\fcharset0\fnil
Arial;\f9\fcharset0\fnil
Arial;}\pard\plain\sb57\tx90\tqr\tx7487\tqr\tx8401{\plain\tab\fs40\i\b\f1\cf2\cb1
Half Hourly Sales - On Line\plain\tab\fs20\i\b\f3\cf2\cb1
StoreNo\plain\tab\fs20\f2\cf0\cb1

This goes on and on, all of it in Cell A1. There appears no virus on the PC
or within the file. The original file size was approx 500k, its now down to
10k, but when I open it all I see within the file is above.

I'm running WindowsXP pro and Excel XP, all pretty much up todate

Any help appreciated

Thanks
 
How are you pulling the information from Access? Through Microsoft
query, a pivot table, in code through ADO or DAO?
 
Though Microsoft Query. Just a very simple extraction of data from a table
using 2 date parameters
 
Have you tried rebuilding the query from scratch? Was this spreadsheet
possibly built in a previous version of Excel?
 
I replaced the file with a copy I had. It worked for about 5 days, then the
same thing again, I have another new copy in again since yesterday and its
working at the moment. I have the same file working on 25 other PC's but
I've never had this problem. File was built on XP, as is the Excel version
on the problem PC, yet I have a number of other PC's running the same file
also running XP with no such instances.

I just can't understand it, its 500k with substantial formating over 4
worksheets, then this happens and its 10k with this only in cell A1 on one
worksheet, everything else is blank, you'd have to actually see it to
believe it. This doesn't happen when you action any macro's, but when the
file was opened
 
Back
Top