No announcements
-
17 Votes
How 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 | 20261 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
Found 15523 threads
-
7 Votes
How to call Dutch voice Frank from VBA
Hi, I want to let the Dutch voice "Frank" speak my text "Hello World" from a VBA script in Excel or outlook 2019. I am familiar using TTS ...Unanswered | 7 Replies | 611 Views | Created by Herman V - Sunday, December 13, 2020 5:05 AM | Last reply by Herman V - Wednesday, December 30, 2020 8:00 PM -
10 Votes
VBA character encoding problem between PC/Mac
Hi all, I have created some macros and a UserForm in Excel 2010. Since I work in Brazil, I used some latin characters inside my VBA code to change the text in ...Answered | 17 Replies | 18387 Views | Created by Brazilian_Joe - Wednesday, December 21, 2011 1:27 PM | Last reply by LucGM - Tuesday, December 22, 2020 12:21 PM -
34 Votes
Export Content From Outlook 2010 Emails To Excel Spreadsheet
I don't know the first thing about VBA or Access form creation or anything. I am simply searching for a way to transfer data from the body of my emails to Excel so that I can upload them to ...Answered | 181 Replies | 105951 Views | Created by golions - Saturday, March 3, 2012 6:26 AM | Last reply by Pollard Donald - Saturday, December 19, 2020 6:53 AM -
0 Votes
VBA Excel, User input from (Excel add-in) as Parameter in Power Query Editor
Hi I am looking for an Excel add-in solution where the user can manually enter a value. This value needs to become the input for a Power Query Editor Parameter. Can you help me with ... -
0 Votes
Help with Macro to copy Outlook Contact fields
I need to copy each Outlook Contact’s created date to the “Profession” field (if Profession field is blank, because I will re-run this periodically). The reason is that some sync ... -
0 Votes
pesquisa de dados
Boa tarde. tenho uma duvida que não consigo resolver. tenho uma tabela com vários dados A é país B é quantidade c é ... -
1 Votes
Is there a Library to implement VBA in my application?
Hi, I am developing a program in VB.NET. I would like to implement the possibility to use small vba scripts in my tool. Users should be able write some VBA code, lets say ...Unanswered | 1 Replies | 378 Views | Created by NormanBatesThe100th - Wednesday, December 9, 2020 7:21 AM | Last reply by mogulman52 - Monday, December 14, 2020 10:20 PM -
0 Votes
Insert autotext from referenced document
Hi all, I have a vbaCode.dotm file that contains code that I use in all my documents (referenced). To have one letterhead I plan to make a autotext and place it ...Unanswered | 2 Replies | 311 Views | Created by acki4711 - Thursday, December 10, 2020 2:27 PM | Last reply by acki4711 - Monday, December 14, 2020 12:09 PM -
0 Votes
Issue to reposition to other cell
Hi, Code below is involved for the way to jump to relevant sheet when there is a click on cells of specific column. Can T column (of Manifiest sheet) be assigned with proper value ... -
2 Votes
Merge multiple worksheets in one workbook
Hi there, I am using the following VBA code for merging the worksheets in one workbook and macro work fine but the problem is that my excel sheets are arranged in ...Discussion | 2 Replies | 402 Views | Created by SaraPhD - Monday, December 7, 2020 7:16 AM | Last reply by SaraPhD - Tuesday, December 8, 2020 9:03 PM -
1 Votes
SQL to MDX query
Hey friends, I want to pass from this sql query to an MDX query but my MDX load slowly (just keep loading ) this is My SQl ...Unanswered | 1 Replies | 284 Views | Created by Said_Dekk - Tuesday, December 8, 2020 11:28 AM | Last reply by Olaf Helper - Tuesday, December 8, 2020 11:59 AM -
0 Votes
vba to count rows for multiple criteria autofilter on closed excel files and paste count into single new excel
Dear all, For each file in a folder path, apply autofilter criteria and count number of visible rows for column C. Copy the count into another existing excel. For each file, create ...Unanswered | 1 Replies | 429 Views | Created by MickeyMao - Saturday, December 5, 2020 5:14 PM | Last reply by MickeyMao - Sunday, December 6, 2020 3:06 PM -
0 Votes
Minimum Function with variable number of cells referenced
Hi I am fairly new to VBA code so bare with me but I am trying to write VBA code for a minimum function that will contain a variable number of cell references. I ...Unanswered | 1 Replies | 414 Views | Created by Toby.F - Wednesday, December 2, 2020 9:59 AM | Last reply by OssieMac - Friday, December 4, 2020 11:10 AM -
1 Votes
Concatenate whole columns while switching between TEXT/NUMBER formats
00:00:12.630 So far, I have successfully separated the data into two columns (Column F and Column G) with the following: Sub ...Unanswered | 2 Replies | 430 Views | Created by Bandru - Thursday, December 3, 2020 6:45 PM | Last reply by Bandru - Friday, December 4, 2020 2:52 AM -
2 Votes
Issue to point to other sheet
Hi, Any advice to issue like owing to last line below? Should we put exact workbook name to avoid issue? With ...Answered | 7 Replies | 475 Views | Created by Jackson_1990 - Wednesday, December 2, 2020 9:53 AM | Last reply by Peter Thornton (Excel MVP 2008-13) - Thursday, December 3, 2020 2:15 PM -
0 Votes
Convert Text to integer in SSRS Reports
In my database there is a field that stores all integers as text. How do I convert the number to integers on SSRS report I'm developing? I tried CInt but when I run the report I get ...Unanswered | 2 Replies | 383 Views | Created by Kimmie25 - Wednesday, December 2, 2020 8:18 PM | Last reply by Kimmie25 - Thursday, December 3, 2020 12:47 PM -
1 Votes
Excel vba for loop save each ws in wb
Hi i'm new to vba coding so appreciate if anyone could help. I try to run a code for excel sheet. What im trying to do is for it to run the code in loop through specified sheet, for it to ...Unanswered | 3 Replies | 412 Views | Created by excelnoob298 - Wednesday, December 2, 2020 2:56 AM | Last reply by Graham Mayor - Thursday, December 3, 2020 5:51 AM -
0 Votes
How to display exponents 10^9
Hi, How can a display the following number 10^9 in a SSRS report? 66100000000.0000000000 /L Would like to display it in the ...Unanswered | 1 Replies | 423 Views | Created by Kimmie25 - Monday, November 30, 2020 7:12 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Tuesday, December 1, 2020 5:27 PM -
0 Votes
FYI - Issue With Clearing References to Variables
This issue is with Excel 365 (also appears to happen on Excel 2010). I have an addin that creates a few tables and a few charts. I move the charts to their own sheet. I ... -
0 Votes
TreeView_NodeCheck compile error - procedure declaration does not match description of event or procedure having the same name
Hi! I am quite new to programming in VBA, and I have this project in Excel with a treeview. Now, I am using a code (with help from sources I found on the internet) on how to check / uncheck the ...Unanswered | 3 Replies | 404 Views | Created by wiwin21 - Wednesday, November 25, 2020 8:44 AM | Last reply by Peter Thornton (Excel MVP 2008-13) - Wednesday, November 25, 2020 1:30 PM - Items 1 to 20 of 15523 Next ›
No announcements