Hi Excel-wizards!
This is my first post having been a distant follower for a while - so go easy on me ;)
I have a number of .xls workbooks which have lots of files inserted into them (Insert>Object>Create from file>Display as icon). These files are usually .pdfs but there’s often others...
Hello All - Firstly, I need to apologize for the background noise. I am sitting in a tavern editing a lengthy list from a recovered hard drive. It wasn't until I played the video back that I realized how noisy my environment is. BTW - This same environment is protecting me from chronic tedium...
We're moving from Windows 7 Pro to Windows 10 Enterprise. I'd like code in my workbook to work under either environment, meaning I need to determine which environment a user is in and adapt my code accordingly.
Thoughts?
I currently have various email addresses in my workbook.
However, when clicking on the address they are opening in my Office 365 Environment. I need the links to open in Outlook 2016.
Any Ideas how to force this?
Hi Everyone,
Now I know this is probably a well asked question but I'm looking for the most efficient way to extract data from Access. In my scenario I use Access as an input tool in a multi user environment with an Excel report which needs to pull the data in. Does anyone have any ideas of...
I tried hunting for this issue and couldnt find an answer hopefuly the forum can help.
I finaly learned not to work directly in the production environment. I created a dupilcate file on my desktop so I can verify the codr functions before being it over to main user file.
The code...
This is some work from an employee that left. There is one sheet with a large table in it. Columns A-->Q 1400 rows. On of the Columns is labeled "Environment". Now in the pivot the Rows quadrant has three things in it:
Month
Environment
Environment2
Environment2 seems to be a calculated...
I have a VBA module for which the ultimate goal is to write an Excel file into a specific folder. That folder resides on a networked shared drive and has controlled access via the user's LAN ID.
So that the file is not lost in the event that a user is not authorized to read or write to the...
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.