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...
Hello, I am trying to run the following macro from my excel workbook that opens my Microsoft Access database and runs a macro that imports all of my data. It opens access successfully, but then I get the following error:
Run-time error '7866':
Microsoft Access can't open the database because...
I have been set a task to try and use data that is in excel and automatically fill in a template that at the moment has to be manually input. there is no bulk import feature.
In excel i have rows of data, each row has approx 20 fields.
each row with 20 fields has to be manually input into...
I am trying to create my own help file with jpg's and text. I convert the file to PDF and would like to insert a command button to open the associated file to be displayed. Tried writing a vbscript but I could not get it right. Could someone help a beginner?
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.