Search results for query: *

Cool! Thanks!

One column of my spreadsheet, I have this data extracted from a database in this format: Column C1: ["Name","Street Address","City, State Zipcode"] I want to extract Street Address, City, State Zipcode into a different column, N1. How do I do that? Thanks!

thank you ehaze, I customize the forms in Infopath, add rules, etc... everything is working in the preview of Infopath, but when i published the form to Sharepoint 2010, the rules are not working. Click customize form again to check it in Infopath, the rules are still there...and working in...

In Sharepoint, I need modify a new item form of a list to make a field visible/invisible when a check box is selected: For example: There is a checkbox field called "Is XYZ affected?" When a user selects this field, it will make a hidden field visible "Impact details:" If "Is XYZ affected?"...

I have data for the whole fiscal year, for example: Nov Dec Jan Feb Mar Apr... 12 Dec, Jan, Feb, Mar and Apr columns have none data, how do i use one formula to calculate the average up to date. For example, average would be 12 for the data above, not 12/12 (whole year) = 1...

Thanks ClulessChris. It worked

I have a spreadsheet with thousand of rows. I combine values of all columns of each row into one column K. Now I want to export each row of column K into a text file. For example: Sheet1.Cells(1,"K").value => C:\temp\1.txt Sheet1.Cells(2,"K").value => C:\temp\2.txt Sheet1.Cells(3,"K").value =>...

On my Excel macro, I had: Set r1 = Sheet1.Range(Cells(2, 1), Cells(1000, 3)) Step into the code, it returns error Run-time error '1004': Application-defined or object-defined error Any idea why it is complaining that? FYI: This is regarding to testing the script on the posting...

Thank you both for your response. GlennUK response worked great!

I have a spreadsheet like below. For each month, it has 3 columns, EMEA, NA, and AP. Under those columns, they have several rows as well, like Core Planned, Core Unplanned, Non-core Planned, Non-core Unplanned. We have a whole year data, and i want to create a section that looks up the data...

I know, just don't know what the pattern should be for non-ascii? or non english characters.... there're lots of non english characters out there, can't capture them all...

How do I replace any non ascii characters with a question mark? (?) We have xml interface to submit incidents in, and it doesn't accept any non ascii characters. I want to replace all non ascii chars with a (?) before submitting? Anyone knows the search pattern for non ascii char? or Perl...

sorry, it's business objects. thanks for tips

Can Businessobject link data from one table to a different table? just like in Excel? =Sheet2!B9 =B1 etc... Thanks!

...and =If([Currently Open].[Incident Closed Date >04/30/2008;"May";"") Both failed: The expression/sub-expression at position **(where ** is at 04/30/2008) uses an invalid data type. Specify a valid data type. (Error: WIS 10037) What is right date format i should put in there? Thanks!

It's an .inf file to install, how can i use msiexec.exe to install it?

Does anybody know a way in Windows to execute this task by using a windows command: right-click on a file and select install. I'm trying to create a bat script to install this driver automatically to multiple machines, if there's a way to perform the install by using a windows command, it...

Very cool! Thanks!

From the codes below, I'm trying to pass the arrayname to the function: if "value1" is selected, then arrvalue1cfgn and arrvalue1cfgv is passed through to the selectChange function: \"arr\" + this.value + \"cfgn\" = arrvalue1cfgn \"arr\" + this.value + \"cfgv\" = arrvalue1cfgv However, this...

PercentProcessorTime of WMI object can get a CPU usage of a process, however, I need to get the CPU usage of a machine (all processes), how do I alternate the codes below to perform just that? strComputer = "." Set objWMIService = GetObject("winmgmts:" _ &...