Hi all,
The following script works like a charm on my workstation
<dummy_script.vbs>
Dim objExcel
Dim objWorkBook
Set objExcel = CreateObject("EXCEL.APPLICATION")
Set...
I want to loop through each row of a spreadsheet and based on the value of cells in column b, copy the contents of the cells in columns a,b , d, h, j, and copy it to another workbook. I have...
Hey all, I have been assigned a new project that will require a little VBA, and my VBA skills are very elementary.
I have 100 files (Book1.xls through Book100.xls)
All files reside in C:\T...
I have been getting this error lately when working with Excel 2000. Basically when you are trying to copy&paste I get an error that says "Cannot empty clipboard" and I can't figure out why th...
Hi,
I would like to know what should I do in order to save an Excel work sheet (Password Protected) to an Excel unprotected work sheet.
For example:
Excel file A is protected by pass...
I have an Excel file with UsedRange = A1:CH102. The saved size is 4151 kB. I have found a way to reduce the size:
Option Base 1
Sub ReduceSize()
Dim lAntR As Long
Dim iAntK As Inte...
We are slowly rolling out Office 2007 and have been experiencing problems with th eslow opening of spreadsheets in Excel 2007. We did have the problem that when you double click a xls or xlsx...
Trying to help a friend here. Every time he launches Excel (Office 2000 running on Win2k Pro) a box pops up with "Runtime Error 9: Subscript out of range".
Note that this is when launching...
Hi I presently have a difficulty with importing csv files into excel using VBA. I have created a macro which is meant to read each record from a csv file and put it into excel. The code also n...
I'm a newie in the Access world, so I need a little "push" to get me in the right direction. What I'm wanting to do is build an Excel spreadsheet that will ask the user a series of questions ...
I am not able to convert a number greater than 24 into h:m:s
I use the formula =(H5/24;"hh:mm:ss") but this only works up to 24.
When I try this with 27.50, the result is 03:30:00 because ...
Hello Experts,
Something weird just started happening: up until last week I was able to open files created with MS Excel 2007, but for some reason xlsx files cannot be opened with Excel 200...
I have a range of cells named "RANGE" (original huh ?). I would like to detect each time a row or column is inserted so I can modify my range accordingly. At the same time I would also specify...
I am wanting to use a formula in Excel that will calculate the difference, in percentage, between two times and either show it as an increase, or decrease..
The cells are formatted hh:mm:ss
...
How do I insert a check box in Excel 2007?
I have an excel file that needs to enter data into a web page. Click a button, wait for it to load the results and copy the results into excel.
Below is the source code for the site, and m...
Hi,
I have values in my excel spreadsheet that are DATE value. I.E. they are stored as Julian dates, and appear on the screen as "7/12/2006" etc.
If I convert this field to general text...
I have two monitors, so I like to compare speadsheets side by side.
When you open a Word document, it alwasy opens in a new window (adds a window to the task bar). Is there a way to get Ex...
I was trying to use Excel if statement for string using wildcard character. I was trying to use luke this
=If (C1="F*","F")
But, it didnot work. I know that LEFT command does this. But,...
I have an Excel VBA macro which I am trying to get to run a batch file.
My code so far appears to open the dos window and immediately close it. The batch file does not appear to run.
As...
Hi,
How can I test in VBA if the excel-cel is empty?
Now I have
if Cells(x,5).Value <> "" And Cells(x,5).Value <> "''" then ...
But this don't work. If the cell is empty he exec...
I want to create a chart with one x axis but multiple y axis points.
E.G. i receive excel spreadsheets for processses that our software runs. i would like to chart these results to anal...
I am looking for code to loop through a range and if the value in the range is numeric i want it to copy the entire row to a new worksheet. I have the prelimenary code below, but do not know ...
Ok guys, I've come to you with another annoying (for me anyway!) Excel VBA combo box problem. First of all, this is just something I am doing for fun, I have no professional programming exper...
