Search Results

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

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

• How do I export a Gantt Chart from MS Project to MS Word using VBA

  - by user191093

  Using MS Project 2003 i want to export the "View | Gantt Chart" to MS Word (2000) using VBA. How can I achieve this?

  Read the article

• Pros and Cons of automating Excel using VBA vs .Net

  - by Andy

  I've been tasked with creating a financial planning tool in Excel that would benefit from some custom functions/macros. My initial reaction was to use VBA. I've used it to drive Excel before (say 5 years ago). But I then began to wonder if I would be better off using VSTO. Has anyone has experience using both techs and can list the pros and cons…

  Read the article

• Hungarian in VBA okay?

  - by KennerL90

  I don't use hungarian (str, int) prefixes in .Net, but I still find it useful in VBA, where it is more difficult to see types. Is this bad? Unnecessary? Maybe I'm missing something. I'd really appreciate any feedback. I've been wondering for a while. Thanks everybody.

  Read the article

• Upload a file with POST (multipart/form-data) using VBA

  - by Moses Ting

  Does anyone know if it's possible to upload a file via POST body (multipart/form-data) using VBA? I'm currently using the Microsoft.XMLHTTP object, but I'm not tied to it if that doesn't support multipart POST. Here's what I'm doing so far: Set oHttp = CreateObject("Microsoft.XMLHTTP") oHttp.Open "POST", theUrl, False oHttp.setRequestHeader…

  Read the article

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

  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…

  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…

  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 …

  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…

  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…

  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…

  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

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

  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 …

  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,…

  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…

  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…

  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

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