Search results for query: *

Is there a program that can compile and excel spreadsheet into C++ automatically?

does anyone know of a program to automatcially convert excel spreadsheet to C++ dll addin?

Is it possible to do a qurey on a text file i found a code that will output the data, now i just want to do the query but i can seem to get a where function to work (the text file is tab delimited)... Sub TestGetTextFileData() GetTextFileData "SELECT * FROM test.txt" & " WHERE field1=" &...

I have the following: - text file (tab delimited) which has data (generated separately) with around 55 million rows and 5 columns (results from another program) - i need to be able to query the first column (has identifier) and retrieve the data to do calculations in excel (around 55 at a...

In VBA excel which is quicker range("name").offset(x,y) or Cells(x,y).... or another method... anyhelp would be appreciated.

Is it possible to force one thread of excel to use 100% of both CPU's on a dual processor (OS Win 200). i.e. wheni am not working on my computer i would like the cpy usage to be 100% (ie. both cpus at 100%) rather than 50%. thanks

I have two question: I have a userform that i want to keep open and use excel at the same time? How can this be done? i.e. so that i am able to edit cells? Can a userform be put in as a custome toolbar? if so how? Thanks?

I have two question: I have a userform that i want to keep open and use excel at the same time? How can this be done? i.e. so that i am able to edit cells? Can a userform be put in as a custome toolbar? if so how? Thanks?

Just wondering if someone could tell me how difficult it would to write a VBA program that would: Go down each cell in a colum if there is a formula write the formula into word not with cells references or values but with the text in column A: e.g. COLUMNS A B Apple 1 Orange...

Hi, I have recently changed to a french keyboard Xp was installed with an english keyboard. Though i hvave changed the keyboard seetings (and deleted english keyboard) the welcome screen is still based on the english keyboard? How do i change it so the welcome sceen is french keyboard layout

I was wondering if someone could help me with Excel. basically what i have so far is the following =VLOOKUP("fx",INDEX('G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$A:$A,MATCH(B38,'G:\common\[SBILPL.xls]Coversheet - Flow Trading'!$A:$A,0)):'G:\common\[SBILPL.xls]Coversheet -...

I have txt files that need to be imported to excel they are always in the same format, however is there a way to save where the fixed columns are in the txt import wizard so i can run a macro to import and format teh files automatically. Hope my question is clear? thanks

i need to set the range for the beforedoubleclick funtion which is basically the columns 2,5,8,11,14 etc. I am not sure how i can specify this?

i dont know if this is possible but: Is there a way using code or something else...to zoom into cells that are selected...ie. like a magnifying glass on the selection..

I dunno know if this is a stupid qustion but: I would like to know if in built functions in excel such as vlookup, sum, are all built in visual basic (like UDFs) and if so is it possible to see the code..

Is there way to make a vb code (i am guessing which will run an external code) in access which will make the file zip itself and email to a specified address using outlook?

is there a way to do the do a automatic compact and repair on close after 50 uses automatically on close of the database

I have a code using docmd.transferspreadsheet... now this work fine most of the time, but sometimes it will mix the rows around i.e. row 10 will be row 1 etc. does anyone know why or has seen similar behaviour?

i have the following code in a form, basically when the user picks a table from a combo box it will populate a list box with the fields present...now if more than one person is using this form it will delete the other persons table (and hence he cant continue using the form without errors)...

continued from thread thread705-594042!! I need to the last column and make it the first column (yes i know its pointless but lets just skip that little argument for a while :) now this is the part of code i have Set tbl = db.TableDefs(strtblName) Set fld = tbl.Fields(19) fld.OrdinalPosition...