Created a SAP script to take out report.
Before it goes to work in SAP it does copy of column 1 in specific sheet.
This works fine but if layout changes then the data it is supposed to copy might not be in column 1. Therefore I would like it to search for the name of the column (Purch.Doc.) and then copy it.HTML Code:
I tried below line and It’s not working (I’m new at this…). How can I make it work with simplest code possible?
HTML Code:
HTML Code:
Is it as simple as the full stop (point) at the end of (Purch.Doc.)
This works fine but if layout changes then the data it is supposed to copy might not be in column 1. Therefore I would like it to search for the name of the column (Purch.Doc.) and then copy it.
Sorry, I'm new at this. Don't know what full stop (point) means.Originally Posted by torachan
Last edited by Cuni; 01-21-2021 at 11:36 AM.
Solved. Not even sure what "Long" means but it seems to work...
Instead of
I usedHTML Code:
HTML Code:
Please Login or Register to view this content.Spot the difference in the two codes.Please Login or Register to view this content.
I was trying to subtly point out in post #2.
There was a 'dot' (English - 'fullstop' or American - 'point') missing from the end of "Purch.Doc"
Such a small thing can cause hours of headaches.
torachan.
I get Type mismatch when using below line
HTML Code:
Last edited by Cuni; 01-22-2021 at 03:33 AM.
Final result
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks