(DISCLAIMER: I'm not a programmer, I spend my time on serverfault, I'm just a lowly admin) We have an excel spreadsheet with vb code in it that was created in Office 2003. We've recently gone to Office 2007, and the spreadsheet continued to work as normal. However, after installing service pack 2 for Office 2007 the spreadsheet now fa...
Hi, i want to have a "one-click" excel export feature for my application. I therefore need to create an excel file in a temporary location, because i need to use a third-party component to do so. I want Excel then to open up the file. I can get to that point, however Excel always remembers the location it loaded the file from. Id like ...
I have a table in excel with three columns: name, organization, contract expiring (YES/NO). I have 20 other sheets, one for each organization. On each sheet, I want the names of the people whose contracts are expiring from that company. I can do a vlookup for the first one listed, but I need the full list for each organization. Any sugg...
I'd like the quickest way (in excel VBA) to identify whether one string occurs anywhere within another - an 'includes' function perhaps? ...
I have a cell containing a date ex. "05/11/09" It is currently displayed as "11-MAY-09". How do I copy-paste or use VBA to get the string "11-MAY-09" into the cell next to it ( NOT "05/11/09")? I can't figure it out other than piecing out the date pieces by itself. ...
Hi, I am using Reporting services 2005, and am exporting the reports into Excel. Everything is fine except for cells that have been referenced to. An example is this: textbox1 has the value 10 textbox2 has the value 20 the formula in textbox3 is =ReportItems!textbox1.value + ReportItems!textbox2.value textbox3 would have the correct ...
I've got a spreadsheet like this: date | 7/1 | 7/2 | 7/3 | 7/4 -----|-----|-----|-----|----- val | 3 | 5 | 1 | 3 -----|-----|-----|-----|----- I want to sum the val row, but only up to the current date. So if today were 7/3, the sum would be 3+5+1=9. If today were 7/4, it would be 12. I figured this out to get the number of...
Is it possible to create an multi threaded application, The lists all the pivot tables in an excel document, And fires a new thread to refresh each pivot table. Currently a applicatoin.refreshall takes 3hrs. I also do not think that vba code can be mulithreaded. Any ideas welcome ...
I'm pulling data from one Excel table into another using an IF statement. I want it to check two fields and if it is a match I want it to print something and if it doesn't then I want it to continue searching. If there is no absolute match then leave the field blank. I believe I'm running into an syntax issue but after numerous iteratio...
Hi, I am building a reconciliation tool via VBA that automates queries from my oracle database and a worksheet. When I run the query I want the user to input what ITEM (in this case pipeline) to query (the worksheet has many items) and the end/start dates. I am having trouble figuring out the following: 1) It is querying - if the value ...
Anyone know of some code out there that does this already? I have a bunch of pages with data grids on them in an admin website they want to export them to Excel, was hoping someone had this written already - or if not I'll post mine when I am done. ...
Hi, I am building a reconciliation tool via VBA that automates queries from my oracle database and a worksheet. When I run the query I want the user to input what ITEM (in this case pipeline) to query (the worksheet has many items) and the end/start dates. I am having trouble figuring out the following: 1) It is querying - if the value ...
I have developed two custom task pane addins to be used in Excel 2007. I set one to DockPosition = Left and the other to DockPosition = Top. This puts the Top pane all the way across the top, with the Left pane under it. Is there a way to force the Left pane so that it goes all the way to the top, which would move the Top pane over (mor...
Sample Modified and self-produced (d) Food packages (d,d,d,d,e,e,d,d,e,d,d) Other country’s food labels (d) Using food labels to choose foods for Healthy eating (d) Measuring cups food models (d) Food labelling exercise – custom (e) Food product promotional pamphlet (d) It pays to read your grocery label (d) Old food labels (d)...
I need to produce a C# program which will create two intro worksheets, and a 3rd worksheet that will be made repeatedly for every entry in a database. I am unsure which is the best way to produce multiple worksheets. This last sheet must be able to retain some formating and range names. Is copying this last sheet better, or is creating...
Hello, my application is 64bit native, therefore the examples on how to import an excel file to a gridview, are useless, due to the OleDB drivers been 32bit only... is there a way around, on how to import an excel file to a datagrid without using the OleDB connection? ...
is there any way that a cell can be attached to the focus to get the value of any selleected cell any where within the sheet. ...
I need a way to look at one type of event as a basis, and then graph how several other events interact with the base event. Example: data set of events has occurred for a group of locations (1000+ locations): event 1 occurs ~every 4 weeks over course of 6 months event 2 occurs ~2 weeks over course of 6 months event 3 occurs randomly, no...
I have data of program usage in excel file, the data has date and time. I want to summarize this information that in each day each hour, how many user use this application. How to do that using excel formular? sample data: Jun 01, 09:03AM Jun 01, 10:00AM Jun 01, 10:50AM Jun 01, 11:00AM Jun 01, 11:26AM Jun 02, 01:00PM Jun 02, 03:00PM Ju...
Hi, My application uses windows authenctication. user login with their username/password and upload an excel sheet. The issues is while uploading the excel ,one user able to upload the excel file but another user get an error "No error message available, result code: E_FAIL(0x80004005)". But the code is same. I dont know whats the actual...