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...
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...
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...
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...
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...
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...
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...
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...
Each month for our income statement monthly report I run 4 reports from our report writing program and save the results as 4 separate Excel files. The problem is, the company officers do not ...
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 ...
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 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
...
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 ...
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 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...
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 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,...
How do I insert a check box in Excel 2007?
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 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...
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...
Experts,
I want to understand how to use a radio button in Excel/VBA.
I want it so that if I select a radio button the contents of a cell changes according to the code. For example from ...
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...
