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
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