No announcements
-
17 VotesHow to ask a question efficiently in MSDN Visual Basic for Applications forum?
Thank you for visiting the MSDN Visual Basic For Applications (VBA) forum! :) The online problem solving can be relatively time consuming because it may ...Sticky | 3 Replies | 15765 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
Code to see if worksheet and project is password protected
We have a lot of excel files and I was wondering if there was a way using vba to see if a worksheet is password protected and also if a project is password ...Unanswered | 1 Replies | 19 Views | Created by James N San - 12 hours 21 minutes ago | Last reply by Paul P Clement IV - 11 hours 21 minutes ago -
0 Votes
Add option Explicit and find all undeclared variables
I would like to be able to add Option Explicit to the top of every module and capture all the undeclared variables. Aside from compiling the code and finding the errors the ...Unanswered | 2 Replies | 87 Views | Created by James N San - Monday, April 16, 2018 3:57 PM | Last reply by James N San - 12 hours 23 minutes ago -
0 Votes
Run time error 75/ path file access error
hello Developers! I am encountering this issue on my code: Run time Error 75 path/file Access Error. This is actually a part of a larger set of code that aims to create a file after ...Answered | 2 Replies | 25 Views | Created by IamJackie - Thursday, April 19, 2018 11:28 PM | Last reply by IamJackie - 16 hours 27 minutes ago -
1 Votes
Excel 2016 64bit CopyFromRecordset error (from 32 bit VBA)
I recently moved from 32 bit office 2013 to 64 bit office 2016. In the process, one of my macros stopped functioning (but still functions with other computers running 32 bit 2013). ...Unanswered | 3 Replies | 1566 Views | Created by supersmiley_pe - Monday, December 14, 2015 6:31 PM | Last reply by EdiKITAR - 17 hours 13 minutes ago -
0 Votes
How do I create a textbox with placeholder text (through powerpoint's ActiveX control)?
The idea is that I'd like to prepare some fields for a person to type in, but I'd also like to incorporate some placeholder texts in these text boxes so that the person would know what kind of input ...Unanswered | 1 Replies | 19 Views | Created by ZekeVBA - Wednesday, April 18, 2018 7:48 PM | Last reply by Paul P Clement IV - 17 hours 14 minutes ago -
0 Votes
Mac Excel 2016 Unexpected error (485)
Mac 2016, x64, 365 After Debug/Compile a couple of empty messages appear except for title "Microsoft Visual Basic" and the OK button, followed by a second message ...Unanswered | 2 Replies | 76 Views | Created by Peter Thornton (Excel MVP 2008-13) - Friday, March 30, 2018 2:44 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - 22 hours 43 minutes ago -
0 Votes
VBA MAcro
I have a VBA time clock macro that totals the punches. The Macro was supplied to me by the time clock manufacturer. I would like to add a command to the VBA code to subtract ...Unanswered | 2 Replies | 23 Views | Created by cal5859 - Thursday, April 19, 2018 2:27 PM | Last reply by Ashidacchi - Friday, April 20, 2018 1:33 AM -
1 Votes
WordProcessingML Clean Using VBA Application
Hi All I am working WordML + VBA Application This is Sample WordML File <?xml version="1.0" ...Proposed | 2 Replies | 5834 Views | Created by OrcasKing - Thursday, May 07, 2009 11:56 AM | Last reply by Dossary Fahad - Thursday, April 19, 2018 4:37 PM -
0 Votes
VBA code to enter constant values in every rows if col C contains data
Hello Developers! I have been looking for a code that will enter constant values for every 3 rows in Col A when a certain column has a ...Answered | 2 Replies | 29 Views | Created by IamJackie - Wednesday, April 18, 2018 7:01 PM | Last reply by IamJackie - Thursday, April 19, 2018 3:19 PM -
0 Votes
Last Cell in Row
Hello Forum, I have a Range which the Row is fix (Row 5) and the Col ist variabel and I want to find the last Cell in Row5. ...Unanswered | 3 Replies | 50 Views | Created by Req_En - Thursday, April 12, 2018 7:35 AM | Last reply by Hans Vogelaar MVP - Thursday, April 19, 2018 7:48 AM -
0 Votes
66/12 should be 5 remainder 6
Hello, I'm new to Excel, When I type 66/12 a want the answer =5 with reserve of 6....but I get 5.5 anyone can help thank ...Unanswered | 3 Replies | 62 Views | Created by John321uk - Saturday, April 14, 2018 5:10 PM | Last reply by Ashidacchi - Thursday, April 19, 2018 12:56 AM -
0 Votes
Export document ID data from Sharepoint to Excel
Hi, I'm trying to formulate a documents dashboard on Excel linked to Sharepoint. Looking for that I started exporting data with Sharepoint tools, what is great, ...Unanswered | 1 Replies | 22 Views | Created by Davi Mathielo - Tuesday, April 10, 2018 12:01 PM | Last reply by Davi Mathielo - Wednesday, April 18, 2018 7:31 PM -
0 Votes
vba code to clear cells in 2 columns if it meets criteria
Dear Developers! I am in need of recommendations in my code below. Basically, what it does is to clear cell contents of Col C and D if col A says "XXX".I am having an ...Answered | 2 Replies | 21 Views | Created by IamJackie - Wednesday, April 18, 2018 5:40 PM | Last reply by IamJackie - Wednesday, April 18, 2018 6:03 PM -
0 Votes
Using Match or VLookup from within a macro
I want to lookup a value in a reference table using a key in column 1 and extract the information in the remaining columns (hence the use of "Match" ...Proposed | 2 Replies | 23 Views | Created by Dominique Gascon - Wednesday, April 18, 2018 3:17 PM | Last reply by Dominique Gascon - Wednesday, April 18, 2018 5:09 PM -
0 Votes
Excel VBA Code: Export to PD/ Save to Specific folder on Drive
Hello, So a problem at work came up today. My department is in need of a reporting system that we can use on a shiftly basis while running CMMs (Coordinate Measuring Machines). ...Unanswered | 1 Replies | 21 Views | Created by QualityNerd1993 - Tuesday, April 17, 2018 8:26 PM | Last reply by mogulman52 - Tuesday, April 17, 2018 10:32 PM -
0 Votes
VBA Solver reference, where is it?
References, according to http://social.msdn.microsoft.com/Forums/en-US/2a0a5859-b688-42f5-a953-97fd9f85d4c8/sub-or-function-not-defined?forum=isvvba, but, I can't find any Solver reference. ...Unanswered | 2 Replies | 1857 Views | Created by hansaaa - Sunday, October 20, 2013 1:52 AM | Last reply by robertocabellon - Tuesday, April 17, 2018 2:34 PM -
0 Votes
Access VBA - Excel Cell Value
I am trying to populate a cell with text based on if another is populated. If Cell A2 is not blank, then put "My Text" in cell M2. Do this for every row in Column A ...Answered | 4 Replies | 52 Views | Created by cruiserbill - Monday, April 16, 2018 7:45 PM | Last reply by cruiserbill - Monday, April 16, 2018 8:53 PM -
0 Votes
Access VBA Excel export
I have the below code that is failing at the SubExit xlApp.Visible = True entry. This is configured under a button on a form. When the button is selected it comes up with Error 13 invalid argument. ...Answered | 20 Replies | 128 Views | Created by cruiserbill - Monday, April 09, 2018 7:39 PM | Last reply by cruiserbill - Monday, April 16, 2018 4:02 PM -
0 Votes
Center ChooseColorAPI in center of Application Screen
Option Explicit Private Type CHOOSECOLOR lStructSize As Long hwndOwner As Long hInstance As Long rgbResult As Long ...Unanswered | 7 Replies | 69 Views | Created by Greg Maxey - Thursday, April 12, 2018 6:39 PM | Last reply by James Cone - Monday, April 16, 2018 3:18 PM -
1 Votes
Microsoft Visual Basic for Applications: Automation error, Catastrophic failure in SHARED workbook
Last week we received an update going from Windows7 Excel 2010 to Windows 10 with the MS package 2016. We had a SHARED Excel workbook with some simple macro's (nothing complicated). ...Unanswered | 6 Replies | 107 Views | Created by GertBlan - Tuesday, March 27, 2018 9:19 AM | Last reply by Paul P Clement IV - Monday, April 16, 2018 1:18 PM - Items 1 to 20 of 14654 Next ›
No announcements
