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 | 15769 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 | 2 Replies | 30 Views | Created by James N San - Friday, April 20, 2018 7:11 PM | Last reply by Ashidacchi - 57 minutes ago -
0 Votes
Professional Plus won't run PivotTable VBA code
Some of our customers are using Professional Plus. It will run other macros, but won't run anything with Pivottable VBA code, Not PivotTableWizard ... -
0 Votes
Excel worksheet code issue
I have racked my brain and cannot figure out why this fails. The sheet will work correctly if you select "Close" or click on the upper right hand "X". But when I allow the ontime ...Answered | 4 Replies | 48 Views | Created by Chevyman57 - Saturday, April 21, 2018 4:40 PM | Last reply by Hans Vogelaar MVP - 8 hours 28 minutes ago -
0 Votes
VBA call to open Excel from Access and to open and auto-run macro
I have an Excel 2016 workbook that has a subroutine that executes upon opening the workbook. It works fine. The subroutine deletes some sheets, makes (and names) some sheets, ...Unanswered | 4 Replies | 59 Views | Created by Rock Timbers - Wednesday, April 04, 2018 7:54 PM | Last reply by Rock Timbers - 9 hours 18 minutes ago -
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 | 7 Replies | 117 Views | Created by GertBlan - Tuesday, March 27, 2018 9:19 AM | Last reply by GertBlan - 17 hours 49 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 | 3 Replies | 125 Views | Created by James N San - Monday, April 16, 2018 3:57 PM | Last reply by Graham Mayor - Sunday, April 22, 2018 3:41 AM -
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 | 31 Views | Created by IamJackie - Thursday, April 19, 2018 11:28 PM | Last reply by IamJackie - Friday, April 20, 2018 3:05 PM -
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 | 1572 Views | Created by supersmiley_pe - Monday, December 14, 2015 6:31 PM | Last reply by EdiKITAR - Friday, April 20, 2018 2:19 PM -
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 | 22 Views | Created by ZekeVBA - Wednesday, April 18, 2018 7:48 PM | Last reply by Paul P Clement IV - Friday, April 20, 2018 2:18 PM -
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 | 81 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) - Friday, April 20, 2018 8:49 AM -
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 | 27 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 | 5835 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 | 35 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 | 53 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 | 63 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 | 24 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 | 23 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 | 24 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 | 28 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 | 1873 Views | Created by hansaaa - Sunday, October 20, 2013 1:52 AM | Last reply by robertocabellon - Tuesday, April 17, 2018 2:34 PM - Items 1 to 20 of 14655 Next ›
No announcements
