1,495 questions with Office Visual Basic for Applications tags

Sort by: Updated
Updated Created Answers
0 answers

Can Excel VBA identify numbers stored as text, and can it change them to numbers automatically?

Excel identifies numbers stored a text, with a green mark and an associated error button If you tick the error button, you can Excel to change the numbers to be stored as numbers Can this happen automatically?

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2025-02-21T14:43:13.2833333+00:00
Alastair Ching 0 Reputation points
edited the question 2025-02-21T14:48:08.01+00:00
simo-k 2,470 Reputation points
3 answers

Migrate VB.NET Windows Desktop App to Azure

I have created a VB.NET Windows Form desktop application in Visual Studio 2019. The application accesses an Azure SQL DB for retrieval of data only. I would like to migrate the application to Azure such that it could be accessed by multiple subscribed…

Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
831 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2021-09-30T22:20:54.197+00:00
Kenneth Lavallee 1 Reputation point
commented 2025-02-17T14:08:40.5866667+00:00
Joseph Winters 0 Reputation points
3 answers

Word 365 - Hide/ Disable Auto Save Toggle button, Comment Menu, Share Manu

Hi, I am working on customizing Word 365 UI using VSTO Add-in and Custom Ribbon / CustomUI.xml approach. I want to hide or disable following elements on Word 365 UI. Auto Save Toggle button, idMso = AutoSaveSwitch Comment Menu on the…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,277 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-12-09T23:56:55.237+00:00
Hafeez Saleh Muhammad 6 Reputation points
answered 2025-02-10T09:41:11.6033333+00:00
Mustafa Kanorwala 0 Reputation points
1 answer

Please help on Pivot Table Refresh online

Hello, I'm having issue with refreshing pivot tables using Excel Online. The pivot tables are built using data model with data source from the tables in existing workbook. When I refresh manually using "Refresh Selected Connection"…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,277 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,763 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-07-29T16:58:13.097+00:00
PBIX MM 1 Reputation point
commented 2025-01-31T21:18:21.2933333+00:00
Michelle Ran 346 Reputation points Microsoft Employee
3 answers

Datestamps in Excel when a cell value changes

I've already looked up adding datestamps in Excel. Not a problem. I already have a table with data in it. I don't want to display the current date if there is already data in the cell. I only want the datestamp to update when the other cell value…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,763 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-12-20T17:21:58.08+00:00
Daniel Checkman 16 Reputation points
edited a comment 2025-01-28T22:42:56.62+00:00
Paul 25 Reputation points
0 answers

Microsoft Slideshow to create a lottery screen to add macro specified lottery number

As shown in the slides of Microsoft, the scrolling display of lottery numbers can be realized in the specified interface of participating lottery numbers. Now we have a question to ask:

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2021-12-31T01:01:33.437+00:00
刚 朱 1 Reputation point
commented 2025-01-18T12:35:15.8533333+00:00
kalert23 0 Reputation points
1 answer

How to Fix Run-Time Error "5852"

I just completed a mail merge using Microsoft Word. But what I want done after the merge is to save each letter to a pdf individually. I copied the following from a tutorial online and I'm getting a Run-Time Error "5852". I am NOT a VBA…

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-03-10T03:35:05.22+00:00
Charlotte Simpson 1 Reputation point
commented 2025-01-16T10:11:47.3033333+00:00
M.Argirova 0 Reputation points
1 answer

Correspondence Generator with MS Word

The U.S. Navy requires all official correspondence to be within very specific parameters and formatting standards. Is there way to generate a UserForm via Word VBA that could prompt a user to prepopulate an intended letter via the form and have it create…

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2021-04-20T20:15:46.493+00:00
Ozanich, Matthew J LT USN JAL FHCC GRL IL (USA) 6 Reputation points
commented 2024-12-17T07:22:51.5133333+00:00
CLaw21 0 Reputation points
2 answers

MS365 Word VBA Selection.Paste Word Table Run-time error: 4605, but not debug

MS 365 Word VBA Macro Copies table at beginning of macro for use later, then changes original table for desired output. Several sub-routines later, it copies the table from the clipboard. Prior to MS365, this worked without an issue. Now, we get…

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
954 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2021-09-20T12:48:08.11+00:00
Glenn Sasscer 11 Reputation points
commented 2024-12-16T14:13:48.87+00:00
Eugen Dusca 0 Reputation points
1 answer

Can't change Column Width in code in Access datasheet

I thought I've done this before, but it doesn't seem to work now. I'm trying in code to reset the widths of columns in an Access datasheet (based on a query). I can set the .ColumnOrder and the .ColumnHidden properties just fine, but any change I make…

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-03-08T20:05:38.05+00:00
Mark Liquorman 16 Reputation points
commented 2024-11-19T17:09:47.1166667+00:00
Sami 0 Reputation points
0 answers

Numbers spell in excel with three decemals

Hi, can anyone help me with excel to spell number like this ? its for a currency BHD 101.123 = one hundred one Bahraini Dinars And One Hundred and Twenty Three Fils Only. The Fils decimals are three from 1-999

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,763 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-10-27T09:32:48.297+00:00
excel help 11 Reputation points
commented 2024-11-18T11:23:41.7833333+00:00
Ismail Kunju 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to pass an range directly to a C++ DLL/dylib on Excel for Mac?

Hi, I'm trying to extend Excel using C++ on a Mac. I basically want to pass a range directly to a function written in a C++ dylib. So far I have been able to pass arrays of basic types such as Doubles and Integers successfully. However, looping through a…

C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,860 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2021-06-27T04:49:53.577+00:00
Paulo Bueno 96 Reputation points
commented 2024-11-15T04:26:11.7733333+00:00
Paulo Bueno 0 Reputation points
2 answers One of the answers was accepted by the question author.

How to resolve "MSFLXGRD.OCX" or one of its dependencies not correctly registered a file is missing or invalid issue?

Im trying to run an application developed using VB6. When trying to run the .exe I am getting Run time error code "339" with the "Component "MSFLXGRD.OCX" or one of its dependencies not correctly registered a file is missing or…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
12,078 questions
Universal Windows Platform (UWP)
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2021-03-09T17:01:33.39+00:00
Dutch171 31 Reputation points
answered 2024-09-12T10:59:41.4733333+00:00
twinBASIC programming 0 Reputation points
1 answer One of the answers was accepted by the question author.

Migrate VBA to vb6, vb.net, or c++

I have VBA code heavily integrated with Excel and it also creates shapes that will be put into a Powerpoint slide. I want to be able to create an exe file for distribution. What language is best to convert to VB.Net, VB6, C++ ?

C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,860 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,782 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,763 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-12-28T15:59:31.777+00:00
SouthBound 21 Reputation points
commented 2024-09-12T10:39:28.32+00:00
twinBASIC programming 0 Reputation points
0 answers

POST using MSXML2.ServerXMLHTTP60 used to work now ERROR

I am using MSXML object to POST data from an Excel worksheet to a REST API. My VBA macro used to work, now MSXML2.ServerXMLHTTP60 returns an MS error "No credentials were available in the client certificate." The POST request, URL, credential…

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-12-26T20:17:11.62+00:00
rick ales 6 Reputation points
commented 2024-09-04T14:23:45.0133333+00:00
Hima 0 Reputation points
0 answers

Word VBA - Unable to import image from SharePoint

This code works on one PC (PC1) but not another PC (PC2). Sub INSERT_IMAGE_SharePoint() Dim strPicName As String strPicName = "http://MYCOMPANY.sharepoint.com/:i:/r/teams/myteam/toolfiles/test.png" …

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-12-07T02:46:32.903+00:00
Glenn Sanders 1 Reputation point
commented 2024-08-16T00:26:47.6566667+00:00
Daniel Finlayson 1 Reputation point
0 answers

Sending emails in MS Access with Oauth

Hi I have been sending emails to exchange using CDO for years. This basic authentication is being deprecated but I can find no information about how to implement the recommended alternative OAuth in VBA. Does anyone know if it is possible to do this. …

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2021-09-24T13:53:31.383+00:00
Jonathan Crawford 11 Reputation points
commented 2024-08-13T17:31:35.2666667+00:00
Mary FBMG 0 Reputation points
2 answers

OCX issue with Windows 11 Pro verses Windows 11 Home

LED.OCX works great on my Windows 11 Home addition in VBA With Office 2016 Access and VB6 It will not work in office or VB6 under Windows 11 Pro What gives???

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
899 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,801 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-09-13T20:59:39.1+00:00
David Kuhn 1 Reputation point
answered 2024-07-31T16:51:02.5766667+00:00
Albert Kallal 5,496 Reputation points
2 answers

Programmatically call microft print to pdf and dynamically pass filepath and filename information

I have a set of documents that I would like to save as pdf files and place in different network folders. Is there a way to do this programmatically using vba or C#, etc

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2022-11-29T20:19:04.85+00:00
Martin, Brian 1 Reputation point
answered 2024-07-31T04:43:06.7933333+00:00
winironteam 26 Reputation points
7 answers One of the answers was accepted by the question author.

What is the solution for date format in the excel VBA form?

Im still new with the excel VBA. When I key in the date in the VBA form using this format (dd/mm/yyyy), it will interpret automatically as mm/dd/yyyy in the worksheet. My computer system settings for the date format is in dd/mm/yyyy and the excel date…

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,495 questions
asked 2021-07-15T05:28:15.83+00:00
Azim Azrul 41 Reputation points
answered 2024-07-04T06:25:19.1566667+00:00
R. Romero 0 Reputation points