If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Unable to Read File"
I have an access database that routinely produces a spreadsheet called
'rawoutput.xls'; the numbers in the cells change - nothing else. As part of the Access macro that to update the spreadsheet it overwrites any previous excel file of that name. Because the overwriting of the file means I lose all formatting, I have another excel file called 'formattedoutput.xls' which has a series of 'Paste Special/Paste Links' from rawoutput.xls. All it does is take data from the rawoutput and displays it as a series of formatted tables. The trouble is I keep getting "Unable to Read File" Messages when I try to update the links when I open formattedoutput.xls Can anyone help me to work out why I get the message (the links /seem/ to be there) and how to stop it. Alternatively, is there a way I can create an updated xls file from access without losing the original formatting. TIA Rob |
#2
|
|||
|
|||
"Unable to Read File"
Rfj wrote:
The trouble is I keep getting "Unable to Read File" Messages when I try to update the links when I open formattedoutput.xls Can anyone help me to work out why I get the message (the links /seem/ to be there) and how to stop it. I recall other people having problems with xls files created by Access giving problems. I suspect that is the case here. Have you tried opening the rawoutput.xls file in Excel and saving it - might just cure the problem. Alternatively, pull the data into Excel from Access using Data / Get External Data / New Database Query (or similar; Excel versions differ in their menus). Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office 2003 uninstall/reinstall problems | Jerryn3 | Setup, Installing & Configuration | 2 | August 2nd, 2004 03:39 PM |
Unable to open OST file | Vaughn gittin | General Discussion | 1 | July 21st, 2004 08:20 PM |
Continual Error 1321 Trying to Install Office 2003 | Chad Harris | General Discussions | 9 | June 11th, 2004 08:19 AM |
Unable to read file | McNiwram | Setting up and Configuration | 1 | May 11th, 2004 03:31 PM |
unable to access file | evan | New Users | 1 | April 28th, 2004 07:05 AM |