I'm populating my spreadsheet with Database values.Now if I 30 rows were filled then I want to create a dynamic button on say 31st or 32nd row for doing some action.The number of rows that will be populated is not fixed.How can I do this. ...
My boss has a habit of performing queries on our databases that return tens of thousands of rows and saving them into excel files. I, being the intern, constantly have to write scripts that work with the information from these files. Thus far I've tried VBScript and Powershell for my scripting needs. Both of these can take several min...
Hi, I want a customized format(with milliseconds also) in such a way to handle for a date and time in Microsoft Excel. Sample date and time: 08.25.2010 00:52:09.359 For understanding of above sample date time, it is 25th August 2010 12 hrs 52mins 9seconds 359 milliseconds(AM). Please provide a custom Format to handle the above mention...
Ok I have two files in Excel 2007. They are both to large to do this sort manually consisting of several thousand lines. File 1 has first names and ID numbers as 2 columns: Joe 1 Mark 2 Bob 3 Sally 4 etc... File 2 has last names and ID number as 2 columns: Smith 1 Johnson 2 Brown 3 Hands 4 Is there an easy way where I can sort these ...
Hi! I have a spreadsheet with multiple duplicate rows. I need this data sorted in order of their frequency, so I setup a COUNTIF and sorted them. Now I would like to remove the duplicate rows, but keep the COUNTIF at the same value and have Excel add to it if other duplicates are added to the spreadsheet in the future. How can I go ab...
Hi I've created a worksheet which is shared amongst my colleagues with a real simply macro to show/hide rows but everytime either I or one of my colleagues opens it they get prompted to Allow marco - is there anyway for them to permantly allow this macro? ...
Hi, I've got a simple (inline) ASPX page that is ouputting XML. I want to import this XML into Excel 2007 using Data | From Other Sources | From XML Data Import. If I specify the URL for my APSX page Excel opens the result into the Text Import Wizard :( If I open my URL directly from Notepad, save the content to a file and import th...
Does anybody have a sample of how to export a paged DataGrid so that it can be used in Excel (csv or Xml)? All of the examples I've seen so far can only output the currently displayed data, not the whole set or use automation. ...
I have used the following without success. The active workbook closes, indeed, but the excel window remains open. Application.ActiveWindow.Close SaveChanges:=False ActiveWorkbook.Close SaveChanges:=False Which is the command that terminates the application? EDIT To say a little more: In the workbook Open event I run a macro. I want ...
If I create a stored proc in sql that has a parameter, can I run that from Excel? ...
I would like to write a macro in vb to select all rows where values in column B contain the characters 'via'. This is my first attempt at macros and not too sure how to begin. ...
I have a stored procedure running in Excel. I need to pass a procedure to that parameter but I dont want to have to change that connection every time.Is this possible? I dont know vba at all so as much detail would be appreciated. ...
Hi! I have a problem in Excel 2007. I need to compare one value - letter "C" - to a range of cells that are on one row. The problem is that the values should be in every other cell. So if I have a row like this - C 434 C 324 C 3453 - it should say in a cell in the end - OK And if I have a row like this - C 22 B 665 C 8877 - it should ...
I have stored proc Im pulling in to excel but to get it to Run I have to enter my text exec roc 'Name' I need it to be able to have someone else thats running it be able to enter a name as they refresh the data. I dont know VBA at all and am looking for help. ...
Greetings, I want to read excel 2007 files via python on my Ubuntu server. I have already checked http://www.python-excel.org/ xlwt and xlrd but it seems like none of them can read excel 2007 files. What would be your recommendation? Regards ...
I need to be able to paste data into an Excel template, so I can validate the data before it gets uploaded to my database. Unfortunately, pasting into the validated cells deactivates my validation and I have no way of knowing if my data is vaid or not. please advise what I should do and outline procedure.. thank you! ...
I want to count all the unique values in an Excel column that contain a certain string. For instance, say I have this in my column: strA strB strA strC diffA diffB strC If I give this theoretical function that I'm writing a value of "str," it will count the unique values containing "str", and give me back the number 3. Any suggestio...
I have a datasource that poplulates my sheet from sql server. There is a parameter to refresh the data. Can I have the choices come from a drop down menu on another sheet? I know no VBA BTW. ...
Hi , In "sheet1 Column A", I have a list of parts_ID's. In "sheet2 column A" I have a related list of part_ID's. I need to format the cell in "sheet1 cell A2", so that if the same part-ID is not listed anywhere in "sheet2 Column A", then it should highlight red "sheet1 cell A2". BTW, if relevent, I already named the range in "sheet2 ...
We have a C# app that launches (mainly) Excel based programs, passing user information etcetera via the command line, e.g: "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" "C:\Program Files\Some Folder\ExcelApp.xlsm" A/SimonCowen88/MyPaSsWoRd/OtherInfo/... On some users' machines this method causes ExcelApp.xlsm to 'open...