When I create a module in VBA and I'm typing a line of code, it just closes, any solutions?
I'm creating a simple registration system in Excel, I open Visual Basic normally, but when I click on "insert" and then "Module", after 10s Excel closes.
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
how to get the PIVOTBY function working on my excel
how to get the PIVOTBY function working on my excel?
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
why the left column of taskgroup is reduced in customui backstage with excel 2013
Hello everyoneI have a problem in excel 2013 with my additional menu in the bakstage (CustomUI)the left column is not resized customUI> <backstage> <tab id="tabb202401" label="mes tutos sur youtube"…
import pdf to excel
why does only show up by the data tb to click get external data, not to get data, and get the option to get a pdf file?
Date grouping issue pivot table - Excel
I am encountering difficulties adding grouping to date columns in a PivotTable within the attached Excel file. When attempting to drag any date column to the row area, the expected grouping by month, year, or quarter does not appear. Manually clicking…
Excel Differences between two worksheets but worksheets have dependent columns
I need to find a formula that supports the ability to highlight differences between two worksheets. Each worksheet has the same two columns. Those two columns are dependent of each other in order for the information to be correct. I need the formula to…
Excel - VBA macro code to pull outlook files by spesific date range in spesific folder and save as today date
Hi everyone, Need advise from the expert here. I am trying to pull outlook files but the results it extract all the file in that spesific folder. I am trying to only pull all the files on today date. May i know what code should i put so that the VBA code…
How do I change the default font for notes in Excel?
The default font for a New Note in Excel is 'Bold' and I want to set the default to 'Regular'.
How to renew Microsoft 365 Developer licence
I had subscribed to the Microsoft 365 Developer Program, but my subscription has expired and was not renewed. I am seeking assistance to resubscribe to the program
VBA function FileDateTime() is off by 1 hour.
Assuming current date is 06/29/2024 (PDT) and timezone is Los Angeles, the following example is correct. Dim MyStamp ' Assume TESTFILE was last modified on June12, 2024 at 4:35:47 PM. ' Assume English/U.S. locale settings. MyStamp =…
Default File Name when Save As in an Excel Template
I have an already created excel template. I would like to change or update the default suggested file name when you click save as when you open the template from a new excel sheet. This is very similar to updating the Title field in the Properties…
training courses for vBA programing in Toronto Canada
Hi Can you please advise where can I take VBA training courses accredited by Microsoft. It should be located in Toronto Canada. Thank you Adriana
Do I need to be certified in MS Excel Associate before being certified in MS Excel Expert?
I want to have a certificate for MS Excel Expert. However, I am not sure of its requirements or if there are any pre-requisites. I do not have any MS certifications yet. Do I need to take MS Excel Associate or any other certification/exam first? …
I dont see automatization card in excel
private pc
using conditional sumproduct, trabspose
Hi I have a huge data base and need to sort and filter some results I need to calculate " The labour" working hours in multiple tables of ONE SHEET, as…
Office Client - Excel
Hello Please i need your help on this issue. A number of problems browser clocking with certain programs/data refresh is not working in excel and trying to attach file in email. We are getting error message "download failed path doesn't…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
How do I write an excel formula to count the number of times a result occurs in a column for each user (user name in another column of same data set)?
Data Sources: Summary data table which contains a column for employee name and a column for each type of occurrences we want to track, e.g. wrong status or past due date Detail data is on another tab and contains a column with employee name as well as…
Unable to correctly print all tabs/files from Excel that was shared document
I have a user who has access to a shared SharePoint site and user downloaded an excel file on his pc locally. User then attempts to copy and paste 4 certain tabs from the excel file to a new excel file removing any hyperlinks and any attachments. The…
How to embed a video in an Excel Userform?
I want to be able to insert a video into a frame in an excel user form.