Automation of search and extract data from SAP (IM33)

C

Costtx

New Member
Joined
May 15, 2017
Messages
19
I would like to create an excel macro where I can click on a button, and it will perform the following functions:

1. Open SAP Easy Access
2. Open IM33 - Display Budget of Inv.Prog.Position
3. Search terms laid out within specific cells
4. Upon displaying results, copy information displayed
5. Paste into a specified workbook.

I asked the question previously, and was advised that if I use Power Query I can manipulate the data and export it to excel. Can anyone please explain, if this is a resourceful option and how can I perform this function?

Thanks.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
You must log in or register to reply here.

Similar threads

C
  • Question Question
How to automatically paste the data from one sheet to another using VBA
Replies
4
Views
235
Alex Blakenburg
A
W
  • Question Question
Macro/VBA code code for creating new excel file for each pivot table from a column filter
Replies
1
Views
441
Anthony47
A
C
  • Solved
Extracting data with VBA macro button from files in designated folder
2 3
Replies
20
Views
849
Micron
M
J
  • Question Question
Power Query editor OR VBA to extract data from Grants.gov
Replies
3
Views
355
Jagadeshrao
J
B
  • Question Question
VBA Extract data from one Workbook and Transpose Paste to another
Replies
5
Views
1K
DanteAmor
DanteAmor

Forum statistics

Threads
1,223,885
Messages
6,175,187
Members
452,616
Latest member
intern444

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top