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 | 17021 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
Using Windows Libraries with VBA (Declare Function, etc) - Best Resources?
So far I've been piecing little bits of information from various sources to try and understand how to use VBA & things like Windows Messages. Since most of that is written in C++, (I know ...Unanswered | 1 Replies | 67 Views | Created by TragicReindeer - 22 hours 38 minutes ago | Last reply by Peter Thornton (Excel MVP 2008-13) - 4 hours 23 minutes ago -
0 Votes
write data to a column(same row) identified by match function
o it writes that data to a column in the same row(9 ) - this works well but I now wish to write this data to a column(still same row) which I identify using 'match' function ... -
4 Votes
How to make vba to read and understand characters in other keyboard language
How to make vba to read and understand characters in other keyboard ...Answered | 10 Replies | 41053 Views | Created by MBMSOFT - Saturday, May 15, 2010 4:17 AM | Last reply by df1354 - Friday, May 24, 2019 6:23 PM -
1 Votes
Can VBA change pages in Microsoft Word's “Read Mode” Layout?
I'm trying to change pages while Microsoft Word is in "Read Mode"* by using a VBA code, and I can't seem to find any function that allows that. (* ...Answered | 2 Replies | 114 Views | Created by MennyB - Thursday, May 16, 2019 3:36 PM | Last reply by MennyB - Thursday, May 23, 2019 9:18 PM -
0 Votes
How calculate the sum of several functions in vba
HI5 folks, I'd like to know how to calculate the sum of one function that has several values from 1,2,3 .... to n the function ...Unanswered | 1 Replies | 71 Views | Created by BRUCEWAYINE - Thursday, May 23, 2019 1:25 PM | Last reply by Hans Vogelaar MVP - Thursday, May 23, 2019 1:37 PM -
1 Votes
create hyperlink address automatically for selected cells using Excel VBA
Dear Experts: I wonder wheter an EXCEL macro can perform the following actions: For the selected cell, e.g. B5 with the ...Answered | 6 Replies | 180 Views | Created by Iamgrateful - Wednesday, May 22, 2019 7:03 AM | Last reply by Iamgrateful - Thursday, May 23, 2019 6:47 AM -
0 Votes
Help on Performance of VBA Code - Excel Hangs
Dear All, Need help with below piece of code, it first searches a Key Word from 1 sheet to sheet 2 containing 10,000 line items, once it finds a match, it copies the cells in the ...Unanswered | 1 Replies | 81 Views | Created by Studio.Suman - Tuesday, May 21, 2019 1:18 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Tuesday, May 21, 2019 9:35 PM -
3 Votes
MS Outlook data to be captured automatically to Excel
Hi, First of all i would like to state here is that i am a non-technical person, i.e. from the Medical background. But, i handle the work of ...Answered | 22 Replies | 8013 Views | Created by Kuljeet Bhambra - Tuesday, July 23, 2013 4:29 PM | Last reply by HugoGTM - Tuesday, May 21, 2019 9:27 PM -
1 Votes
Moving text files into a single excel file
I have a folder full of text files, and I'm trying to consolidate all of the text files into a single excel file. I got this to work once, but then my excel crashed and I lost my code. Here is the ...Unanswered | 6 Replies | 308 Views | Created by jsNeedsVBAhelp - Wednesday, March 21, 2018 8:49 PM | Last reply by ryguy72 - Tuesday, May 21, 2019 1:01 PM -
0 Votes
VBscript for data matching
Hi All, I have a requirment can anyone help how can i achive this with vbscript. Below is my ...Unanswered | 1 Replies | 127 Views | Created by sampy12345 - Saturday, May 18, 2019 12:22 PM | Last reply by Simple Samples - Sunday, May 19, 2019 9:30 PM -
0 Votes
VBA: Merge multiple files into one spreadsheet
I have multiple spreadsheets in a folder with same column names, file names and concatenated dates in it when a new file is created. The macro below is written to combine multiple spreadsheets ...Answered | 2 Replies | 110 Views | Created by IamJackie - Wednesday, May 15, 2019 10:36 PM | Last reply by IamJackie - Thursday, May 16, 2019 9:00 PM -
0 Votes
Retrieving weights from scale as TCP Server
Hi, first, sorry for my english I have a Weight Balances, is a Giropes GI/400, it's connected to my LAN and i can connect via ... -
0 Votes
ADO Recordset empty on 64bit on Office 2016 (excel)
Hi All, Thanks in advance. I am having issues with a script that I am trying to run, as you can see below one query works perfectly but the Query2 shows ... -
1 Votes
sum total of a recordset
Hi all, how to sum the total of a column using VBA programming? The record will be from database (using ...Answered | 4 Replies | 12630 Views | Created by Didier_2000 - Friday, November 25, 2011 12:24 PM | Last reply by tyson scott - Wednesday, May 15, 2019 9:41 PM -
0 Votes
Whats wrong with my code? get run-time error 1004
Hello, I built a code using Macro recording and tried to fix some problems with writing some code myself. the code should: 1. paste a ...Unanswered | 1 Replies | 87 Views | Created by AD12_3 - Wednesday, May 15, 2019 9:01 AM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Wednesday, May 15, 2019 9:13 PM -
0 Votes
HOW TO COUNT THE DIFFERENCE BETWEEN TRIPLETS
Im trying a code for visual basic/ excel to calculate the exact difference of three numbers (tripleTs) in a extremely HUGE sample, in this example im tryIng to find out three numbers (x,y,z) whose ...Unanswered | 2 Replies | 162 Views | Created by BRUCEWAYINE - Thursday, May 9, 2019 4:40 AM | Last reply by BRUCEWAYINE - Wednesday, May 15, 2019 1:55 PM -
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 | 8 Replies | 23131 Views | Created by Resetter - Thursday, December 8, 2011 5:12 PM | Last reply by Vince47 - Wednesday, May 15, 2019 9:30 AM -
0 Votes
VBA to Add Org Calendars into outlook
My office uses outlook calendars for each meeting room. As new people show up, each room has to be added to be able to reserve a room. The default for the Calendars is shared so anyone can ... -
0 Votes
ActiveWindow.View.ShowParagraphs is no effect!
It is impossible to control the display of "paragraph marks" with the following code. Neither "=True" nor "=False" can do ... -
1 Votes
Learning - VBA
Hello I work with Autodesk Inventor which has an option to run VBA macros - I understand this is an older technology but still useful. As thing progress there are ...Unanswered | 1 Replies | 122 Views | Created by PegoAC - Saturday, May 11, 2019 8:19 PM | Last reply by OssieMac - Sunday, May 12, 2019 1:45 AM - Items 1 to 20 of 15132 Next ›
No announcements
