microsoft

There is a Microsoft template that allows you to select a year, then it populates a calendar with dates. It puts each month on it's own tab. I am wondering if there is a way to auto populate a calendar which shows the entire year on one tab. Basically, you'd select a year and starting month...

I need to add a set of instructions to my Microsoft Excel Workbook. I was going to try and do it by just adding text to cells but that is not very user friendly. I tried to embed a PDF file but was not successful. I would like some recommendations or suggestions for how you handle this task...

All, How do I get the calendar to become 1 with the excel cell within the spreadsheet. So if I have multiple users adding information per line: 1) user 1 enters information in each column - gets to the date where Microsoft Date and Time Picker Control 6.0 (SP6) calendar option is located under...

Hello All, I am trying to clean my Microsoft Access database. I have a list of client cases we have closed. But every now and then, my employees will overlook that a client's case is closed and will enter services on a closed case. The data looks like this: Chart# Customer Name...

Hello, I'm wondering, what are the thinking around this question, what is the future of VBA ? From my understanding, Microsoft have deprecated VB and VBA doesn't seems to be taken care of since several years now (5 years, 7 years ?). Also, today is VBA still the way to go when it's about...

hello Everyone, i have a probably a simple problem to the experienced, for me i have been rattling my brain for the past 3 hrs. i am using excel 2016 from Microsoft Suite. My Current Formula...

Hello I've been experiencing a tricky vba problem to which I can't find the solution on Mr Excel or anywhere else... I have an Excel file which opens an Outlook session and builds an email with the TO, CC, and BCC names populated dynamically based upon my selections in the Excel file. 50% of...

I got some solid advice on setting up data connections and using late binding; I've had almost no issues since then. However I have one user who is unable to run a small section of code that basically INSERTS into a database. The error message is: Run-time error '-2147024770 (8007007e')...

I am needing to see how I can get info from a long list of items that has can have multiple items in the query. Here is example of my data: <tbody> store reg os model ram Tech Work Needed 1005 1 Microsoft Windows XP Professional OptiPlex 390 3240 Rick Florke RE-IMAGE MACHINE...

I had developed a pretty extensive Excel VBA based application. I have had to recently reinstall Microsoft Office (Microsoft Office Professional Plus 2010 v. 14.0.7184.5000) and now I have lost a lot of functionality of my application. What I have discovered so far is on my first userform, many...

I’ve read several posts here and elsewhere regarding turning off Com AddIns using VBA, however, I’m getting error messages that aren’t mentioned in those posts. In my code I’ve tried using both the Com AddIn description and the ID For this: Private Sub TitusOff() AddIns.Add("TITUS...

I have a Database where I keep track of tooling inventory I usually paste a LineArt drawing from AutoCadLt into a table called ToolType Recently when I try and paste into the table, the Edit pencil lights up, but nothing. Any ideas? Microsoft Access Microsoft Office Professional Plus 2013