microsoft

I am trying to combine 2 worksheets from 2 different files using power query (I'm using the 2016 Get & Transform version) but only the worksheet from the first file is extracted. The combine process ignores the other file completely. I have followed the steps described in the Microsoft help...

My access database does not open. Any clue why? I have put refence to Microsoft activeX data objects 6.1 Library. I use Microsoft access 2016: sub copydata() dim accessdb as adodb.connection dim accessdata as adodb.recordset set accessdb = new adodb.connection set accessdata = new...

I have watch many tutorials on this HTML subject, but I'm not understanding why this code is not working. I'm trying to get the Bid Price, and the code runs without error, but prints nothing. What am I doing wrong??? Very Frustrated!!! Please help. Thank you kindly. the URL...

How can I declare the below objects without requiring the need to selecting them in the Tool Refences? Microsoft Internet Controls Microsoft HTML Object Library Microsoft XML, v6.0

Many of our users have been getting errors in Excel with macros that worked perfectly fine in all older version of Excel. Now that they are using Windows 10 and Excel 2016, the "user-defined type not defined" error comes up each time it hits a UDF statement. It is as follows: Function...

Hello everybody. I'm building an automatic process in Microsoft Outlook in "thisoutlooksession" module. Now, I need Microsoft Outlook to open an Excel workbook located in a specific folder. I've developped a code that works fine if triggered in Excel with a regular macro. How can I instruct...

I have a problem with .xlsm files that are saved to SharePoint. Sometimes when I open a file up, I get the error "Can't find Project or Library". I can't view the references as I just get error messages in the VBA editor so I don't know what might be unchecked. I have always thought the file...

Do anyone know if there is a similar personal macro book in microsoft word, where it is possible to store default macros?

Last year I created a spreadsheet with the following formula: =IF(ISBLANK(B20),"",B20*$E$9) entered under the services NOTE cell E9 = 600 <tbody> Qty Service Expenses Total 1 600 20 620 </tbody> =IF(OR(ISBLANK(B20)),"",(D20+E20)) entered under Total OK this has worked until I upgraded...

To save time, lets just assume the Microsoft Trust Prompt after opening a hyperlink will open regardless of trust center settings. I tried automating the prompt with something simple like: Application.Wait (Now + TimeValue("00:00:05")) Application.SendKeys ("{LEFT}")...

Hi what is the type of Selection object? I want to know so I can know which method I can use to call using that object. Microsoft page did not explain what is the type of that object https://docs.microsoft.com/en-us/office/vba/api/excel.application.selection thank you.

Hello everybody. I have a couple of macro that grasp data from the web via IE. Sometimes, in launching them, a page of Microsoft Support opens automatically altering the job of the macro. How can I inhibit this inappropriate opening...

Hello - I have an Excel/VBA app that consistently hangs up for 30-60 seconds when I tab past the last unlocked cell on the sheet. Here are some of the details: - the behaviour is consistent; when the sheet is locked there are a few unlocked cells for data entry that I can tab through. when I...

Hey all, has anyone here tried VBA with other Microsoft programs? 1. I want to make my excel charts automatically go to a word file. 2. I also do meeting notes and am thinking of updating 5 pages in 1 word file, then have each of those 5 pages copied and saved as 1 page each in their own 5...

Hi There I don't know how to download or install programs from the internet. My Excel 16 does not have the following: Microsoft Date and Time control Microsoft Monthly View Control. I need at least one of these controls to do a pop up calendar and it is too complicated for me to download...

Hi All, I'm using an auto save feature to save a document prior to the user exiting. Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error GoTo Error1 MsgBox "AUTOSAVED !!" ActiveWorkbook.Save Application.AutoRecover.Enabled = False Application.Quit...

Hello Guys, Below is my VBA code request, i need to reduce my work load. Place all the files in a folder & run the macro, so all the data will merge in a single master file. Feature: Macro will consolidate the data as per sheet names,example Google --> Google Microsoft...

Hi Everyone, I needed a solution for retrieving data from Access and using my trusty MrExcel “VBA and Macros” book I came up with the below code. This code works beautifully until I close Excel, reopen the File and try to run it again, at which point I get this error. “Run-time Error...

Hi, First time poster/new user. Question: I'm told I can earn 1 college credit through ACE if I complete the Microsoft Excel 77-727 Course & 1 credit for completing the exam, 77-728. I understand the exam is through a third party vendor, however the course 77-727 is supposed to be with...

Hi everyone! Please help me with combining multiple Microsoft Excel Comma Separated Values, I want to combine my 40 csv files in one excel without opening and copy paste them one by one, and everyday our production machine producing this csv file.After creating a macro tool, I hope this tool...