|
Hi Keith, Here's a suggestion - maybe your Excel file is not the right version. I just did the following test on my machine: 1) Downloaded a file from the AS/400 into an Excel spreadsheet. When doing so, I selected file type BIFF5(MS Excel 5), and I saved the .FDF. 2) Opened the spreadsheet in Excel97, made some changes and saved it. When asked if I wanted to update to the current version, I said "Yes". 3) Tried to upload the spreadsheet to the AS/400 and got the following message:"<myfilename> could not be found". The problem was that I changed the format, and CA no longer recognized the file. I have used CA to download to and upload from Excel97 many times over the past several years, and it generally has worked well, but I have learned that you have to be _very_ sure that you have to keep your versions straight. CA offers Excel 3, Excel 4, and Excel 5, which are _not_ the same, and none of them is the same as Excel97. To complicate things further, I also move the spreadsheets into and out of MS Access, and it seems to prefer Excel 3. What you need to do is let CA (or Access or whatever) produce the spreadsheet in whatever version it wants (if there's a choice, I pick the latest one unless there's a reason not to); then don't update the format after you've made your changes using Excel97. Don't ever try to change the format (for example, getting an Excel 3 spreadsheet from MS Access and then saving it as Excel 4 before trying to upload it I don't remember if you said that you were getting the new data by exporting from something else, but if so the following technique worked for me when I had problems: 1) Download the file from the AS/400 into a new spreadsheet. 2) (optional) If you like, immediately upload it back again, to verify that you actually can do this. 3) Export the data you want to upload into a second spreadsheet. 4) Copy the data out of the second spreadsheet and paste it into the first spreadsheet. 5) Save the first spreadsheet (_DO NOT_ update the file) and close Excel 6) Upload the results hth Mike Naughton Senior Programmer/Analyst Judd Wire, Inc. 124 Turnpike Road Turners Falls, MA 01376 413-863-4357 x444 mnaughton@juddwire.com +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.