ECEstudent
Registered User.
- Local time
- Today, 09:22
- Joined
- Jun 12, 2013
- Messages
- 153
Hi guys, I am really stuck on this and I would appreciate any help. What I have been doing in my code so far is importing an Excel sheet's data into an Access table in order to use the values imported for calculations. The end result of this code and all of the calculations in it, is a value named 'Item Quantity'. But now I want to take the next step and instead of the user manually taking each item quantity that matched with the values imported from excel and putting them into their correct places in the same Excel file that was imported at the beginning, I want to automate that process. So to be more clear, I need to export back those resulting item quantity values back into that same Excel file under column 'Installed Base' and row...well, I'd be also having to collect the row that the imported values were imported from.
For example:
If I imported 3 values from that table and the first of those values was collected from row#3, then the item quantity would be exported to (of course a different column called) 'Installed Base' but the row would stay the same.
Any advice? I found this good source but I think you have to already know the row that you are exporting the values to. I wouldn't know, bc I'd be automatting the process as well as with each different excel file, different row values are getting imported/exported to.
For example:
If I imported 3 values from that table and the first of those values was collected from row#3, then the item quantity would be exported to (of course a different column called) 'Installed Base' but the row would stay the same.
Any advice? I found this good source but I think you have to already know the row that you are exporting the values to. I wouldn't know, bc I'd be automatting the process as well as with each different excel file, different row values are getting imported/exported to.