I built a coded UI test and I want to make it a data driven test , I want to get the data from an excel file ( Data.xls )located in the same directory with the
I run into run-time error 1004 Works if I use the cell as an argument but I don't want to constrain to one cell. I can get this to run if I use an input param
I have created a macro that opens a excel workbook and performs some operations and then at the end it closes the file.The macro is running fine. Now, when I o
We have an internal web application that accepts a file of varying formats from a user in order to import large amounts of data into our systems. One of the mo
I am rying to ge the values of PivotField in PivotTable(1).Pivotfields, then I am trying to get the the filter value to string(str- Declared as string), It is w
I have the following code, which should simply open a workbook from a master workbook to allow me to paste some information which I will later retrieve from a d
I'm trying to open a HTML file in excel (from VBA) so that the HTML inline styling is preserved. Are there any special ways of doing this because currently I've
I'm trying to open a HTML file in excel (from VBA) so that the HTML inline styling is preserved. Are there any special ways of doing this because currently I've
In Excel, I am able to add validation rules to a range of cells and limit the accepted input to a list of values displayed in a dropdown. This is done using the
I have a large number of rows and columns (e.g. 500k rows and 20 columns) all filled with numbers. I'm trying to delete all data in column I that has a certain
I am a bit suprised as I am trying to record a macro in Excel, but I keep getting this error: Cannot Run Visual Basic Editor Because of a Syntax error The mo
I'm trying to write a macro in Excel that will look through my Outlook calendar, grab all the events, and display the following information: subject, start time
Can you please help me to make Excel formula that takes string value from cell and sorts its characters in alphabetical order? Ex. original cell value: 'BACR'
I have a Excel VBA application which has been working fine in Excel 2003 but failed in Excel 2010. The relative codes are Public Sub Create_Chart Dim c
I'm developing an Excel 2010 workbook, in a manual formulas calculation mode. (file -> options -> formulas -> Workbook calculation -> manual) I ha
I have a basic WinForms application and want to be able to write data from this application to an Excel spreadsheet. So far I have the following code: Microsof
When I try to call remove item on my listbox, I get '-2147467259 (80004005)' unspecified error. My rowsource property is blank. I add the items originally thr
I am pretty sure there is an easier way than how i am doing it, I just have two workbooks and a single sheet in each work book, does anyone have any any suggest
I have 2 workbooks....OdysseyDeposit where my source data is and Civil Bank Accnt Recon which contains VLOOKUP to the OdysseyDeposit. Here is the VLOOKUP funct
I am working on a scraper to pull street names and zip codes from a site and all of that is working great and it builds a CSV file just fine for me. But when I