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...
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...
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...
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 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 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...
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...
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...
Hi:
I have lots of csv files that I need to view through Excel. Sometimes it works fine, sometimes I am given a Text Import Wizard to specified delimiter before the file can be displayed co...
I have a trade study worksheet that multiplies weights * scores and returns an optimum product.
I'm trying to build a second page that shows how sensitive those scores are to the weights.
...
Yesterday I thought I understood isblank, but I was wrong.
Today I am 100% sure I really really understand it which means I'm sure to be wrong again.
Will someone just check this out and...
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...
Am I hallucinating or did they remove any or all options in 2007 in regards to CSV files? I'm trying to export a worksheet to csv with the normal settings, but I need each field to be enclose...
How do I insert a check box in Excel 2007?
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...
Hi experts,
I'm trying to export data from a Excel sheet to a CSV format. I'm using the "save as type CSV" menu option. The output I'm getting is delimited fields by semicolon (";"), instea...
I have column1 with a list of values
I need column2 to give me the following:
if column1 between 0-30, then column2=1
if column1 between 30-60, then column2=2
if column1 between 60-90, ...
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,...
This should be very simple, however I can't seem to figure out how to do it!
Can someone tell me how to calculate the S matrix in the following:
http://www.itl.nist.gov/div898/handbook/pm...
We have a couple workstations that seem to have different workbook defaults than others. How can I reset these machines so that when a new workbook is created, it is using the original defaul...
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...
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...
Let's say I have an excel spreadsheet with 3 columns. The first is a ticker, and the second two are data values that pertain to each ticker.
For example,
MSFT 1.5 .12
ADBE 2.0 .1...
What is the syntax to sum a range?
For example
Sum Worksheets("test").Range("A1:D1")
