I need to make an excel macro vba to remove bad characters (special characters) in a string of text, such as (, commas, -, ;, :, !, \n, /n, etc, but I dont know the best way to handle&
I wan...
hi,
is there a way to programmatically control the sound volume in Windows? Ideally in VBA directly, but perhaps via a shell command if this is easy in DOS. Need command to unmute windows s...
Hello,
I am looking for the word "HELLO" in a colum of a spreadsheet (there should only be one instance of the word), I just need to know which row it appears in, how can I do this in VBA ?...
Here's the issue, I have invoices in excel that are saved with the invoice #. I want to create a single workbook (bookkeeping.xls) that gathers information from all the invoices like name,ch...
I have read some of the prior questions on if Excel can calculate the p-value such as in the below example:
1100 3000
500 990
Currently I use MINITAB to do all the statistical testing t...
This is isolated to only one user so it seems to be a setting in Windows or Excel. The user has Office 2007 and Acrobat Professional 8, and Acrobat Reader 9. When the user embeds a PDF into ...
Hi, I have a macro that goes down through a column in a document and if a cell has the word "check" in it, it'll check the row of that cell and check it out. How I want to "check" it is to see...
Hi.
I have the attached 2 example workbooks (& the code) which merges the worksheets from 7 different workbooks together into a 'Raw data' worksheet in my master workbook.
It is driven o...
Hi there Experts,
Can someone write a VBA routine that interrogates the Experts Exchange website to find out the names, specialism and points achieved for all those members that have 3,000,...
I have several worksheets in a workbook that have dozens of queries. I would like to know how to make changes to the Query Table CommandText Property via Macro. For Instance, if a field name ...
User has web application wich does export to excel using ActiveX controle
It worked fine with Excel 2003
After Excel 2007 was installed, User has en error
I:\Hstbar.xla cannot be found ....
I am developing a C# .Net application using Visual Studio 2005 that uses an Excel file.
I pass an Excel file to a method named ExcelFormat to insert a new Column A into the existing
Excel f...
I have two columns of numbers in Excel. For each data value in column 'A' I need to know if there is a match in column 'B'. It looks like I need to use a VLookup function, but maybe a Match ...
Hi
I am quite new to xcelsius. I have pulled up data from a BO server using query as web service. I exported it to a spreadsheet . It is in the following format.
Project Team Year C...
Hi All Experts,
How can I lock the cells in grey color shaded? I don't want the end user can overwrite, change. or delete anything in these area. Please help.
I'm having problems with a particular spreadsheet which is generated from a system (it might be in xml format I'm not sure).
I try and use vlookup on one spreadsheet against the one attache...
Anyone that can provide a file they have come across that creates any of the financial statements based on the chart of account?
Thanks,
JP
I have a macro which converts .csv files to .xls files (old code implemented prior to getting excel 2007). The first sheet in this workbook is a chart of specific periods of data. The macro cr...
Hi,
Remove all other data and leave just the data in the txt file. Need to delete the colums where data match in row 1
Attached is a sample data with 2 sheets.
Please have a look.
R...
The attached file shows a chart that changes dynamically as the rows are filtered.
I put a trend line in with the r-squared value to show.
For some reason, when the slope is negative, the r-...
Hi,
This is step 3 to my earlier question. In step 1we created a macro that takes a spreadsheet and adds new columns to it. In step 2 we populated those new columns with data. Now for s...
Can anyone help me convert a column that has unix time stamp to regular Time with Macro Script
I'm trying to filter a list using a formula, that takes the Numerical Values from a Named Range (List) and either place them in another column (Column C) or used directly with a Data Validatio...
I am looking for some simple code either as a DOS batch file or as VB code using Excel which will open a csv file (sample attached) , remove leading zeros from the numbers in the second field ...
The VBA for Excel code below fails on the text-to-integer conversion step, namely:
nReps = Val(TextBox1.Text)
The error is: "Microsoft Visual Basic - Run-time error '424' : Object ...
