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 | 14955 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
Unique values copy in Excel Error
I have below code for copying unique values from one sheet to another . But it gives error ...Unanswered | 1 Replies | 15 Views | Created by ChittaPradhan - 11 hours 38 minutes ago | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - 17 minutes ago -
2 Votes
New to Programming: Syntax Error-unable to solve (Macro to format Word tables) Please help!
1 unitsMoved = Selection.MoveDown(Unit:=wdLine, Count:=1, ...Unanswered | 6 Replies | 97 Views | Created by Believe2017 - Thursday, August 17, 2017 8:33 PM | Last reply by Believe2017 - 1 hour 35 minutes ago -
0 Votes
excel not updating cell values while executing vba code
Hello, I have a rather 'big' proces to run in excel (it takes 30minutes) and i want to se the progress (value in certain cells). I use ...Unanswered | 4 Replies | 106 Views | Created by Chris Dr - Friday, August 18, 2017 4:53 PM | Last reply by TinyCrocodile - 4 hours 45 minutes ago -
0 Votes
How to read event log in VBA or vb6?
Hi. How to read system event log in VBA or vb6?Unanswered | 1 Replies | 31 Views | Created by Eva,Hung - 14 hours 42 minutes ago | Last reply by Paul P Clement IV - 6 hours 18 minutes ago -
0 Votes
Userform Does Not Hide Until After the Macro Completes
I am running Excel 2013 on Windows 7. I have a general purpose Userform (used for entering passwords) which is in Personal.xlsb as it is used by several workbooks. I invoke it from ...Unanswered | 2 Replies | 47 Views | Created by Tony_Hedge - Monday, August 21, 2017 8:32 AM | Last reply by Tony_Hedge - 10 hours 40 minutes ago -
2 Votes
Shortcut to stop code exectuion
Hi, VBA code can be executed by F5; but is there a shortcut to stop code, in addition to using the editor button? BobAnswered | 8 Replies | 25496 Views | Created by Bob Sun - Thursday, March 08, 2012 1:06 PM | Last reply by P.B.Rowland - 19 hours 0 minutes ago -
3 Votes
Object library feature not supported (anymore) :( ...
0 colAttachments.Remove 1 Wend Set objAttachment = Nothing Set ...Answered | 16 Replies | 1543 Views | Created by Duncan McCormack - Tuesday, February 07, 2017 11:30 PM | Last reply by mreinsmith - Monday, August 21, 2017 12:55 PM -
0 Votes
Search string in two columns in different excel sheets and copy the matching relevant data
Hi Team, Need vba sub or function for the below requirement. I got three excel sheets, with 5 columns in each ...Unanswered | 3 Replies | 60 Views | Created by Kir4n - Saturday, August 19, 2017 3:15 PM | Last reply by James Cone - Sunday, August 20, 2017 7:18 PM -
0 Votes
HELP!
I am adding a command button to a word document. This document will be used for employees to submit an absence request. When they click on the command button it will email the document ...Unanswered | 1 Replies | 41 Views | Created by beechers - Friday, August 18, 2017 6:26 PM | Last reply by Graham Mayor - Sunday, August 20, 2017 5:00 AM -
0 Votes
How to navigate to the page after clicking on alert ok button in webbrowser control
When I am trying to access an URL ,it is showing login page ,then I am entering credentials and click on submit . A confirmation message dialog appears on the page which is an alert window ...Unanswered | 1 Replies | 41 Views | Created by Amitkkar - Saturday, August 19, 2017 3:24 PM | Last reply by mogulman52 - Saturday, August 19, 2017 8:31 PM -
0 Votes
How to get the frameid or name using webbrowser control
The following setFrameById function's 5th line is showing error "Object does not support property or method".But it is giving the no of frames and showing the frames objects in ... -
0 Votes
Delete Rows containing certain text
Why doesn't the code below work? I need to add about 48 more pieces of text to the string to look for and delete the corresponding rows. The column titles are A through F and F is the ...Unanswered | 3 Replies | 62 Views | Created by ReneeWorks - Friday, August 18, 2017 7:57 PM | Last reply by Ashidacchi - Saturday, August 19, 2017 6:00 AM -
0 Votes
getting a xml content
hi. i am trying execute the code, but shows the error: the object don't accept that property or method Sub TestXML6() Dim XDoc As ... -
0 Votes
Close Access Runtime application using VBS
Hi Guys, i have a code which is opening Access Runtime application: Dim objShell Set objShell = WScript.CreateObject( "WScript.Shell" ...Unanswered | 1 Replies | 41 Views | Created by jaryszek - Friday, August 18, 2017 1:39 PM | Last reply by Kareninstructor - Friday, August 18, 2017 3:38 PM -
0 Votes
How to remove all column fields in a Pivot Table ( Power Pivot)?
<g class="gr_ gr_35 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" data-gr-id="35" id="35">Hello</g> ... -
1 Votes
Check if the column in the workseet is sorter in Descending order, if fails return that row.
Hi All, I am trying to get the code in VBA to check if the particular column in the sheet (tab) is sorter in descending order? If yes, then insert a row into a SQL table saying it ...Answered | 4 Replies | 69 Views | Created by Rahul 11 - Wednesday, August 16, 2017 6:52 PM | Last reply by James Cone - Thursday, August 17, 2017 4:10 PM -
0 Votes
Problem With File System Object and Shell Command
Access 2010 Windows 10 Pro x64 Trying to walk an entire disk and capture file sizes. Ran into a problem with a very long file name (which ...Answered | 4 Replies | 67 Views | Created by saberman - Tuesday, August 15, 2017 8:09 PM | Last reply by saberman - Wednesday, August 16, 2017 6:34 PM -
4 Votes
Problem with scrollbars in VBA Editor
Hello Everyone, I've been coding in the VBA editor for more years than I care to admit. Very recently, I've run into a problem within the editor itself that is new to me. ...Unanswered | 33 Replies | 1174 Views | Created by Richard55Jax - Wednesday, April 26, 2017 3:32 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Wednesday, August 16, 2017 11:50 AM -
0 Votes
SendKeys From Excel
I'm trying to send information to another application using the SendKeys function but it isn't working. The primary code that I'm using is: ActiveWorkbook.FollowHyperlink ...Unanswered | 1 Replies | 4386 Views | Created by Lofe - Thursday, August 10, 2006 4:55 AM | Last reply by fmartino - Wednesday, August 16, 2017 10:36 AM -
0 Votes
Featured Templates - Why is it so locked down?
In a corporate environment, the templates used by knowledge workers may need to be customized, so that the right letterhead, styles, etc. are the company standard. In addition, there may be ...Unanswered | 1 Replies | 65 Views | Created by Joel Finkle - Monday, August 14, 2017 6:21 PM | Last reply by Graham Mayor - Tuesday, August 15, 2017 7:46 AM - Items 1 to 20 of 14207 Next ›
No announcements
