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 | 16234 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
Execute SQL Pivot Statement with VBA in Excel
I am trying to execute this statement and cant seem to get it formatted right. THis exact statement works in SSMS so I know it works, but getting the formatting right in VBA ...Unanswered | 3 Replies | 47 Views | Created by ChuckkTN - Friday, October 19, 2018 2:27 AM | Last reply by mogulman52 - Saturday, October 20, 2018 1:39 PM -
18 Votes
Mouse scroll in UserForm ListBox in Excel 2010
Hello, How do I enable mouse scroll in listbox inside a userform (I am using Excel 2010 & windows 7). Thanks, Guy ...Answered | 88 Replies | 80363 Views | Created by Guy Zommer - Thursday, July 19, 2012 4:39 AM | Last reply by Peter Thornton (Excel MVP 2008-13) - Saturday, October 20, 2018 12:12 PM -
1 Votes
Object passes multiple object types to event; how can the event listener declare the object type it knows it will be getting?
I have an ListFetcher object that is acting as middleware. It sends Raise Event events back to the code that created the object and these events, in turn, pass an Object. The middleware doesn't know ...Answered | 3 Replies | 30 Views | Created by Dick Watson - Friday, October 19, 2018 1:04 AM | Last reply by Peter Jamieson - Friday, October 19, 2018 3:47 PM -
0 Votes
What is the issue inside my sqlstring? Sometimes it works, sometimes does not? it shows Runtime error 3141
Dim sqlString As String sqlString = "SELECT target_table420.TraderID, target_table420.Side, ...Unanswered | 3 Replies | 28 Views | Created by Rasel Biswas - Thursday, October 18, 2018 2:18 PM | Last reply by Rasel Biswas - Thursday, October 18, 2018 3:16 PM -
0 Votes
Change Pivot Data Source button
We have protected out worksheets and the Change Pivot Data Source button on the menu is disabled now. is there a way to enable this and still keep worksheet ... -
4 Votes
Date function - can't find project or library
My module won't run, it can't find the project or library, and highlights: the Date function in: MsgBox (Date). This is happening to several VBA functions, but this is the first ...Proposed | 7 Replies | 24577 Views | Created by Lucas Soler - Tuesday, April 28, 2009 6:05 PM | Last reply by 55CF8D90-BEAE-4605-A5E9-BBAA0AF022AB - Wednesday, October 17, 2018 5:36 PM -
0 Votes
the different parsing array to function with () and without ()
hi. i had VBA excel macro that call function and parsing array L = objGeoFlowDLL.GFCalc_Main(nInputs, nOutputs, sngInputs(), ... -
0 Votes
Find and replace a list of words in PowerPoint presentation, including tables, with VBA
Hi all, I have been trying to solve this issue for a couple of days and am very stuck despite googling around a lot, so would really appreciate any ...Unanswered | 1 Replies | 27 Views | Created by Celinedhrn - Tuesday, October 16, 2018 2:42 PM | Last reply by Luca Brasi - Wednesday, October 17, 2018 12:05 PM -
0 Votes
How do I find who has a file open?
Hi all, I am trying to find the username of the person who has an Excel file open. I have seen many posts but they all seem to give me the ...Unanswered | 1 Replies | 49 Views | Created by Gazza101 - Tuesday, October 16, 2018 11:40 AM | Last reply by mogulman52 - Wednesday, October 17, 2018 12:48 AM -
0 Votes
How to get single series chart
Sub test1() Dim MyChart As chart Dim ChartData As Range Set ChartData = ...Unanswered | 1 Replies | 68 Views | Created by Excellearn - Sunday, October 7, 2018 5:52 AM | Last reply by Peter Thornton (Excel MVP 2008-13) - Monday, October 15, 2018 9:27 PM -
0 Votes
Word 2016 can't use vba to check the box "Don't center 'exact line height' lines"
Word→Options→Advanced→ Don't center "exact line height" lines In Word 2013, I can use the following vba to check the ... -
0 Votes
Loop through all Sub Folders and copy data from .txt files
(months from 01 January to 12 December) > within each month is at least three company names > within those company names are varying date folders based upon when said company has sent in the ... -
0 Votes
Javascript to VBA Access
This javascript code is generating a PDF file with json, i wlould like to do that with a button from access, but i don't know how to do that, the IdDocument_ is a ... -
0 Votes
-
0 Votes
VBA to Optionally Introduce a Third Criteria Into Index/Match
I would much appreciate some assistance with the following. I have a worksheet ('Current') comprising almost 3000 rows of data and formulae. I bring data from ...Unanswered | 2 Replies | 81 Views | Created by DaviDWF2 - Friday, October 12, 2018 4:51 AM | Last reply by DaviDWF2 - Sunday, October 14, 2018 1:55 PM -
2 Votes
How to find if the Ribbon is minimized or maximized
CommandBars.ExecuteMso "MinimizeRibbon" will toggle the ribbon to minimize or maximize. Thanks!!!Answered | 6 Replies | 6145 Views | Created by Jam Brew - Saturday, September 28, 2013 2:20 PM | Last reply by ashleedawg - Saturday, October 13, 2018 11:21 AM -
1 Votes
How to use DoCmd.TransferSpreadsheet acExport, to create xlBarStacked Chart instead of xlClusteredColiumns Chart?
Hello. This piece of code: sExcelWB = TrailingSlash(CurrentProject.Path) & "qry_name.xlsx" DoCmd.TransferSpreadsheet acExport, ...Answered | 2 Replies | 58 Views | Created by usekar - Saturday, October 13, 2018 2:07 AM | Last reply by usekar - Saturday, October 13, 2018 11:17 AM -
0 Votes
fm20.dll
The thing is that I need to redistribute fm20.dll with my program which uses it my VisualBasic project. But since this dll ain't redistributable I'm in a little confusion. It is senseless to ask ...Answered | 6 Replies | 29294 Views | Created by Iskander - Wednesday, August 3, 2005 10:46 PM | Last reply by SCADA Shane - Friday, October 12, 2018 7:10 PM -
0 Votes
Error 104 - unable to get the pictures property of the worksheet class
Hello, I'm triying to use a variable so that the layout will be the current week and next week only. But this error appears. "Error 1004 - Unable to get ... -
0 Votes
How to add custom menu option in mouse right click event using vba word?
I'm a newbie in visual basic stuffs. I have a requirement like when some words are selected in the document and hit right click ,macro function should be called. Or something like,have to create ...Answered | 3 Replies | 3013 Views | Created by VidhyaRaju - Monday, December 15, 2014 9:53 AM | Last reply by macropod - Wednesday, October 10, 2018 10:44 AM - Items 1 to 20 of 14912 Next ›
No announcements
