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 | 16631 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
Change regional settings from polish to US windows 10
Hi, crossed posted here: Cross The code is: #If VBA7 Then Private Declare PtrSafe Function ...Unanswered | 1 Replies | 49 Views | Created by jaryszek - Friday, February 15, 2019 9:16 AM | Last reply by Ashidacchi - Friday, February 15, 2019 11:30 PM -
0 Votes
In VBA, How to convert variable of Name to variable of Email Address
Hello All, My code creates an outlook appointment from spreadsheet data. I only create one appointment at a time, when needed, by placing my cursor on the appropriate row and ...Answered | 2 Replies | 74 Views | Created by Alan677 - Friday, February 15, 2019 5:20 PM | Last reply by Alan677 - Friday, February 15, 2019 7:05 PM -
0 Votes
In VBA, make outlook appoinment end in one hour
Hello All, I have VBA code that I use to create Outlook appointments based on spreadsheet data and I want to make the appointments I create end one hour after ...Answered | 2 Replies | 35 Views | Created by Alan677 - Thursday, February 14, 2019 9:19 PM | Last reply by Alan677 - Thursday, February 14, 2019 10:09 PM -
0 Votes
VBA is Stubbornly Interpreting 10/12 as Date
I’ve got a collection and a string variable ...Unanswered | 1 Replies | 42 Views | Created by btsDeveloper - Thursday, February 14, 2019 12:29 PM | Last reply by Viorel_ - Thursday, February 14, 2019 7:38 PM -
22 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 | 95 Replies | 85342 Views | Created by Guy Zommer - Thursday, July 19, 2012 4:39 AM | Last reply by Buse Cristian - Thursday, February 14, 2019 1:18 PM -
0 Votes
EXCEL 2010 CONNECTION to SQL Server - Max Parameters for pass through SQL
Connections) I have successfully connected to SQL Server and have included some pass through SQL to retrieve data into the spreadsheet. This has been working ...Answered | 1 Replies | 39 Views | Created by Joe Kelly - Tuesday, February 12, 2019 9:22 PM | Last reply by Joe Kelly - Thursday, February 14, 2019 10:07 AM -
0 Votes
ActiveX Caret Disappears
I have created a worksheet form with several ActiveX controls on it. To save code writing I have added two subroutines at the end of the worksheet VBA module called SetGotFocus and SetLostFocus. (All ...Answered | 2 Replies | 35 Views | Created by phillfri - Thursday, February 14, 2019 6:14 AM | Last reply by Ashidacchi - Thursday, February 14, 2019 6:45 AM -
0 Votes
Aligning rows of data
Hi all, Perhaps someone can answer this question: I have rows of data in two lists in different columns in Excel. Both lists have keys for their indices, these keys are numeric and ... -
0 Votes
Outlook meeting to EXCEL
I want sender email id , now i get only sender (Organizer) name. Please suggest any solution how to get sender email ...Unanswered | 1 Replies | 44 Views | Created by Dineshkshirsagar - Tuesday, February 12, 2019 10:03 AM | Last reply by ryguy72 - Wednesday, February 13, 2019 3:20 PM -
0 Votes
How to download csv files from FTP server using VBA in excel
Hi, I have been going around in circles with this for a few days now and I cant figure what is wrong with my code. Everywhere I search on the internet says the code below should ...Unanswered | 5 Replies | 93 Views | Created by K1985 - Tuesday, February 12, 2019 11:35 AM | Last reply by mogulman52 - Wednesday, February 13, 2019 1:26 PM -
0 Votes
VBA script on a terminal server
i have created a VBA script which runs from a button in outlook through a macro. this works fine on a local outlook install but on a terminal server it does not. the script is looking at a TXT file ...Unanswered | 2 Replies | 78 Views | Created by Firemaster44 - Tuesday, February 12, 2019 10:55 AM | Last reply by Firemaster44 - Wednesday, February 13, 2019 11:36 AM -
0 Votes
Lookup if there is (inCellDropdown) in a sheet
HI I wonder how to lookup using (VBA) if "a sheet" has a cell with (Validation.InCellDropdown=True) and if I could do that, how to get the "selected-value" of ...Unanswered | 1 Replies | 61 Views | Created by Sam1968 - Tuesday, February 12, 2019 1:50 AM | Last reply by Ashidacchi - Wednesday, February 13, 2019 12:55 AM -
1 Votes
How to create a .zip file with VBA in WindowsXP without any third party software?
WindowsXP can open and create a zipped file. How to zip and unzip a file in VBA? Thanks for ur help.Proposed | 10 Replies | 44798 Views | Created by iopcj - Friday, March 23, 2007 2:07 AM | Last reply by Caleyyg - Tuesday, February 12, 2019 6:32 AM -
0 Votes
[Word VBA] How to run code based on drop-down list value selection or change
Hello I am trying to make a program that will do different things based on the selection of a drop-down list (e.g. choose option A in the list, perform action 1 or choose option B ... -
0 Votes
Macros VBA questions - Urgent
Hi all, I want to create a link in excel spreadsheet such that, when the user presses it, it unfolds a certain number of columns (which are ... -
0 Votes
REPLACEMENT FOR COMPONET WebBrowser1 in Visual Basic6/0
Microsoft removed the componentUnanswered | 5 Replies | 106 Views | Created by DONW6 - Friday, February 8, 2019 1:25 PM | Last reply by RLWA32 - Sunday, February 10, 2019 11:58 PM -
0 Votes
MAcro works fine on my computer (Excel 2016) but get an error on another computer (Excel 2013)
Hi, I have code that sorts a data list, when I run it on my computer, which runs Excel 2016, it works fine, but when I run it on another computer (which runs Excel 2013) it gives me an error. Any idea ...Unanswered | 3 Replies | 87 Views | Created by icem101590 - Friday, February 8, 2019 8:32 PM | Last reply by Ashidacchi - Saturday, February 9, 2019 8:31 AM -
5 Votes
Operate scanner from VBA in Excel
Is there a way to activate the scanner using VBA, saving the scan as a pdf with the filename given as the value in the first cell for a given row?Answered | 6 Replies | 21922 Views | Created by Resetter - Thursday, December 8, 2011 5:12 PM | Last reply by rasaint - Friday, February 8, 2019 2:39 PM -
0 Votes
Locale name of folders?
Most of the special folders of the Windows system have locale names. Like the 'Downloads' folder is called 'Overførsler' in Danish. These locale names are stored ...Discussion | 5 Replies | 401 Views | Created by Dan Elgaard - Wednesday, July 12, 2017 7:19 AM | Last reply by tracker12345 - Friday, February 8, 2019 10:49 AM -
0 Votes
VBA Linked List
Is there a way to implement a linked list in VBA? ThanksAnswered | 6 Replies | 116 Views | Created by James N San - Wednesday, February 6, 2019 6:54 PM | Last reply by James N San - Friday, February 8, 2019 4:04 AM - Items 1 to 20 of 15026 Next ›
No announcements
