Search Results

Search found 3613 results on 145 pages for 'outlook vba'.

Page 71/145 | < Previous Page | 67 68 69 70 71 72 73 74 75 76 77 78  | Next Page >

• How to use sqlite from MS Access ?

  - by Phong

  I would like to use sqlite inside MS Access in order to use (transfer would be good enough) the content of sqlite database table in MS-Access. How can this be done in VBA ?

  Read the article

• ArcObjects - enumerating feature classes and datasets within a geodatabase

  - by Tom

  I'm trying to enumerate the contents (feature classes and feature datasets, not interested in tables, etc) of a file geodatabase using vba/arcobjects. I have the file GDB set as an IGxDatabase object, but can't find a way of getting further in. I've had a look at the geodatabase object model and tried using IFeatureClass and IFeatureDataset but neither seem to return useful results. Thanks in advance for any assistance

  Read the article

• How to load single COM instance for multiple application instance

  - by Nimo

  Hi, I'm creating a COM dll and it will be loaded by VBA. However, I noticed that for every excel instance (workbook), a new COM object is loading to memory. But I need to maintain single COM state irrespective of number of Excel instances exists. Please help me achieve this purpose . Thank you

  Read the article

• How to use sqlite database from inside MS Access ?

  - by Phong

  I would like to use a sqlite databse inside MS Access in order to use (transfer would be good enough) the content of sqlite database table in MS-Access. How can this be done in VBA ?

  Read the article

• Can I have a macro in Visual Studio 2005 call a DOS command and redirect the output to a file?

  - by Mark

  I'd like to have a macro in Visual Studio 2005 that calls a DOS command and redirects the output (stdout and stderr) to a file. Just calling the command and "" redirecting it will not capture stderr, so there are two parts to this: calling a DOS command capturing both stderr and stdout to a file during that call I'd then like to open this file in Visual Studio after the command completes. I'm new to Visual Studio 2005 macro writing, and VB/VBA, so that's the kind of help that I'm looking for. Thanks, Mark

  Read the article

• How can I programmatically convert Word doc or docx files into text files?

  - by CheeseConQueso

  I need a way to convert .doc or .docx extensions to .txt without installing anything. I also don't want to have to manually open Word to do this obviously. As long as it's running on auto. I was thinking that either Perl or VBA could do the trick, but I can't find anything online for either. Any suggestions?

  Read the article

• Infopath Attachment Field; Submit in SQL Server

  - by Sunscreen

  Hi all, Is there a way to get the attachment from the form to an SQL Server column using VBA? There are some examples about encodind and decoding attachments, though is this the case? Does SQL server support attachments somehow? Thanks in advance, Sun

  Read the article

• Problem with reading excel cell value to a VARIANT

  - by Nimo

  hi, I'm reading a excel cell value to a VARIANT data type from VBA code. When I enter a integer value to the cell, the VARIANT always takes the argument as type double. Please help me to rectify this problem. Thank you

  Read the article

• ms-excel: bubble trouble - creating amazing looking charts [closed]

  - by every_answer_gets_a_point

  i am reading this article: http://www.juiceanalytics.com/writing/bubble-trouble/ i would like to make a chart that looks like this in excel. is vba a requirement? can anyone help me to start?

  Read the article

• Formula to follow addition of rows

  - by Wayne McCaslin

  New to VBA, please help. I have a range say A2:D10; input causes rows to be added. New entries are being added using NextRow=_. Works perfectly, however, how do I get the formulas in columns C and D to follow each new row being added. I cannot just format entire column due to my sort criteria. Example formula is =IF(ISTEXT($B11),$C$2-$D11,"")

  Read the article

• Find file that could be in one of three locations

  - by every_answer_gets_a_point

  i need to write a vba script that will find a file. the file could be in three different locations how do i find where the file is? the file must have a specific string as part of the file name my file name could be 9424.bas or 9424a.esy or 9424_.bas or 9424...esy, i dotn know what the file name exactly is but i know the important characters 9424

  Read the article

• MS Access 2007 - Property for text box to allow end-user to hit enter for return, not next

  - by Justin

  So I have a form that user's use for data entry, and on one form there is a text box there that is basically used. To enter notes. However, if the user hits i need the cursor to stay in that text box, and start a new line (uh....like word would)....but currently it is jumping to the next control (text box). So is there a simple property setting that would do the trick? Or a VBA method to accomplish? Thanks Justin

  Read the article

• Outline to teach VB6

  - by sinDizzy

  I am in need of an outline on teaching VB6/VBA to some co-workers. The material I am pretty confident I can fill in, just need a sense of how to order the class material. Its not going to be hard core programming [nix the VB6 jokes please :) ] but do want to touch the basics. Any free outlines or even entire presentations out there that I can use? I've been looking but nothing concrete so far. thanks

  Read the article

• Date Difference, Excluding certain Times and Dates

  - by Josefvz

  Hi Folks. I'm looking for a way to determine the difference between two dates. A normal SQL DATEDIFF statement won't cut it because I need to excluded non working Hours and days Namely Weekends and any time between 16:00 - 7:00. Something similar to the NETWORKDAYS function in excel. I'm codeing an excel spreadsheet. Using VBA connect to a SQL server to pull data.

  Read the article

• running query and putting result into a variable ACCESS

  - by every_answer_gets_a_point

  i am running a query from vba editor access: "select max(somerow) from sometable" i want to put the result of this query into a variable. how do i do it?

  Read the article

• Finding The DSN To My Database?

  - by Soo

  I have an SQL database and want to connect to it using VBA in order to support some legacy functionality. I'm using an ADODB connection and need to know what my database DSN is. How can I find this? I'm using SQL Server 2008, thanks! :D

  Read the article

• sending AT COMMANDS

  - by I__

  does anyone know where i can get the official list of all AT COMMANDS available? i would like to get my computer speaking to my cell phone. i need all AT COMMANDS and i will hook it up to either .NET or VBA or anything else.

  Read the article

• ms-access: specifying formatting for a column

  - by every_answer_gets_a_point

  i would like all data that is entered into a specific column to always have a trailing comma and also i need the first character to always be a comma. how do i do this? the best solution is probably not in vba or sql but probably the properties of the table?

  Read the article

• How can I find the number of highlighted chunks of text in an MS Word Document

  - by Majid

  Hi all, I am writing a macro in MS Word which should find all highlighted text in a document and perform some action on each. I am planning a loop to do the search and manipulation part and have no problem with this part of the code. But I don't know how to find how many iterations I'm going to need. Is there a vay to determine the number of highlights in VBA? Many thanks in advance.

  Read the article

• Creating nested bullet list in powerpoint 2007

  - by SuperBloup

  We're trying to create a powerpoint slide programmaticaly. We can obtain bullets on a single level, but playing with tabs and line returns doesn't work for nested enumerations. For now we got : text 1     subtext1     subtext2 text 2 And what we want is : text 1 subtext1 subtext2 text 2 Is there a way to control these using C# or VBA?

  Read the article

• Referencing sheets with spaces

  - by user2250964

  I am having an issue with referencing the sheet name through =Branded!$A$1 Notation in VBA. For a while I have passed in simple sheet names like: Dim SheetName As String SheetName = "Pizza" ("=" & SheetName & "!$A$1") This has worked fine, but recently I passed in "Tier 1" and of course this notation broke. Is there any fix or workaround for this? It Think it's because of the space, the number or both....

  Read the article

• ms-access - someone else's project

  - by every_answer_gets_a_point

  i have been hired to take over a ms-access database. i know sql and vb.net and vba; however i dont have experience with ms-access. this is what it looks like: what steps should i take to start to understand the structure ?

  Read the article

• reading into table: comma values and quotes SQL

  - by every_answer_gets_a_point

  i have a string like this something = "something, something1, "something2, something else", something3" i need it to be read into a table like this: field1 = "something" field2= "something2" field3 = "something2, something else" field4 = "something3" please notice that the double quotes in the something string signified that the string inside the quotes is to be placed in one field anyone know how to do this with an insert into statement or some other way? the answer can be purely sql or can be vba with sql. thanks!

  Read the article

• How to avoid circular reference when excel cell update

  - by Nimo

  Hi, I'm writing a set of functions in c++ which can be called by excel. However, these functions are asynchronous, therefore no immediate return values available. Once a result is available I used a callback function through VBA which update the result to the relevant cell which called the functions. But, here I'm having circular function calling problem, because when I update the cell. excel automatically call the original function once again. Please help me to get around this problem Thank You

  Read the article

• Use same name for local variable and function

  - by Cdl56

  In VBA, I want to use a name for a local variable that I'd also like to use for a function name. The problem I'd that the function name formatting always changes to the local variable formatting. Any way to prevent that?

  Read the article

< Previous Page | 67 68 69 70 71 72 73 74 75 76 77 78  | Next Page >