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 | 17566 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 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 ...Unanswered | 6 Replies | 296 Views | Created by Luis Carlos H - 17 hours 27 minutes ago | Last reply by dderlis - 7 minutes ago -
5 Votes
Webbrowser control loads outside the VBA userform in excel
We have a VBA form in Excel, which will load a URL to show the login page, when the page is loaded the form opens separately and browser control loads the page in a separate ...Proposed | 13 Replies | 2056 Views | Created by Rajeev6006 - Friday, June 8, 2018 4:49 AM | Last reply by nutsch - Tuesday, November 12, 2019 11:12 PM -
0 Votes
Microsoft.Office.Interop.PowerPoint.Application not working
i use windws 8.1 64bit , visual studio 2013. Imports Microsoft.Office.Interop Module ...Unanswered | 3 Replies | 105 Views | Created by Pada_ - Thursday, October 24, 2019 12:41 AM | Last reply by Ashidacchi - Tuesday, November 12, 2019 9:00 AM -
0 Votes
VBA and Outlook 365
I'm hoping someone can help me with this odd issue. I have a script that will bcc emails I send from a specific account in Outlook. This worked fine until I built a new computer and reinstalled ...Unanswered | 3 Replies | 55 Views | Created by Swizylstik - Sunday, November 10, 2019 3:44 PM | Last reply by Swizylstik - Monday, November 11, 2019 6:17 PM -
0 Votes
Why, oh, Why, does VBA now not recognise Functions such as Right( or Range( ?
Why, oh, Why, does VBA now not recognise Functions such as Right( or Range( ? I have a "button" on the spreadsheet, that initiates this sub-routine ...Unanswered | 1 Replies | 39 Views | Created by RobinClay - Monday, November 11, 2019 12:55 PM | Last reply by Hans Vogelaar MVP - Monday, November 11, 2019 1:05 PM -
0 Votes
Load Chrome in and Access form Instead of IE
It seems the site I am trying to interact with via MS Access & VBA doesn't like the IE internet Control or the AxtiveX version, so I need to load Chrome in a form window. I do not want to ...Unanswered | 3 Replies | 230 Views | Created by Jerry Riggin - Wednesday, November 28, 2018 2:55 AM | Last reply by mogulman52 - Friday, November 8, 2019 11:40 PM -
0 Votes
sum
I want to sum result, here is my code but does not work. Please help. Dim a As Long Dim lastRow2 As ...Unanswered | 1 Replies | 40 Views | Created by SHOVANLAL - Friday, November 8, 2019 7:05 PM | Last reply by Hans Vogelaar MVP - Friday, November 8, 2019 8:04 PM -
0 Votes
How to capture the (Alt+printscreen) screen capture from clipboard and past in to oulook email boday ?
Hi Guys, I am trying to improve a current tool i use at work. we have a excel tracker where I record all data for each job i work with. once i finish inputting ...Unanswered | 2 Replies | 60 Views | Created by Karandana - Tuesday, November 5, 2019 9:32 PM | Last reply by Graham Mayor - Friday, November 8, 2019 1:12 PM -
1 Votes
Copy latest file from one folder to another
Hi Having a folder ”C:\A\” containing lots of files. Want to copy the newest/latest file in “C:\A\” to another folder ...Answered | 2 Replies | 57 Views | Created by ForssPeterNova - Thursday, November 7, 2019 10:05 AM | Last reply by ForssPeterNova - Thursday, November 7, 2019 5:07 PM -
0 Votes
Cannot record macro
in Office 2010 Word, I can View\Macros\View Macros and see all my old ones. I can edit and/or copy these successfully. I cannot Record a new macro no ...Unanswered | 7 Replies | 220 Views | Created by fjchild - Monday, November 4, 2019 3:02 PM | Last reply by Ashidacchi - Thursday, November 7, 2019 6:16 AM -
0 Votes
Excel Workbooks left open inspit of closing all the workbooks
Hello, I am writing a Excel VBA Macro to create a workbook with some data and copy the sheet to another workbook, Once copied, I save the target work book and proceed creating ...Unanswered | 1 Replies | 52 Views | Created by NanaKV - Wednesday, November 6, 2019 1:09 PM | Last reply by Ashidacchi - Wednesday, November 6, 2019 10:58 PM -
0 Votes
How to pull a separate field with range of data
[C] Dim folderPath As String, filepath As String, fileName As String folderPath = "C:\Users\chris\Documents\GSI Documents\Project Health-Sprint Reports\Project Charter ... -
0 Votes
How to use Winsock library or Mswinsck.ocx into VBA excel?
I need to communicate with an instrument that use a TCP/IP communication, and i want to use VBA in excel for that. is there anyone who can show me a good example that send and receive ...Answered | 3 Replies | 14454 Views | Created by Alsamaraee - Wednesday, October 22, 2014 5:26 PM | Last reply by StupinIs - Tuesday, November 5, 2019 10:00 PM -
0 Votes
Advanced filter is not working with vba
Hi, I cant understand why I have no results when running the code, which I recorded. It worked fine with Excel 2010, but is useless in Excel 2016. Sub ...Unanswered | 1 Replies | 65 Views | Created by Deus Irae - Tuesday, November 5, 2019 3:48 PM | Last reply by Deus Irae - Tuesday, November 5, 2019 5:57 PM -
0 Votes
Format Function Error - Expected Array
I keep getting an error when I try to format this number. I've done it in VBA before and I tried to change the SOPID to a variant, a string, and an integer. ...Unanswered | 1 Replies | 119 Views | Created by mongoose00318 - Monday, November 4, 2019 4:02 PM | Last reply by Ashidacchi - Tuesday, November 5, 2019 12:04 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 | 0 Replies | 55 Views | Created by Don Patton - Orlando, FL - Monday, November 4, 2019 7:25 PM -
1 Votes
VB .NET code to read .MSG from a disk and write to CSV file.
Hi I could anybody help? I a novice to VB. I am trying to automate some task using RPA (Robotic Process Automation) tool. This tool allows to insert ...Unanswered | 7 Replies | 276 Views | Created by KodieK - Friday, November 1, 2019 9:43 AM | Last reply by RLWA32 - Sunday, November 3, 2019 3:33 PM -
0 Votes
Add resource automatically by (sub)task name in MS-project
how can I add resource automatically just only sub task Or how can i write VBA code for automatically add resource name just only for some word (i have only 17 ... -
0 Votes
Run code to add rows above cell A1
Hi, Have the follow code to add 4 rows if cell A1 on sheet "raw data file" when i paste value. It is not running, despite the code for add the rows ...Answered | 7 Replies | 373 Views | Created by BrunoClick - Thursday, October 31, 2019 11:42 AM | Last reply by BrunoClick - Friday, November 1, 2019 11:46 AM -
0 Votes
Delete range of rows between "textA" and "textB" on column A if value negative on Column A, same row as text "textB"
HI, New here and starting VBA since 4 weeks. I have data set that need to delete rows with specific text on cells and also between these 2 ...Unanswered | 17 Replies | 180 Views | Created by BrunoClick - Tuesday, October 29, 2019 2:33 PM | Last reply by Hans Vogelaar MVP - Thursday, October 31, 2019 2:13 PM - Items 1 to 20 of 15283 Next ›
No announcements
