Hi
I've done numerous SAP records in the past with no issues, but am having issues with this particular one. Due to the way the SAP page is set up the only way I can extract the data is via the Spreadsheet option in SAP. When you do this option manually it opens up the spreadsheet as a separate workbook to allow you to do what you want with the data. If you do a recording and play this back via Excel vba it does the same.
However.... if I then put in a very simple command in the VBA to do a simple, windows.activate , copy data from that sheet to another (to my main workbook) , the opening of the workbooks does not happen, instead it simply downloads the extract to the PC.
So.. I tried then to replace the windows activate command with an import workbook command thinking it would do the same.. but no , it opens up the workbooks as before so the import workbook function does not work.
This is driving me mad!
Any ideas?
I've done numerous SAP records in the past with no issues, but am having issues with this particular one. Due to the way the SAP page is set up the only way I can extract the data is via the Spreadsheet option in SAP. When you do this option manually it opens up the spreadsheet as a separate workbook to allow you to do what you want with the data. If you do a recording and play this back via Excel vba it does the same.
However.... if I then put in a very simple command in the VBA to do a simple, windows.activate , copy data from that sheet to another (to my main workbook) , the opening of the workbooks does not happen, instead it simply downloads the extract to the PC.
So.. I tried then to replace the windows activate command with an import workbook command thinking it would do the same.. but no , it opens up the workbooks as before so the import workbook function does not work.
This is driving me mad!
Any ideas?
