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 | 17171 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
Add elements in email body depending on a form
Dear all, I'm calling for charity here as I have basically no knowledge at all in VBA. But I'm sure some of you will find it quite easy. I have created a form in ...Answered | 7 Replies | 413 Views | Created by Chloroplaste - Wednesday, July 17, 2019 2:39 PM | Last reply by Chloroplaste - 33 minutes ago -
1 Votes
Issue: Comparing two dates using FormulaR1C1 with DATEVALUE, IF, or EXACT returns #NAME? until you hit ENTER in each cell
Hi, I am here having problems comparing two dates. If I add a code that adds a comparison formula into a cell, the cell returns #NAME? ...Answered | 3 Replies | 60 Views | Created by Stacy Ryutt - 22 hours 4 minutes ago | Last reply by Stacy Ryutt - 2 hours 20 minutes ago -
0 Votes
Simple comparison in VBA is evaluating incorrectly.
= 0 Then If Target.Value > 1 Then 'since all the cells have % format Call showError(Target) Else ...Unanswered | 2 Replies | 31 Views | Created by Point5Nyble - 5 hours 51 minutes ago | Last reply by Point5Nyble - 4 hours 10 minutes ago -
0 Votes
Could excal vba call third party unregistered DLL?
i'm a C/C++ learner。i want to call my company's third party DLL on excal. it's hard for me to registerer the dll.i want know whether third party unregistered DLL can used ...Unanswered | 2 Replies | 94 Views | Created by wato123 - 5 hours 51 minutes ago | Last reply by Viorel_ - 5 hours 19 minutes ago -
1 Votes
What is the VBA code to insert an Object into an Excel File
Object >Create From File (Display as Icon) functionalily that is available from the Standard Toolbar. My VBA skills are extremely limited and I would ...Answered | 13 Replies | 54281 Views | Created by amanda_m_wilson - Wednesday, July 18, 2007 5:15 AM | Last reply by Omar Mobder - 14 hours 2 minutes ago -
0 Votes
Update statement for a SQL using VBA in Excel workbook
I am trying to update a SQL table on its date field using the VBA code. What I want it to do is recognize the OrderNumber that is on the Excel sheet and match it with the corresponding OrderNumber in ... -
0 Votes
Dynamic clock on a userform
Can I put a dynamic clock on a userform? When a macro shows the userform I want the user to see a live clock ticking over. I also want certain actions to happen on the userform at certain times ...Answered | 2 Replies | 4863 Views | Created by enuenu - Tuesday, May 8, 2007 10:30 PM | Last reply by BruceAiry - Wednesday, July 17, 2019 10:13 PM -
1 Votes
Web Scraping Challenge
Hello all. I'm stuck on something that seems pretty easy, but something is off here. Thus, my question. I'm trying to login to a webpage and click an icon, which is an gif ...Unanswered | 1 Replies | 58 Views | Created by ryguy72 - Wednesday, July 17, 2019 8:22 PM | Last reply by mogulman52 - Wednesday, July 17, 2019 8:52 PM -
0 Votes
Copy and paste web page in excel
Once you have reached a web page in MS edge using CreateObject("Shell.Application").ShellExecute ...Answered | 4 Replies | 129 Views | Created by helloamerica - Saturday, July 13, 2019 7:16 PM | Last reply by helloamerica - Wednesday, July 17, 2019 11:50 AM -
0 Votes
Adding links of files, seperating filenames with Split() - Error: Object variable or With block variable not set
I'm making a program that does many different tasks and using it as an opportunity to get more familiar with VBA. Right now, this code is in a separate file until I get the foundation of the code ...Unanswered | 1 Replies | 66 Views | Created by mongoose00318 - Tuesday, July 16, 2019 1:28 PM | Last reply by Viorel_ - Wednesday, July 17, 2019 6:43 AM -
0 Votes
Locking Auto-Populated Values
Hi, I'm hoping someone can provide some assistance here. Basically; I have created a worksheet on Excel that auto-chooses a product based on a selected amount of inputs and ... -
0 Votes
[Access 2003 + VBA] How to export SQL SELECT Result in Excel file instead of Access ListBox?
Hi, I have VBA Form in MS Access Database, an execute query button run a SQL SELECT query and show result in an external ListBox. What I want is when I hit the ...Answered | 4 Replies | 20702 Views | Created by iboumiza - Wednesday, October 26, 2011 8:44 PM | Last reply by Questsal - Tuesday, July 16, 2019 6:24 AM -
1 Votes
Count specific attachments in outlook
I am not well experienced person in VBA I need to write a VBA code to count attachments in selcted email. I know how to do it for all ...Proposed | 4 Replies | 105 Views | Created by PLKolakoLu - Friday, July 12, 2019 12:10 PM | Last reply by Hans Vogelaar MVP - Friday, July 12, 2019 3:34 PM -
0 Votes
Loop through records in report and compare values
I'm trying to loop through a reports recordset (row) and compare the caption of a control to the value in a field. Nothing I've tried is working. Code Private Sub ...Unanswered | 1 Replies | 95 Views | Created by Loop through records in report - Thursday, July 11, 2019 2:27 PM | Last reply by Viorel_ - Thursday, July 11, 2019 4:37 PM -
1 Votes
Outlook 2007/2010 convert .ost file into .pst using VBA
Hi guys, I know this has been asked before but the threads are aged and not very useful. This is the story: (I'm not a developer) I'm in the ...Unanswered | 6 Replies | 2193 Views | Created by The Modern Mailman - Thursday, July 24, 2014 12:59 AM | Last reply by joseph-morris - Thursday, July 11, 2019 5:50 AM -
0 Votes
Recursive/Array combination with omissions
I am trying to program a way to create an array of combinations of an array. Array = (E, J, LO, Q, R, SS) Obviously ComboArray(1 to 6) = E, J . . . ... -
0 Votes
Using an array to transfer file names into workbook with multiple sheets
What I am trying to do here is pull file names, sort them after parsing their file name (using SELECT to define the different values I am looking for), then transfer those filenames as an ...Discussion | 4 Replies | 126 Views | Created by mongoose00318 - Monday, July 8, 2019 12:03 AM | Last reply by Hans Vogelaar MVP - Monday, July 8, 2019 1:55 PM -
0 Votes
Dim Array
Hi everybody, I want to implement a CommandButton. When you click on this button, it will transfer the numbers from a static array to another worksheet. Can someone help me ...Unanswered | 3 Replies | 168 Views | Created by Jagssss - Tuesday, June 11, 2019 10:01 PM | Last reply by OssieMac - Monday, July 8, 2019 1:52 AM -
1 Votes
Export Outlook eMail content sorted in a table onto Excel
= Range("From_date").Value Then Range("eMail_subject").Offset(i, 0).Value = ...Unanswered | 1 Replies | 104 Views | Created by Julien Fortuna - Thursday, July 4, 2019 8:57 PM | Last reply by Graham Mayor - Saturday, July 6, 2019 8:29 AM -
0 Votes
For loop with counter
Very new to excel and am trying to make a code that will go count up and copy/paste below along with refer to other cells. This is the code I have so far. There are probably quite a few things wrong ...Unanswered | 1 Replies | 124 Views | Created by rachdavis - Monday, July 1, 2019 6:26 PM | Last reply by OssieMac - Thursday, July 4, 2019 6:27 AM - Items 1 to 20 of 15176 Next ›
No announcements
