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 | 16411 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
6 Votes
Shell.Application object returns Nothing for Namespace, and works fine if it executed as stanalone script
VBA Code Private Function MakeZIP(fileName As String) Dim fso As Object Dim shellApp As Object Dim zipFileName As String Dim ...Answered | 7 Replies | 21109 Views | Created by izekia - Tuesday, July 1, 2008 10:56 AM | Last reply by Jamie Garroch - 7 hours 56 minutes ago -
0 Votes
How can I sum each element in two array?
Hi, I have a question about array calculation. Is there any function that I can sum elements between two array? I mean I have two array namely A and B.(Dimension of the two array is match.) I want to ...Proposed | 3 Replies | 46 Views | Created by haneolchi - Thursday, December 13, 2018 10:51 AM | Last reply by Steven Edward Wood - Friday, December 14, 2018 3:45 AM -
0 Votes
VBA List reporting result to specific excel column
Good morning, I am new to VBA and I am working on a paperless checklist for my team. Currently, I have an input in VBA where the employee enters a model type. That input then always goes to the first ...Unanswered | 1 Replies | 34 Views | Created by MMoniuszko - Thursday, December 13, 2018 11:41 AM | Last reply by João Henrique Cavalcanti - Thursday, December 13, 2018 8:51 PM -
4 Votes
Application.ScreenUpdating Problems
I've been developing this really massive VBA Excel Application as part of a government contract and it's gotten to be about 55,000 lines of code, optimized down from more ...Answered | 21 Replies | 48555 Views | Created by SethEden - Wednesday, August 15, 2007 3:18 PM | Last reply by JBonser - Wednesday, December 12, 2018 10:55 PM -
0 Votes
WM_DROPFILES in other application from Excel VBA ?
open etc. to open the file in the existing instance of the program. The sendkeys is not super reliable and not very "pretty". The application supports Drag Drop of xml ...Unanswered | 3 Replies | 47 Views | Created by JesperSP - Tuesday, December 11, 2018 9:47 AM | Last reply by mogulman52 - Tuesday, December 11, 2018 2:38 PM -
0 Votes
print out previous line with searched line
anybody knows how to extract searched term and the previous line? i have asked before but it can only read one file at a time and i have to keep changing the text file location (link below). so i ...Answered | 8 Replies | 355 Views | Created by newby486 - Monday, December 3, 2018 7:21 AM | Last reply by newby486 - Tuesday, December 11, 2018 6:43 AM -
0 Votes
cut and paste row data to new sheet and delete the blank row in first shhet
i have one sheet "Al Shab" and when ever column 17 of each row is "completed" drop down box data validation list "completed" &" pending" ...Answered | 8 Replies | 109 Views | Created by DEEPU1980 - Monday, December 10, 2018 1:58 PM | Last reply by DEEPU1980 - Tuesday, December 11, 2018 6:38 AM -
0 Votes
vba to populate message box containing text on a cell in another page
i need to populate a message box with values of column h(comments) while clicking the below range of cells in sheet2 which contains values 10002446 of ...Answered | 13 Replies | 102 Views | Created by DEEPU1980 - Sunday, December 9, 2018 5:30 AM | Last reply by Hans Vogelaar MVP - Monday, December 10, 2018 8:51 PM -
0 Votes
Windows("filename.docx").Activate works but Windows(<string variable of filename>).Activate does not
I had a bit of code in Word set up to activate a specific .docx file already open and perform some formatting of it: Windows("filename.docx").Activate 'some ...Unanswered | 4 Replies | 96 Views | Created by angst987 - Friday, December 7, 2018 11:28 PM | Last reply by angst987 - Monday, December 10, 2018 7:57 PM -
1 Votes
VBA - Filter List Box - From TextBox Search - Run Macro
Hi friends, I am trying to make my TextBox1 work with my ListBox1 to Filter Search ...Answered | 15 Replies | 8580 Views | Created by Dan_CS - Monday, January 23, 2017 3:23 AM | Last reply by 06Kylz - Monday, December 10, 2018 12:08 PM -
0 Votes
Macro to add leading zeros
Hi all, I'm trying to develop a macro to go thru a column of numbers. In this column will be either 8 digit or 10 digit ...Unanswered | 7 Replies | 9854 Views | Created by GB Allan - Wednesday, April 23, 2008 4:15 PM | Last reply by Kaća - Monday, December 10, 2018 12:04 AM -
3 Votes
Disable Keyboard while running Excel macro which opens a Word document
I was wondering if there is a way to disable the keyboard while my macro is running, as i dont want the user to be able to type into the document while Excel is pulling information from ...Unanswered | 15 Replies | 11101 Views | Created by bednsrnsny - Friday, September 3, 2010 2:06 PM | Last reply by adelphiaUK - Sunday, December 9, 2018 4:51 PM -
3 Votes
TextBoxes and Forms2.0 Text box differences
Environment: Access 2007, Win7 HomePremium. I have a table (called T_Notes) which has a main Memo field, with RichText set to true. It has been populated for a few years via the ...Unanswered | 4 Replies | 1986 Views | Created by Vexen_Crabtree - Saturday, June 1, 2013 1:54 PM | Last reply by Vexen Crabtree - Saturday, December 8, 2018 10:20 PM -
0 Votes
.vbs won't run on just one of our pc's
Hi I suspect the issue I am having isn't to do with my visual basic code itself, but more that our brand new PC can't/won't run it correctly, but here ...Unanswered | 5 Replies | 164 Views | Created by wkd intent - Tuesday, November 13, 2018 2:02 PM | Last reply by wkd intent - Friday, December 7, 2018 12:48 PM -
0 Votes
CreateObject error in vba using Citrix environment
Hi My VBA code is currently working fine in local environment using Office 365. Here I trying to create object Set encode = ... -
0 Votes
Display MAP, set PUSHPIN, add PUSHPIN lng. / lat. to record set VBA for MS Access
I have a database project (in MS Access 2016) and wish to add a mapping feature with the following functionality (via VBA is preferred); 1 – Create a ...Unanswered | 1 Replies | 149 Views | Created by mminieri - Wednesday, July 11, 2018 7:00 AM | Last reply by BrewCrew16 - Thursday, December 6, 2018 3:15 PM -
0 Votes
Connectivity between local machine and external excel file using VBA
Hello all, I am trying to pull data from an external excel document from a website to an excel workbook on my local machine. The website requires you to ...Unanswered | 1 Replies | 73 Views | Created by Misaiah - Tuesday, December 4, 2018 7:14 PM | Last reply by mogulman52 - Wednesday, December 5, 2018 12:51 PM -
0 Votes
Update VLOOKUP formula path
I have many formulas that are all using the VLOOKUP function and referencing an external file. For example =VLOOKUP($B$7,'\\server\share\folder1\folder2\[sample ...Unanswered | 1 Replies | 70 Views | Created by James N San - Tuesday, December 4, 2018 6:08 PM | Last reply by OssieMac - Wednesday, December 5, 2018 12:28 PM -
0 Votes
Msgbox Focus Problem In Windows 10
I use VBA 6 (Sax ActiveX Scripting Control, © 1993-2006, Polar Engineering) to write commands for Dragon speech recognition software. These "commands" are small programs ... -
0 Votes
New to VBA - split cell with no clear delineation
The easy answer to my problem is to correct the method with which my company identifies hydraulic hoses but alas... Our P/N has no delineation of spaces, /, -, ...Unanswered | 3 Replies | 117 Views | Created by ALovegren - Thursday, November 29, 2018 5:10 PM | Last reply by OssieMac - Monday, December 3, 2018 11:37 PM - Items 1 to 20 of 14957 Next ›
No announcements
