Search Results

Search found 33029 results on 1322 pages for 'access vba'.

Page 17/1322 | < Previous Page | 13 14 15 16 17 18 19 20 21 22 23 24  | Next Page >

• Should I use Call keyword in VB/VBA?

  - by Fred Loyant

  I use the Call keyword used when calling subs in VB/VBA. I know it's optional, but is it better to use it or leave it off? I've always thought it was more explicit, but maybe it's just noise. Also, I read this on another forum: Using the Call keyword is faster because it knows that it is not going to return any values, so it doesn't need to set up any stackspace to make room for the return value.

  Read the article

• Naming convention for VBA modules?

  - by EdOxH

  I never really know how to name VBA modules. Should I: Use a prefix, like basName or modName. Not use a prefix, like Module. (But avoid restricted words) Something else

  Read the article

• VBA Functions in Excel

  - by teeharpee

  I have an Excel spreadsheet. One of the columns in the spreadsheet contains the name of a pdf file; page number (name of file;5). I would like help with writing a VBA function so that when the user clicks in any of the cells in that column the name of the file and the page number are passed as variables and the pdf file opens to the page specified. Any help greatly appreciated.

  Read the article

• vba code for excel - to encoding gibrish to hebrew

  - by omri

  i have files that open with excel. when i open the file the text is like gibrish. i need to encode - tools-internet option - general-encode - hebrew iso-visual and then the file turn to hebrew there is a vba code that do that ? thanks, omri

  Read the article

• How to Add Date Picker To VBA UserForm

  - by user1760110

  I am looking for a control to add to userForm to enable user to pick the date.I a good one at this address Formatting MM/DD/YYYY dates in textbox in VBA from Siddharth Rout which is perfect but it generate invisible sheets which is not nessaccary for my application I tried to stop creating sheets but i couldnt figure it out. Can you please let me know how I can properly modified the Siddharth Rout code or ponit me to another application like that? Thanks for you time

  Read the article

• 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 Jack 200-323 Tide Lea Fresh 200-344 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 9424

  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

• 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") If cell.Value = "Capa" Then ActiveCell.Offset.FormulaR1C1 = "=HEX2DEC(R[2]C[-1])" End If Next cell Thanks!

  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 thanks. FID SID STATUS 1 87 R 2 87 O 3 88 I 4 88 S 5 89 I 6 89 R 7 89 I 8 89 S 9 90 S 10 90 S

  Read the article

• I wish to "ungroup" a wmf image in PPT using VBA

  - by Tal Galili

  Hello all, I have a ppt file with a slide with an wmf image in it and I want to "ungroup" the image elements in it using VBA. Can it be done? and if so, how? Thanks.

  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 work. I get #VALUE! returned in the Excel cell. I think it is because the function is not part of standard Excel (it is in the Add-in). So how do I call it?

  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

• 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 the HKCU (Current user) programmaticallybut cannot change setting for inunder HKLM . Please advise how can we enable the trust for the VBA project programmatically. Thx Kumar

  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 excel file save it and it runs fine. This happens in both Excel 2003 and 2007. What is happening here?

  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 Function Thank You

  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 Selection.Copy and Selection.Paste methods. Thanks.

  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 =LOOKUP(""something_else"",RC[-10],RC[-8])

  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 2000.)

  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

< Previous Page | 13 14 15 16 17 18 19 20 21 22 23 24  | Next Page >