Thread: Updated Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
LCK[_2_] LCK[_2_] is offline
external usenet poster
 
Posts: 8
Default Updated Cells

Hi,

From time to time, I have to perform the same task.. also with SAP.


If you're uploading using txt files, my recomendation here is to upload
everything again; of course, it will depend on whether you have full
privileges to do that. Some companies splits uploads within its
employees.

I also work with huge files of Excel projections. To manage the huge
amount of information I had to created a routine that reads the Excel
files and Writes all the information into the upload files -instead of
using Vlookups, so I no longer have to repair broken links- I don't
care what changed.

Before uploading them, I load all the txt files in Access using a
batch, to test for data integrity, and finally upload the data.

I think you should read this.
http://www.cfo.com/printable/article...4023?f=options

Regards,
LCK