Search Results

Search found 1188 results on 48 pages for 'vba to c'.

Page 7/48 | < Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >

• Event Log in VBA

  - by Nick

  Is there an easy way to write to and read from the windows event log in VBA?

  Read the article

• Specifying location of new inlineshape in Word VBA?

  - by Branan

  I'm working on a document "wizard" for the company that I work for. It's a .dot file with a header consisting of some text and some form fields, and a lot of VBA code. The body of the document is pulled in as an OLE object from a separate .doc file. Currently, this is being done as a Shape, rather than an InlineShape. I did this because I can…

  Read the article

• Outlook VBA - Find & Replace Incoming Emails

  - by user1912198

  Good morning everyone at Stackoverflow, I am trying to find a VBA script that finds and replaces a certain text in incoming e-mails. So far i've been unable to find such a script that is working. I found several scripts to find and replace stuff in the e-mail but these don't work as a rule on incoming e-mails, they only work on outgoing /…

  Read the article

• Hidden features of VBA

  - by guillermooo

  Which features of the VBA language are either poorly documented, or simply not often used?

  Read the article

• VBA Excel To SqlServer

  - by adrianm

  What is the best way to write VBA code to connect to SQL Server 2005 from Excel? The users of the excel file might run XP, Vista, Win7 and I want to prevent driver installation as much as possible. My understanding is that XP uses MDAC while Vista/Win7 uses DAC. Does that mean that a reference to MDAC 2.8 will not work on a Vista machine…

  Read the article

• can i run c# code from vba macro?

  - by every_answer_gets_a_point

  is it possible to include some kind of libraries inside of VBA that will enable me to use c# functions that i wrote?

  Read the article

• Can an Excel VBA UDF called from the worksheet ever be passed an instance of any Excel VBA object mo

  - by jtolle

  I'm 99% sure that the answer is "no", but I'm wondering if someone who is 100% sure can say so. Consider a VBA UDF: Public Function f(x) End Function When you call this from the worksheet, 'x' will be a number, string, boolean, error, array, or object of type 'Range'. Can it ever be, say, an instance of 'Chart', 'ListObject', or any…

  Read the article

• "Out of Memory" error in Lotus Notes automation from VBA

  - by PowerUser

  This VBA function sporadically fails with a Notes automation error "Run-Time Error '7' Out of Memory". Naturally, when I try to manually reproduce it, everything runs fine. Function ToGMT(ByVal X As Date) As Date Static NtSession As NotesSession If NtSession Is Nothing Then Set NtSession = New NotesSession …

  Read the article

• Create a rich text control field in VBA for Word 2010

  - by mkn

  I have a control field where I dynamically add certain text. That works well so far. The problem is that in one text I have an input field where the user can type in text. I need to hardcode the form text input field into the VBA code. How is this achieved? Or can someone point me in the right direction? In the following code…

  Read the article

• Problem with passing parameters to SQL procedure using VBA

  - by Stefan Åstrand

  Hi, I am trying to pass @intDocumentNo and @intCustomerNo to a stored procedure using VBA but only @intCustomerNo is updated in dbo.tblOrderHead. I don't think the problem is with the procedure because if I enter the values manually it runs properly. What am I doing wrong? VBA Code: Private Sub intCustomerNo_Click() Dim…

  Read the article

• How to parse XML in VBA

  - by dev

  Hi, I work in VBA, and want to parse a string eg <PointN xsi:type='typens:PointN' xmlns:xsi='<http://www.w3.org/2001/XMLSchema-instance>' xmlns:xs='<http://www.w3.org/2001/XMLSchema>'><X>24.365</X><Y>78.63</Y></PointN> and get the X & Y values into two separate integer…

  Read the article

• Find size of dictionary object in VBA

  - by Gershwyn

  What is the simplest way in VBA to determine the size (i.e., number of keys) in a dictionary object?

  Read the article

• loading Data in VBA from a text file

  - by omegayen

  I am not very familiar with VBA but need to use it for a new software program I am using (not Microsoft related) I have a text file that has columns of data I would like to read into VBA. Specifically the text file has 4 entries per row. Thus I would like to load in the column vectors (N by 1). The text file is separated…

  Read the article

• vba: getting list of all files with ESY extension in a directory

  - by I__

  in vba how do i get a list of all the files with a specific extension in a specific directory?

  Read the article

• VBA long overflow

  - by HK_CH

  Hi I am trying to do some maths with my VBA excel (prime factorization) and I am hitting the limit of the long data type (runtime error 6 Overflow). Is there any way to get around this and still stay within VBA? (I am aware that the obvious one would be to use another more appropriate programming language) Thanks for help…

  Read the article

• Using VBA / Macro to highlight changes in excel

  - by Zaj

  I have a spread sheet that I send out to various locations to have information on it updated and then sent back to me. However, I had to put validation and lock the cells to force users to input accurate information. Then I can to use VBA to disable the work around of cut copy and paste functions. And additionally I…

  Read the article

• VBA does not run Powerpoint

  - by user1557188

  This is very frustrating, first lines of programming Powerpoint VBA after a long while .... Please help this is killing me Writing a small sub connecting to an action using name test Sub test() MSGBOX "this is a test " end sub I placed this in a module I just created and it works I copy the same test in…

  Read the article

• Does VBA have an equivalent of "Text To" from Visual FoxPro

  - by David Stein

  Visual FoxPro supports syntax such as the following: Text To VariableName TEXTMERGE noshow select * from..... EndText This assigns the value of all text between "Text To" and "EndText" to the variable. It eliminates the need for multi line statements separateed by "+ ;" Does VBA have something similar?

  Read the article

• Excel VBA and InternetExplorer causing errors on website

  - by SWD

  I have some "clever" users who have written an excel spreadsheet that automates some of their tasks on our intranet/timesheet. It seems as if the instance of Internet Explorer that is created is not doing everything I expect a browser to do, e.g. set cookies. Is there a way to detect if a user is hitting a web site…

  Read the article

• Examples of Optimization in VB/VBA/VB.net?

  - by Lance Roberts

  Please post examples of optimization done in VB/VBA/VB.net? Optimization can be in the context of performance or space/maintainability. Edit: Please specify somewhere in your post which environment you know your technique works in. Thanks.

  Read the article

• VBA IDE Color Scheme Add-In

  - by DonnMt

  Does anyone know of a VBA add-in that would provide more options for the IDE color scheme? It's pretty limited. Thanks for the help.

  Read the article

• How to Pretty print VBA code?

  - by mraviator

  I need to "pretty print" VBA code into a Word document, retaining the color scheme from the VBE editor. I've been looking for free programs or methods to do this, but found nothing usable so far. Any ideas would be greatly appreciated. Thanks

  Read the article

• What is VBA good for?

  - by Kevin Brown

  Besides making macros, what is VBA good for? I'm in an intro programing class for Engineering, and I don't really see any use for it.

  Read the article

• Print UTF-8 with VBA

  - by Karsten W.

  Hello, how can I write UTF-8 encoded strings to a textfile from vba, like Dim fnum As Integer fnum = FreeFile Open "myfile.txt" For Output As fnum Print #fnum, "special characters: äöüß" 'latin-1 or something by default Close fnum Is there some setting on Application level?

  Read the article

• Changing array values in a VBA dictionary

  - by Pawan Jain

  Hi I have a piece of code that does not seem to do what it is expected to do. VBA Arrays are mutable by all means, but it seems that when they are stored into a Dictionary as values of some keys, they are not mutable anymore. Any ideas? Sub foo() Dim mydict As New Dictionary mydict.Add "A", Array(1, 2,…

  Read the article

< Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >