No announcements
Found 17072 threads
-
0 VotesFYI - Issue With Clearing References to Variables
This issue is with Excel 365 (also appears to happen on Excel 2010). I have an addin that creates a few tables and a few charts. I move the charts to their own sheet. I have to make ...
-
0 Votes
TreeView_NodeCheck compile error - procedure declaration does not match description of event or procedure having the same name
Hi! I am quite new to programming in VBA, and I have this project in Excel with a treeview. Now, I am using a code (with help from sources I found on the internet) on how to check / uncheck the ...Unanswered | 3 Replies | 63 Views | Created by wiwin21 - Wednesday, November 25, 2020 8:44 AM | Last reply by Peter Thornton (Excel MVP 2008-13) - Wednesday, November 25, 2020 1:30 PM -
0 Votes
Action based upon any of three fields having data.
1 Then Beep Msg = "Are you taking to Clinical ?" ' Define message. Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define ... -
0 Votes
Fields mandatory
Hello Community, I am creating an excel sheet where if the user has filled a cell in column A, he has to fill input also on column B, C and D, otherwise, he shouldn't be ...Discussion | 1 Replies | 75 Views | Created by alinacm - Monday, November 23, 2020 8:02 PM | Last reply by Viorel_ - Tuesday, November 24, 2020 6:40 AM -
1 Votes
what is the best way to connect SOAP WebServices in vba ?
Hi Friends I am totally new to VBA. Please advice me what is the best way to connect SOAP Webservice through VBA I was given Soap Request XML and asked to connect ...Unanswered | 3 Replies | 202 Views | Created by bSurendiran - Thursday, November 19, 2020 1:21 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Saturday, November 21, 2020 2:35 PM -
0 Votes
Is there a way to send keystrokes to a popup in vba?
I have a requirement to send a password to excel to unlock the current sheet by entering a password to a popupUnanswered | 3 Replies | 118 Views | Created by bnadler4648 - Friday, November 20, 2020 7:43 PM | Last reply by Viorel_ - Saturday, November 21, 2020 9:29 AM -
1 Votes
How to use VBA to View PDF file and use an OCR object?
There are problems to view PDF with VBA. I have 2 questions: 1. How to get text contents from PDF via ...Unanswered | 21 Replies | 39919 Views | Created by MaerDam - Monday, November 19, 2012 11:57 AM | Last reply by Mike Hudson CA - Saturday, November 21, 2020 6:38 AM -
3 Votes
VBA for Microsoft Edge
Hello All, I want to open url in Microsoft Edge or Chrome. Please help me. Regards, Dnyanadeo ...Unanswered | 5 Replies | 9699 Views | Created by Dnyanadeo Jagadale - Tuesday, December 25, 2018 11:53 AM | Last reply by Mike Hudson CA - Saturday, November 21, 2020 6:26 AM -
0 Votes
MACRO HELP!
I am in need of a formula/MACRO to generate responses based upon dependent drop downs. For example: I want to shut down panel 1NHM (located in Branch ... -
0 Votes
-
0 Votes
Debug VBA script that removes resources while keeping costs for MS Project
Sub SanitizeProject() Dim R As Assignment Dim T As Task Dim TempD As Long Dim TempAC As Double Dim TempRC As Double Dim TempC As Double Dim answer As ... -
3 Votes
Printing VBA userform as Landscape
Hi I have tried printing a VBA userform as Landscape, but I can't find out how this is done. I have tried with ...Answered | 18 Replies | 45647 Views | Created by VBAnders - Wednesday, May 13, 2009 11:10 AM | Last reply by vancouver_ron - Thursday, November 12, 2020 4:50 PM -
1 Votes
how to get Now() formated with millisecond ?
Dear all, I need to get the date time return by NOW(9 to be formatted using milliseconds as well, what is the way to do that using VBA ? thnaks for ...Answered | 4 Replies | 2897 Views | Created by wakefun - Monday, April 15, 2019 12:13 PM | Last reply by RHK123 - Saturday, November 7, 2020 4:22 AM -
0 Votes
MS Access 2016 - Run-time error '445': Set fs = Application.FileSearch
0 Then For i = 1 To .FoundFiles.Count 'each file s = ...Unanswered | 2 Replies | 216 Views | Created by VickieVanR - Thursday, November 5, 2020 10:45 PM | Last reply by VickieVanR - Friday, November 6, 2020 4:06 PM -
0 Votes
Issue to copy
Hi, It is not copying full details of sheet through code below. Why? Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name ...Unanswered | 25 Replies | 1127 Views | Created by Jackson_1990 - Thursday, October 29, 2020 2:47 AM | Last reply by Jackson_1990 - Friday, November 6, 2020 2:34 AM -
0 Votes
Update PPT Charts from Excel is not working for MS Office Standard Version
Hello! I have a code that puts data from Excel into PowerPoint to update a Chart. The data is put into the excel file that lies behind the chart. After closing the excel file the ... -
5 Votes
How to reference a function in a vb.net module in a DLL?
I have a VB.NET DLL and am using vba to instantiate classes and read events. That is working fine. However, the DLL includes a Module with a function i would like to use in the vba code as well. How ...Proposed | 7 Replies | 366 Views | Created by Brian Tkatch - Monday, November 2, 2020 9:52 PM | Last reply by Brian Tkatch - Tuesday, November 3, 2020 4:20 PM -
0 Votes
Macro to delete all rows below Specific Text starting from the first blank row found
Hi, I have these massive projects to convert 800 excel files with up to 200 worksheets into a DB. As you can imagine the worksheet is divided into sections and ... -
0 Votes
SSRS Expression to convert numbers to decimals and still maintain text in column
Good Morning, I'm creating an SSRS report that has a column with number and text values. I need to convert the numbers to 2 decimal place and keep the text. How can I do this ...Answered | 3 Replies | 255 Views | Created by Kimmie25 - Tuesday, November 3, 2020 3:09 PM | Last reply by Kimmie25 - Tuesday, November 3, 2020 4:00 PM -
0 Votes
Measures to relieve mental stress through meditation
Measures to relieve mental stress through meditation Today is the 21st century, there is a development in all aspects that cannot be accounted for. But competing ... - Items 1 to 20 of 17072 Next ›
No announcements
