in
All Tags » VBA » convert (RSS)

Browse by Tags

  • Convert VBA to VB.Net

    I've noticed in Visual Studio 2005 there is a Tool to convert VBA to VB.Net, but does anyone know of any tools that can automatically convert VBA to VB.Net version 1. Even if there not the greatest any tools would help. Or any techinques. The VBA app is heavly built from access, it also opens excel...
    Posted to Visual Basic.NET (Forum) by microsoft on 12-13-2009

  • Convert Hex to Dec from mscomm

    I'm trying to convert from Hex to dec in VBA for access 97. I am retrieving Hex values from an msComm control which I know are correct from analysing it using some serial monitoring software, I want to extract the 2 red hex bytes from the below (returned by mscomm control, stored as a 9 byte string...
    Posted to Access (Forum) by microsoft on 12-11-2009

  • How to Make Excel Recognize Price Codes as Numbers?

    Hi, In my excel file, one could see that there are separate sheets that can compute for the gross profit of the items. I have a friend who made a vba code that automatically computes the cost of acquiring the item and its selling price if it were to be sold just by typing the weight of the item. Moreover...
    Posted to Excel (Forum) by microsoft on 10-02-2009

  • Excel DateTime-  VBA to Concatenate and convert strings for date Comparison

    I have some data on an Excel Spreadsheet that is cut and pasted from another app: 1. a cell with the year as a string, for example "2004" 2. a cell with a Month as string, for example "June" 3. a cell with the hours and minutes in 24 hour format, ie "23:30" (this is recognized...
    Posted to Excel (Forum) by microsoft on 08-19-2009

  • Excel VBA convert Cells(3,3) to Range("C3") and back again

    I need two functions that will easily convert back and forth between the cells method and the standard 'A1' method: (1) rng1=wks.Cells(3,3) strRange=ConvertToAlpha(rng1) 'would return "C3" (2) strRange="C3" Call GetCells(lngRow, lngCol) 'would return 3,3
    Posted to Excel (Forum) by microsoft on 08-16-2009

  • Convert Excel Range to VBA Array

    How can you convert an excel range (b1:d5) to a array(5 by 3)? Thanks, - Marc
    Posted to Excel (Forum) by microsoft on 08-09-2009

  • Convert text to number

    I have a very large file that I receive as raw data thus data within each cell is "text." There is no other way to generate this file from the system thus it will always make each cell text. Is there code for selecting a range and converting all those cells to number? I know you can physically...
    Posted to Excel (Forum) by microsoft on 07-28-2009

  • Convert a string to a date in vba access

    I created a string Dim strSQLdate as string Dim dtmindate as date strSQL = " SELECT min(date) FROM [query1]" dtmindate = cdate(strQL)
    Posted to Access Coding/Macros (Forum) by microsoft on 06-14-2009

  • Convert VBA Function to SQL Server UDF?

    Hi there, I have a function that is executed quite often. Now that we have our tables in SQL Server. I've been tasked to go back increase performance on the slower areas of the application. I've found a slow area. If I could convert the function below to a UDF then I could convert, rewrite, my...
    Posted to MS SQL Server (Forum) by microsoft on 06-12-2009

  • Problem: VBA to Convert Linked tables into Local tables

    I'm looking for some VBA code for converting all linked tables in an MDB to local tables, the shorter the code, the better. Please note that the MDB currently contains both linked and local tables. I just want to convert the linked tables to local and leave the already local tables untouched. At...
    Posted to Access (Forum) by microsoft on 05-30-2009
Page 1 of 2 (11 items) 1 2 Next >