I have the following formula: =IF(MROUND(((D4-C4+IF(C4>D4,1)-INT(D4-C4+IF(C4>D4,1)))*24), 0.25) < 0.15, 0.25, MROUND(((D4-C4+IF(C4>D4,1)-INT(D4-C4+IF(C4>D4,1)))*24), 0.25)) this formula gets the time between a start and stop time and rounds it up to the nearest 15 minutes. I have a problem with it when no time is entered and it = 15 m...
I've noticed that when I copy and paste some cell ranges, that sometimes the conditions get pasted out of order, essentially changing the formatting scheme. Every time I paste this range of cells, I have to open the conditional formatting dialog and move the top format back to the bottom. I would love to know why this is happening, and...
I am trying to debug an VBA excel app that invokes some functions from a C++ COM DLL. I have added type library of the COM DDL in Tools--->References. If i build the DLL in debug mode, VBA app complains about not finding the dll at run-time. When i build the DLL in release mode, i am unable to debug it. Does anyone knows how to link VBA...
Hi guys, I have a huge excel with thousands of rows and I need to generate an sql query to insert the data into a sql server database. The format of the excel is the following 1 | string1 | another string string2 string3 2 | AAA AAA | ZZZZZZZ BB BBBB CCCC CC The first column is a row counter, it doesn't matter. The ...
Hi, I would like to know first what is the difference between VSTO Excel 2007 Workbook and VSTO Excel 2007 Add-In. In what scenarios either VSTO excel 2007 workbook or VSTO Excel 2007 Add-In or both is preferred. I would like to learn VSTO Excel 2007 using C# with some good examples and working with the same at high level of usage in...
How to Store Clipboard data into a sample table while working in VSTO Excel using C# Later how to load the data stored into a sample table on to Excel worksheet As i don't want direct from clipboard to Excel. Please help me with the code ...
My requirement of one need: How to get active cells range in an object in a worksheet to copy those active cells range data into an excel or excel range object 3.To bind those excel range object data back to excel worksheet Please help me with the Code using C#. ...
I'm getting a formatting problem if I use more than 10 UNION ALL statements in my VBA Code. If I use 10 or less everything works great. What I'm trying to do is combine 12 worksheets (Excel 2007). I have a numerical column called SC that turns into string and date if I have more than 10 UNION ALL. If I try to use ROUND with more than ...
We use a FileSystemWatcher to monitor documents opened from our Document Management system, and if the user saves the document, we ask if they would also like them updated in our system. We have a problem with XLS files in Excel 2007 (have not verified that the problem does not exist in 2003, but it only seems to be files that open in c...
How to record user performed actions on 2007Excel VSTO in .ini file using C#. ...
I work with card numbers, like credit card and ID numbers. We do not do any calculations with card numbers, obviously. They are "text." I format them as text, I type them like text. I know how that works. Excel doesn't care. 16 digit card numbers get their last digit turned into a zero, changed into scientific notation, stupid stuff tha...
How can I accomplish the same with c#? ...
Question1: How to access windows form and its controls on VSTO excel using C#? Question2: On Execution of VSTO Excel workbook application, I want total no. of active columns when the user paste the data. Suppose User may paste 5 column data or 10 column data. Through code i want to figure out the total no. of columns(Also Total no. of ...
The Access 2007 app creates an Excel 2007 from a template file and saves as Excel 2007. xlWorkbook.SaveAs "C:\TestFile.xlsx", FileFormat:=51 'Excel 2007 without macros If Excel 2007 is installed, no problem. If both 2003 & 2007 are installed, the file is created as 2007, but the the computer is trying to create with 2003. A "Newer ver...
I want to make the first cell(Column - A; Row -0) is to be focused or selected always whenever i execute VSTO Excel Workbook App. Please help me through code ...
I would like to create a non-VBA based solution to the following question: How do I create a multi-series chart that will allow a user to select from a dropdown to change the data being graphed? I can do this already when the data series is contiguous; however, I'd like to be able to do it for non-contiguous data. Is this possible? M...
Hi i have two sheets having data like this sheet1 : **A** **B** **C** 752 A 752 E 752 N 984 G1 984 G2 4471 U1 4471 U2 4471 U4 4471 U5 4471 U7 4471 U8 sheet2: **A** **B** **C** 132 G 69092 227 G 29400 227 G1 2378 292 G 20...
I currently have an archaic system of client records that I am trying to improve. For each client i have a directory, in that directory i include a directory for each job. Each job has a spreadsheet that i use to store their personal details, and run calculations and costings specific to their needs. In turn I also have word documents t...
Just posting the solution I worked out today. See my answer below. If you don't have the very helpful OpenXML SDK v2.0 Tool, you can find it at http://www.microsoft.com/downloads/details.aspx?FamilyID=C6E744E5-36E9-45F5-8D8C-331DF206E0D0&displaylang=en If you know the purpose of the lines I commented with "I don't know...", please...
Hi, I have created an application to interact with Excel in C#.net The API to save the Excel Excel._Workbook m_oWorkBook; m_oWorkBook.Save(); Throws up a File Saveas MessageBox though the workbook was already saved in a given name. Note: This happens only in Windows 7 & only when another Workbook was already opened. Any clue...