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 | 17792 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
MS Access VBA - opening Excel files - some with passwords some without
I have an MS Access database that selects Excel files that users have submitted. The files are not supposed to be password protected but sometimes, someone submits one that is password protected. I ...Unanswered | 1 Replies | 172 Views | Created by Don Patton - Orlando, FL - Monday, November 4, 2019 7:25 PM | Last reply by ryguy72 - 11 hours 58 minutes ago -
2 Votes
Sub Workbook_Open() not calculating formulas soon enough
For years I have successfully used a workbook with VBA All of a sudden, the same workbook with the same VBA code throws an error. When the Sub ...Unanswered | 5 Replies | 136 Views | Created by AntSalc - Saturday, December 21, 2019 5:22 PM | Last reply by ryguy72 - 12 hours 2 minutes ago -
0 Votes
Remove top and botttom values from array
Hi. I have a single dimension array with varying number of values. As long as there are at least three values in the array, I want to remove the highest and lowest value. If ...Answered | 3 Replies | 91 Views | Created by RichardSparrow - Thursday, December 26, 2019 9:06 PM | Last reply by Nothing Left to Lose - Saturday, December 28, 2019 1:44 AM -
0 Votes
How to run a outlook macro on both selected email in mailbox and message?
Hi, I want to run this outlook macro on both selected email in mailbox and message. This works on a selected email shown in my ...Unanswered | 1 Replies | 25 Views | Created by Khoo Kok Peng - Friday, December 27, 2019 2:25 PM | Last reply by Hans Vogelaar MVP - Friday, December 27, 2019 3:37 PM -
0 Votes
Request for assistance in VBA Coding
Hi, I have a excel spreadsheet where I need to replace all cell values by (1- cell value). The range is C4 to ED144. I have not used VBA before, therefore I am requesting VBA ...Unanswered | 1 Replies | 68 Views | Created by Sazzad H - Monday, December 23, 2019 2:44 PM | Last reply by Viorel_ - Monday, December 23, 2019 4:37 PM -
0 Votes
How to run multiple PowerPoint on Windows 10?
I am using windows 8.1 and windwos 10. I created an exe file that automatically saves and runs a powerpoint with visual studio ... -
0 Votes
Counting sequence of data
Hi I have the following data (2 column, A and B) on Excel: A ...Unanswered | 3 Replies | 118 Views | Created by babak_sm - Wednesday, December 18, 2019 1:24 PM | Last reply by Ashidacchi - Friday, December 20, 2019 11:32 AM -
0 Votes
help please... a Macro for Word that counts Track Changes (Sub GetTCStats()) yields errors :(
Hi Everyone, I need help in VB since I am not a coder. Translation professionals use Sub GetTCStats() Macro for Word in order to count insertions and ... -
0 Votes
write a function that can create a new list, from which it only picks data with >0 values.
0 (as shown ...Unanswered | 2 Replies | 242 Views | Created by Niznet - Monday, December 9, 2019 9:19 PM | Last reply by OssieMac - Tuesday, December 10, 2019 11:27 AM -
2 Votes
Convert a serie of specific tabs of my excel file into separate CSV files
Hi everyone, I currently work on an excel file with 13 tabs among which 8 only must be exported into separate CSV files. I managed to find a macro which converts ...Unanswered | 5 Replies | 280 Views | Created by charliecoch - Wednesday, December 4, 2019 9:32 AM | Last reply by charliecoch - Monday, December 9, 2019 8:42 AM -
0 Votes
Shortcut F8 for debug step into is not working
Hi All, Thanks for looking into it. Shortcut F8 for debug step into is not working. When I press F8 nothing happens. The screen is ...Unanswered | 8 Replies | 346 Views | Created by Shrinivas Iyer - Wednesday, December 4, 2019 9:41 AM | Last reply by Shrinivas Iyer - Monday, December 9, 2019 1:24 AM -
0 Votes
Is VB6 SP6 required to use MSWinsck.,ocx?
I have Excel 2016 on Win8.1. I'm trying to use MSWinsck.ocx but cannot add it to a VBA Form. I get "Subject not trusted for specified operation" error. I've checked the Killbits and cleared ...Answered | 18 Replies | 819 Views | Created by StupinIs - Tuesday, November 26, 2019 12:59 AM | Last reply by StupinIs - Sunday, December 8, 2019 11:34 PM -
0 Votes
Create a memento of Word 365 Advanced Options
I need to insert Code to record the Advanced Options settings (used to be called Edit Options in previous versions of Word) and then restore them afterwards. Can anyone offer code ... -
0 Votes
VBA Macro Outlook export email + Sender name
" & oitem.Subject 'MsgBox "Sender Email Address -> " & oitem.SenderEmailAddress 'MsgBox "Sender Name -> " & ... -
0 Votes
VBA to move ppt object to a specific location
I am using VBA to push calculations from Access into charts, graphs and tables in a template powerpoint presentation. The objects are manipulated with tables within Access for specific ...Unanswered | 1 Replies | 291 Views | Created by Stacy0609 - Monday, October 7, 2019 3:08 PM | Last reply by William Sessums - Friday, December 6, 2019 3:56 AM -
2 Votes
Error 3340, La consulta " esta dañada. VBA Access 2010
Al ejecutar el codigo: Currendb.Execute "Update Empleados Set Activo=true Where id=5" asi como en todos los ...Answered | 17 Replies | 8182 Views | Created by Luis Carlos H - Thursday, November 14, 2019 12:56 AM | Last reply by XDDDD2 - Thursday, December 5, 2019 12:12 PM -
0 Votes
Dynamic Range VBA
Hi team, i try to create this on VBA excell the source data is other sheet A which has auto refresh ON based on interval time on external resources, so no ...Unanswered | 1 Replies | 247 Views | Created by HARDI.ID - Thursday, December 5, 2019 3:57 AM | Last reply by Hans Vogelaar MVP - Thursday, December 5, 2019 8:52 AM -
0 Votes
Thisworkbook no longer works in UDF but Activeworkbook does?
Can anyone tell me why all of a sudden my Public Functions no longer work and come up with "Automation Error". to Fix it all i need to do is change Thisworkbook to ...Unanswered | 1 Replies | 240 Views | Created by Rob Sizer - Monday, December 2, 2019 5:56 AM | Last reply by Hans Vogelaar MVP - Monday, December 2, 2019 8:47 AM -
0 Votes
Issue: "Variable uses an Automation type not supported in Visual Basic"
Hello, In order to keep the hyperlinks active when hiding the other worksheets I'm trying in VBA to switch from "(General)" to "Worksheet" and then to change ... -
0 Votes
Microsoft Search Feature
The Excel 365 desktop application new has the new microsoft search feature https://docs.microsoft.com/en-us/microsoftsearch/overview-microsoft-search. Is there an idMSo or VBA object ... - Items 1 to 20 of 15307 Next ›
No announcements
