I am looking to combine these macros. I need this macro to scrub through a folder and open up each workbook and update the column headings. The only catch is I need the two different tabs to get different headings. The two sheet names within each workbook are called "CRM" and "Aspirational"
Sub...
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...
Hi. I have a spreadsheet where I added macros (attached to buttons) that filter information on a long report based on values in 1 column (the information is a department name). There are 7 different macros for the 7 departments. The code I used is Sub DC_Click()
Sheets("Tasks").Visible =...
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.