|
I'm trying to AND two hex number bit-wise in Excel/Visual Basic.
Ex.
53FDBC AND 00FFFF
which should yield 00FDBC.
Any ideas on how to do this?
Started by Edargorter on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Contains "FDBC", but you may wish to pad this to the left with zeroes
As a function (excel module.
|
|
I've been using amcharts (a flash component) to produce charts from within my rails application.
I'm curious.. is there a GEM or plugin that allows me to include a charting component in my web app that lets users mix from any data sets they want, and ...
Started by Zaqintosh on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Which allows you to generate graphics....
There is also something language agnostic : Google Charts Api .
But I personnaly don't really like the look of the graphs generated .
Well you're looking for a graphic images generator ? There is Gruff which allows that .
|
|
I need to import tabular data into my database. The data is supplied via spreadsheets (mostly Excel files) from multiple parties. The format of each of these files is similar but not the same and various transformations will be necessary to massage the...
Started by derfred on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
That....
Have your transformation code in a macro that gets called via Excel controls client's Excel files.
The simplest solution IMHO would be to use Excel itself - you'll get all the Excel built-in functions and macros for free.
|
Ask your Facebook Friends
|
Hi everyone,
Have a list of dates in excel in the format (this comes originally from csv):
23/11/09 07:27:02 23/11/09 08:01:50 23/11/09 08:38:58 23/11/09 09:40:01
What I want to do is count the number of these falling between hour blocks, like 7-8, 8-...
Started by baron on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Excel stores dates as number of days since 1900 or 1904 depending; 8,IF(HOUR(B1)<12,"YES","NO"),"NO")
You should use Excel functions, like HOUR(), to extract.
And will otherwise return false.
|
|
I can't resolve this issue, I found a similar question here but:
setting the workbook to Manual calculation (alt-m-x-m or alt-t-o>formulas) didn't work Setting editor options to disable: Auto syntax check & Background compile didn't work anybody have...
Started by Vincent on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The problem effectively....
I have tried re-installing, I have tried the Excel options > Resources > diagnostic tool which reported that it fixed 1 issue but the problem remained.
Winword VBA IDE works fine, so it's only in Excel for the moment.
|
|
I have created an ActiveX control using C++. I use Visual Basic code to instance the control in an Excel worksheet. I can only run the VB script once, subsequent runs cause the following runtime error when attempting to access the 'ActiveSheet' variable...
Started by Ashley Davis on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Also on a related now, you should use the general "test.test_control" rather than to an Excel application....
To do this means that you can't insert your ActiveX control into an Excel document via Visual Basic and not an Excel issue.
|
|
Hi everyone,
I'm new to OpenOffice Basic/LibreOffice Basic (I'm using LibreOffice currently), and want to convert a macro for updating stock tickers. There are multiple macros in the workbook, however I'm currently only interested in the main (getData...
Started by PatrickDickey_102 on
, 11 posts
by 4 people.
Answer Snippets (Read the full thread at openoffice):
And the good thing with OpenOffice is that you have a choice of Macro languages
There are several macro languages in OOo, but... .
Regarding Excel and Calc there is a nice cross reference guide available on the net or OOo Basic.
In OpenOffice.
|
|
I wanted to post this excellent video because it basically explains me as a person. http://www.youtube.com/watch?v=sti3G...eature=related
Started by Klondo on
, 9 posts
by 5 people.
Answer Snippets (Read the full thread at harmony-central):
WTF?
http://www.youtube.com/watch?v=sti3GaJ6DNg& Any sufficiently advanced technology....
Http://www.youtube.com/watch?v=sti3GaJ6DNg& How do I post this fucking video? This is like the 5th time in the last 5 months I have asked and no one ever explains it to me .
|
|
I have about 200 Excel files that are in standard Excel 2003 format.
I need them all to be saved as Excel xml - basically the same as opening each file and choosing Save As... and then choosing Save as type: XML Spreadsheet
Would you know any simple way...
Started by kristof on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
The simplest way is to record macro for one file = "C:\temp\excel\" strFile....
You need to find the function of yourself doing it in Excel and then looking at the code).
But if you download the solution, it has code for Excel and PPT).
|
|
I'm creating a VB.net application with VS2005 which, at the moment, uses the DataGridView to emulate Excel style functionality on a very basic level. Before I go crazy with creating custom methods for the DataGridView to do some more advanced things, ...
Started by Neitherman on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
SpreadsheetGear....
You can ship excel viewer with your app
FarPoint has a Spread control that's Excel compatible or open source, Infragistics and Telerik make some of the best 3rd party tools that can perform excel like functionality.
|
