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 ?...
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...
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...
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 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...
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 ...
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 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 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,
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...
I have Vista PC, Window Vista Business with MS office 2007 valid licence.
Vista is upgraded to SP2. with 32 bit edition.
Whenever updates start to download and install it shows error cod...
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
Hello!
I have Office 2007 on a Dell Vostro 200 with Windows XP SP3. Once or twice a week Excel will show a screen saying that Excel experienced a problem and has to close. I cant tell if it i...
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...
Dear experts,
In Excel VBA I define dim ObjAss(100000) as variant.
Now I would like to assign 3240 to each cell of this array as its default intitial value.
Is this possible with looping th...
Hi X-perts,
I have a dynamically generated sheet content (via VBA) and need to recalculate certain cells at certain points. What I do is as follows:
1) populate cells via VBA
2) Appli...
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...
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 want to read a single node in a XML web page using the MSXML object - I can do this with the code below but once I run the code, I get an error if I continue the code works.Any ideas? The e...
Hi EE,
Just wondering:
screen shot 1 - wizard allow to check off values, to place number above the bar
screen shot 2 - macro recorder shows code generated by wizard
screen shot 3 - chart...
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 ...
Hi,
I'm currently using the TreeView control in VBA userforms and I'm having a little issue trying to get the child nodes for a particular Key.
I currently have the following setup:
...
There are similiar answers on EE (e.g. http://www.experts-exchange.com/Q_24186953.html).
I have several workbooks each with one worksheet. Each worksheet has the same name as the file. I w...
How can these large integers be converted to a date/time format that I can use (sort/filter) in Excel? They were part of a database that was sent to me in a tab delimited .txt file. It was o...
Hello Experts,
I would like a macro that would output the results from LINEST for my data including coefficients, intercepts and R squared-s in a new worksheet. I would like this done for ...
