microsoft

Hello Everyone, After running a sub that transfers information to another workbook, I occasionally get this error message generating that: Is there a way that I can clear this message out in a similar way that: Application.CutCopyMode = False 'Clear Clipboard Clears the Clipboard...

Does Microsoft Excel offer a list for all shortcuts? I know there has to be about a million of them.:laugh:

Please I need help for this error,Please Help me anyone

Hello, I uninstalled, Microsoft Office and reinstalled. Still cannot assign a hyperlink to a cell. I cleaned my PC of any Microsoft Office file (used the cleanup Office Microsoft utility) still have the same problem. right click, add hyperlink, and press return. right click again and it's blank.

I'd like to use funkcion IIF in microsoft query ODBC database . I wrote "IIF(resn70='4';0;lqty70*litr35/iscf35/100)" Bat a message appears "SQL0104-Token = is not valid" Please help

Ok, I have super simple code and it refuses to work. I've used this code several times before on other workbooks and has done wonderfully. Sub Worksheet_Change(ByVal Target As Range) If Target.Address.Value = "$A$1" Then Call MyMacro End If End Sub Application.EnableEvents = True (I've triple...

Hello: I have decided to learn macros and I have bought book called “VBA & Macros for Microsoft Excel” Bill Jelen, Tracy Syrstad. This book is great, but I have tried to find out where to download the samples files to play with them, e.g the book is asking me to open file called INVOICE.TXT.I...

Hello everyone, I am having a random issue with Excel. Usually, in order to copy visible cells only I'd have to use Alt + ;. Now, it seems to be doing this automatically. Is this a setting I've inadvertently enabled, has Microsoft done an update, or am I just crazy? Thank you.

I have the following in formula in a Microsoft query. The formula works fine. I would like to rename the column so it displays as a name rather than the formula. DateDiff(Day,ProdPattern.ProductionMonth,DateAdd(Month,1,ProdPattern.ProductionMonth)) I have tried...

Hi, I have a workbook with about 40 modules and forms etc, but it is made in excel 2003. It runs ok in excel 2007, but I get a lot of errors in vba when trying to open in excel 2010. I checked the references in the vba editor, and I found that I don't have the following refs in excel 2010: 1)...

I have used Excel 2010 for years - does everything I need. I have hundreds of excel 2010 spreadsheets. Brought home a file from work to troubleshoot - work uses Excel 2016. Now all my excel sheets have been "disabled" by Microsoft. They want me to purchase MS 2016. I've tried entering the 2010...

Whenever I run a certain macro, it gives me an error that says "Microsoft Excel has stopped working" (see picture underneath). The macro finishes to the end, but then I get this error. Does anyone know about this error and how I can prevent this error?

Hello everybody. I'm navigating IE via VBA to reach a web site and download a file. No problem about navigating the site, neverthless I can't interact with the popup “Do you want to open this file?” (I use IE9). So, I've tried to travel the API road for the first time in my life in order so...

Afternoon all, I have several files that open perfectly on my machine but when a few others open, it causes theirs to crash. The file is set up in office 2016 and the person who is having the problem is using Office 2015. I notice in my project library that I have Microsoft Office 16.0...

Hi, I'm looking for a way to parse a REST API in JSON format without any external modules (like from GitHub). Similar to libraries "Microsoft WinHTTP Services, version 5.1" or "Microsoft XML, v6.0" to parse an XML response, what library contains methods to parse JSON format? And what would be a...

I write code at home and work. Home computer needs Microsoft Word 15.0 Object Library. When I program at work the reference changes to Microsoft Word 16.0 Object Library. Then the program hangs when back at home. After searching I learned that I should use Late binding. The problem is that in...

Let's say I have 3 columns - of which A and B contain multiple records of the name. Column A = Color Column B = Manufacturer Column C = A number What I'm looking for is if Column A = "Green" AND Column B = "Microsoft", return the 5th highest value in Column C. (which obviously matches my...

I have this extensive and huge model that has run multiple times without issues (macro runs). Every so often it crashes stating "Microsoft excel has stopped working, windows can check online for a solution and recover your information". The last time I experienced this, a solution was to start...

Hello Everyone, I'm working with in using this code below that I've recorded to download a file know as . CODE1: Sub Macro2() ' Sheets("Worksheet5").Select With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array( _...

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...