I am a bit confused about scope of named ranges in Excel. I have two versions of an excel workbook. Occasionally, the users need to copy data from an older version of the workbook into a newer version. There are some custom VBA functions used in most of the cell calculations. Each of those functions looks up around 4 to 12 named rang...
Here is another question I have about being able to calculate this scenario in Access, or even at all for that matter: I have a query that find the TOP 5 items sold in a given timeframe, and it groups by site. I use this to create a comparative chart between the site for ppt presentations. I do a lot of these but I have a problem with t...
I have a excel cell where its value is updated every minute. What i need is a alert message box; while that cell value moves to a particular time. Suppose a cell has value 10 if it reaches 7 in one minute .. i need a message box to alert that. if it is not reaching 7 in one minute its not needed to be alerted. Please help to write...
I am using a custom Excel addin which exports several functions to Excel which do a lot of "behind the scenes" work. I want to force Excel to evaluate calls to these functions in a particular order. That is, if A1 = AddinFunction("Foo") and B3 = AnotherAddinFunction("Bar") then I want to force Excel to evaluate A1 before B3. How can...
Hi, I have to automate something for the finance dpt. I've got an Excel file which I want to read using OleDb: string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=A_File.xls;Extended Properties=""HTML Import;IMEX=1;"""; using (OleDbConnection connection = new OleDbConnection()) { using (DbCommand command = con...
My local newspaper's website recently rolled out a "DataMine" section of their website that has lots of great information I want to tap in to, but the results of a search are not too friendly to an inexperienced programmer myself. Does anyone out there have any experience with Caspio? Do you know if there are APIs I can hit? Does anyo...
I have an application developed in Visual Studio 2005 which I am deploying using ClickOnce. My solution contains two projects - a user interface layer coded in VB, and a class library coded in C#. My C# class library has some code that uses the Outlook and Excel Interop Assemblies (Microsoft.Office.Interop.Outlook and Microsoft.Office.I...
I have a class based on CSocket in a DLL which has various threaded buffers for holding the incoming stream. I have a couple of applications with which this works perfectly, using a timer to poll the buffer to see if anything is there to be pulled out and then displayed. Now I've got the timer in some VBA code, a macro if you will, in a...
I need to read in data from excel files in my c# winforms app. Any recommendations on good components for this? I've used syncfusion some years ago and that seemed to do the trick. There'll be a bunch of header lines I need to skip (so a straight ADO approach won't work easily) and then a table of data with standard columns but variable...
My firewall sends me a notifcation to my email every time a policy is violated. I have about 2500 emails in .msg format that I want to put into one excel document. Basically I am looking for a way to automate processing each .msg file and putting it on a new line in an excel document. All 2500+ .msg files are in a single folder. I un...
I am using ColdFusion 8. Doing something like this: <cfheader name="content-disposition" value="attachment; filename=abc.xlsx"> <cfcontent type="application/msexcel"> <html> But I get a file like abc.xlsx.XLS. The reason I'm trying to get an XLSX is because sometimes the XLS version is so large and Office 2007 gets stuck opening it o...
I received an Excel file that references some data from a MDB file. When I open the file, I am only able to see summary based on dropdowns and pivot tables. The data from the MDB file appears to have been embedded in to the XLS file itself. If I look at the file in Notepad++ I can see the information I'm looking for (albeit mixed in wi...
Hi everyone, here's my problem: User inputs a password in the Options section of the program. The password is hashed (MD5) and stored in the registry. The program is ran, an Excel spreadsheet is created, and password protected using the hashed value that is stored in the registry. The user opens the spreadsheet, and is prompted to ente...
I need to generate a file for Excel, some of the values in this file contain multiple lines. there's also non-English text in there, so the file has to be Unicode. The file I'm generating now looks like this: (in UTF8, with non English text mixed in and with a lot of lines) Header1,Header2,Header3 Value1,Value2,"Value3 Line1 Value3 Li...
I have multiple folders. There are multiple txt files inside these folder. I need to extract data (just a single value: value --->554) from a particular type of txt file in this folder.(individual_values.txt) No 100 Value 555 level match 0.443 top level 0.443 bottom 4343 There will be many folders with same...
Hi, I have developed an application which imports data into Microsoft Excel. Am using VS2005 + .NET 2.0 and Microsoft Office 2007 is installed on my machine (Office 12). The compiled application works fine if I run it in my machine, but when I deploy the application to other machines say those using lower versions (Office 2000), I am g...
I have a test like LEFT('F13',2)='F1' I want to change it from a left-side match to a test that supports wildcards 'F13'='F?3' Excel doesn't support regex except in VBA code but i'd prefer this was done in a macro. I should point out that the actual test isn't a simple string, but cell references (this may be important, I'm not sur...
When I do =RIGHT(DATA!$A$2:$A$1501,1) I get the value 3. When I do =$B$5 I get the value 3. When I do =RIGHT(DATA!$A$2:$A$1501,1)=$B$5 I get the value FALSE. How the f%^k can 3 not equal 3. Is this a data type issue? Do I need a cast? If so how? ...
Is there a simple way, using some common Unix scripting language (Perl/Python/Ruby) or command line utility, to convert an Excel Spreadsheet file to CSV? Specifically, this one: http://www.econ.yale.edu/~shiller/data/ie_data.xls And specifically the third sheet of that spreadsheet (the first two being charts). ...
We have Product Backlog in an Excel Spreadsheet that we also commit to SVN, so everyone can open use it and update to latest version. The problem we have is: How do you enable Excel spreadsheet to be simultaneously used by many people and not override each other's data. Some kind of merging data? Is it at all possible? We would like to...