Search Results

Search found 1647 results on 66 pages for 'powerpoint vba'.

Page 14/66 | < Previous Page | 10 11 12 13 14 15 16 17 18 19 20 21  | Next Page >

• How to Lookup For something main VBA

  - by gorPweN

  Hi, I wanna know how to Lookup For many number in a column A corresponding to a name in Column B By coding in VBA..And Write it in column C??? Thanks in advance..Im new in this... Exemple A B C 200-333 Jack 200-345 Lea 200-346 Fresh 200-347 Tide …

  Read the article

• vba: 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…

  Read the article

• sending SMS with VBA

  - by I__

  does anyone know if this is possible? i was able to succesfully run hyperterminal and use it to send texts through my phone which is attached by USB. anyone know how to do it in VBA?

  Read the article

• selecting among duplicated rows in VBA _updated

  - by Elaine Kuo

  I wanna select one row of each duplicated SIDs in a field below. (an attribute table of a shape file) The priority is R S = I 0 Therefore, among SID 87, FID1 will be selected. (SID 88, STATUS will be S+I) (SID 89, FID 6 will be chosen) (SID 90, deleting FID 9 or 10) Please kindly advise VBA cord to run the selection and…

  Read the article

• How to run an equation along whole column in excel vba

  - by Elad Sommer

  I want to run an excel vba which will go down column E and upon finding the value = "capa" will go two cell below, calculate the hex2dec value of that cell, present it by the cell with the value "capa" in column F and continue to search down column E. So far I've came with the below but it doesn't work: For Each cell In Range("E:E") …

  Read the article

• How to compact an MS Access database, while the database is open, using vba

  - by tksy

  I am running a few modules of VBA code. In the middle of running the code crashes as Access reaches its max size of 2GB; but, if I compress the database at that point it is only 200MB. Is it possible to compress the database at regular intervals while the code is running?

  Read the article

• VBA Access Import Specification strange error

  - by captonssj

  I am trying to import a text file into Access using a saved "Import Specification" in my access database using VBA. The import generates the Import Error table showing the errors in the last two fields. BUT if I use the same import specification manually to import the text file, the Import works perfect !!!!! Strange ..... why would they…

  Read the article

• first Occurrence Of Non Blank Cell vba

  - by Madhu Kiran

  Hi, I am trying to write VBA code which works on my Excel sheet. Range("A65536").End(xlUp).Row gives me the row number of the last non blank cell. similarly i am trying to get the row number of the first non blank cell in that particular column. Thanks in advance. madhu

  Read the article

• getting html source with excel-vba?

  - by every_answer_gets_a_point

  i would like to direct an excel VBA form to certain URL's and get the html source and put it in a string. is this possisble?

  Read the article

• Calling a Add-in function from Excel's VBA

  - by graham

  I am using an Excel Add-in for an Erlangs: http://abstractmicro.com/erlang/helppages/ref-erlbblockage.htm I try to call the Erlang-B function within the Add-in from within VBA thus: Function Erl(Erlangs As Double, Capacity As Double) Erl = Application.WorksheetFunction.ErlbBlockage(Capacity, Erlangs) End Function ...but it doesn't…

  Read the article

• Excel VBA File not Found

  - by Brett

  During development of some Excel vba code about every other iteration where I go in and add some code then save the file, the next time I open the thing (it is automatically set to run the code on open) I get a spurious "File not Found" error. To fix it I copy all the code- modules and classes plus the startup code, to a fresh blank…

  Read the article

• How to Trigger a Error from a VBA function

  - by nimo

  hi, I need to trigger(return) an error event from a VBA function, then the calling function of this function can trigger On Error Go to call. E.g function Test() On Error Go to myError: TestErr() Exit Function myerror: Test = "Error Triggered" End Function Function TestErr() ?? 'How to Trigger error here End…

  Read the article

• How to Programmatically Enable Trust for VBA Project.

  - by kumarp

  Getting the following error when trying to open a word document with macros to fill in the form fields: HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Word\Security\AccessVBOM. The user opening the word document does not have admin rights and the AccessVBOM flag is either not available or set to zero. I can set the flag for…

  Read the article

• Creating a POST body in VBA

  - by Moses Ting

  Does anyone know how to construct a POST DATA body in VBA? I'm trying to upload rather lengthy strings via a post call using the "Microsoft.XMLHTTP" object. I'm not tied to using that object for making the HTTP request either.

  Read the article

• Is VBA Type Safe?

  - by Mary-Chan

  It doesn't seem to be. Is that why people still prefix the datatype to variable names in VBA?

  Read the article

• How to use version control with VBA code?

  - by user361283

  I am developing a VBA application which is quite large. I want to use SVN for that application developing. How can I split my modules from the Excel document and how to upload my modules separately to source control? Please help me.

  Read the article

• copy Word document contents without using clipboard (VBA)

  - by keftebub

  I was wondering how to avoid using Windows clipboard, when you want to "replicate" multiple sections of a Word document (using VBA in macros) Why to avoid? Because we're using Word on a server, in a multiuser environment (I know that it is officially frowned upon) Otherwise, this would be easily accomplished with…

  Read the article

• excel vba: setting the formula to equal A or B if not found A

  - by every_answer_gets_a_point

  i have a vba line of code like this: ActiveCell.FormulaR1C1 = "=LOOKUP(""ETG_C"",RC[-10],RC[-8])" i would like to know how is it possible to have the activecell formula be something else in the case that it does not find ETG_C for example: =if(not(LOOKUP(""ETG_C"",RC[-10],RC[-8]))) then…

  Read the article

• vba excel, get start range and end range of a vertically merged cell

  - by vbauser

  Hi.. actually my question is just like the title says.. i need to find out the first cell and the last cell of a vertically merged cell.. lets say i merge the Cells B2 down to B50 how can i get in VBA the start cell(=B2) and the end cell(=B50) ? thanks a lot

  Read the article

• SQL Math in Excel VBA

  - by Scott

  Excel seems to have a problem with doing math in SQL queries. SELECT ( SELECT sum(column) FROM table1 ) + ( SELECT sum(column) FROM table2 ) AS total This technique works completely fine in ASP and ASP.NET. Has anyone had success doing this in Excel VBA? (My database engine is SQL Server…

  Read the article

• How to Lock the cell Data in excel using vba

  - by raam

  I want to stop others from editin the cell contents in my excel sheet using VBA. Is it possible to do this?

  Read the article

• Isn't VBA Shell supposed to be asynchronous ?

  - by Rebol Tutorial

  When I call a rebol script with call shell("rebol.exe myscript.r") The shell doesn't return until the script is finished. Is there a way to force VBA Shell to be asynchronous ?

  Read the article

• Powerpoint missing from DCOM config

  - by Paul Prewett

  I have an application that automates the creation of powerpoint files in an ASP.NET environment. This requires that I install powerpoint on the server and also set permissions in the DCOM configuration snap-in (dcomcnfg) to give permissions to the launching user ([DOMAIN]\ASPNET in this…

  Read the article

• Filling cells with sequential numbers in an Excel (2003) macro

  - by Fred Hamilton

  I need to fill an excel column with a sequential series, in this case from -500 to 1000. I've got a macro to do it, but it takes a lot of lines for something that seems like it should be a single function [something like FillRange(A2:A1502, -500, 1000, 1)]. But if that function exists,…

  Read the article

• IF Statement in VBA

  - by Edmond

  Private Sub sendemail(esubj) Sheets("Actual").Select myfridate = Cells(1, 3).Value myfridate = DateAdd("d", -2, myfdate) myfridate = Format(myfridate, "mm-dd-yy") Sheets("Actual").Select mysatdate = Cells(1, 3).Value mysatdate = DateAdd("d", -1, myfdate) …

  Read the article

< Previous Page | 10 11 12 13 14 15 16 17 18 19 20 21  | Next Page >