No announcements
-
11 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 | 9433 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
Call javascript function from VBA
I have a javascript function (WriteIDS) that writes values to an Acrobat LiveCycle document. In my VBA code I instantiated a javascript object (jso) and can write out to the JS Console. I discovered ...Unanswered | 2 Replies | 68 Views | Created by DarrellDoesData - Wednesday, February 25, 2015 7:16 PM | Last reply by DarrellDoesData - 1 hour 52 minutes ago -
0 Votes
password for forms
hi, i have a form called departments . one that form i have 5 buttons 1. sales 2 purchasing etc ...Unanswered | 5 Replies | 55 Views | Created by stephen111 - Thursday, February 26, 2015 10:15 AM | Last reply by Cimjet - 6 hours 39 minutes ago -
0 Votes
Registering Visual Basic 2008 Express
I have loaded Visual Basic 2008 Express Version Version 9.0.21022.8 RTM Microsoft .NET Framework Version 3.5 ... -
0 Votes
Sending XML document using WinHttpRequest
Hello I have been given at task to create XML documents, used to request information from a web service API. I am using WinHttpRequest. I have written ...Unanswered | 1 Replies | 50 Views | Created by smsemail - Thursday, February 26, 2015 10:08 PM | Last reply by Starain chen - 15 hours 47 minutes ago -
0 Votes
Getting Type Mismatch Error while passing Array of Interfaces from C#(VSTO) to VBA through IDispatch interface
Hi, I am facing issues like Type Mismatch while passing Array of interfaces from .NET to VBA and vice versa using VSTO technology. My requirement is that ... -
0 Votes
macro to open and save as a value in a cell
How can I create a macro (I've named it Test) that will: 1.bring up the open dialogue box (to allow the user to choose a file) 2.save ...Unanswered | 1 Replies | 34 Views | Created by cjf2002 - Thursday, February 26, 2015 10:32 PM | Last reply by Cimjet - Thursday, February 26, 2015 11:15 PM -
0 Votes
Unreleased Memory on Property get for Shape.OnAction On Excel
Hello, I've got a macro reading a shape's OnAction property . It's looping, and I saw that Excel keep a lot of memory without release it. Here ...Unanswered | 29 Replies | 1098 Views | Created by Denis FRAIPONT - Tuesday, April 30, 2013 10:09 AM | Last reply by Felipe Costa Gualberto - Thursday, February 26, 2015 10:18 PM -
0 Votes
button option
hello, i am new in vba access and i have problem with using radio button. I have form which it use to answer questions yes/no. I have two radio button that have (yes/no) and have button to check ... -
0 Votes
Looking for advice and solutions to linking desktop excel workbook to update sharepoint workbook by multiple users with VBA
I have been using VBA to automate spreadsheets forever and we typically use a NAS device that we all have access to in our office. We have evolved and spend more time on the road then we do in the ...Unanswered | 0 Replies | 28 Views | Created by BrianPCapstream - Thursday, February 26, 2015 2:49 PM -
0 Votes
How to find cached DISPID of scrrun.dll
Hi, I want to use cached DISPID binding concept in exel vba so how to find DISPID of scrrun.dll. Also how i can find DISPID of any other components like dll ... -
0 Votes
reteriving text from a text box
Im trying to write a progam that takes text out of a text box named data5 that is in a excel document that which I have defined as workbooks(fileName).worksheet(1).I want to take that string ...Proposed | 4 Replies | 82 Views | Created by Dose87 - Monday, February 23, 2015 6:30 PM | Last reply by Blackwood - Wednesday, February 25, 2015 8:16 PM -
0 Votes
How to use cached DISPID Binding in excel vba ?
Hi All, I trying to call soap service in excel using vba so please provide some syntax or code to consume soap service using Cached DISPID Binding. Also how/where ...Unanswered | 1 Replies | 47 Views | Created by Balaramji - Tuesday, February 24, 2015 2:49 PM | Last reply by Caillen Zhong - Wednesday, February 25, 2015 7:31 AM -
0 Votes
Insert paragraph break before images
I am trying to create a macro that inserts paragraph breaks before each image in a file. Any ideas? I've tried to macros people have created for similar functions, but I can't seem to get it right.Unanswered | 1 Replies | 42 Views | Created by JSoule - Tuesday, February 24, 2015 8:36 PM | Last reply by Graham Mayor - Wednesday, February 25, 2015 6:26 AM -
0 Votes
STATIC TIME STAMP IN MULTIPLE COLUMNS
I have a single spreadsheet for Monday - Friday. There are multiple columns for each day. It has been asked of me the following: When the customer name is typed for the ...Answered | 3 Replies | 40 Views | Created by WoodLinda - Tuesday, February 24, 2015 4:14 PM | Last reply by Hans Vogelaar MVP - Tuesday, February 24, 2015 8:15 PM -
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 | 5 Replies | 21197 Views | Created by Iskander - Wednesday, August 03, 2005 10:46 PM | Last reply by DigitalMug - Tuesday, February 24, 2015 1:29 PM -
2 Votes
VBA CopyText Command
Hey, I'm trying to get a command to work for a userform. What I have so far is: Sub CommandButton1_Click() ...Unanswered | 11 Replies | 154 Views | Created by JKyleO - Wednesday, February 18, 2015 10:15 PM | Last reply by Rod Gill MVP - Tuesday, February 24, 2015 1:07 AM -
0 Votes
an error that says Unable to get the object property for the OLEObject class
Good day Our clients are suddenly experiencing a problem when running an excel model we gave them. The model was running very well until recently when they start experiencing ...Unanswered | 1 Replies | 53 Views | Created by Gaddafim - Monday, February 23, 2015 8:31 AM | Last reply by Rod Gill MVP - Monday, February 23, 2015 7:47 PM -
0 Votes
Using VBA to open a passworded VBA module with the password.
Hi I need to make some changes in a VBA module (search and replace a hard coded file path created in VBA) however in some of the files in the VBA modules are ...Unanswered | 2 Replies | 65 Views | Created by Binnz - Monday, February 23, 2015 10:22 AM | Last reply by Rod Gill MVP - Monday, February 23, 2015 7:43 PM -
0 Votes
32 bit and 64 bit code
i need to add code to allow both 32 and 64 bit Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, _ ...Unanswered | 10 Replies | 169 Views | Created by STARFALLS - Tuesday, February 17, 2015 1:24 PM | Last reply by Rod Gill MVP - Sunday, February 22, 2015 8:13 PM -
0 Votes
VBA How to download a generated file from IE
Hi guys, Apologies if this is an easy one, I couldn't find anything that helped me with my problem and was hoping someone might point me in the right direction for which ...Unanswered | 7 Replies | 187 Views | Created by Jeff simply - Monday, February 16, 2015 11:21 AM | Last reply by ryguy72 - Friday, February 20, 2015 4:44 PM - Items 1 to 20 of 12482 Next ›
No announcements
