Hi guys,
I am wondering if there is any way to script changes to macros in EXCEL (or replace entire modules)? I do not want to change the .xls file contents, only the underlying macro code...
1) How to set focus or loose focus on a cell in an excel sheet using VBA code.
2) How do i make a cell NOT Editable and Editable programatically.
Please, give sample code. Thanks
Hi all
I have a spreadsheet that is stored on a shared drive and used by several people. The problem is that if someone forgets to close it, it is only available as 'read only' to everyone ...
A user of mine recieves the follow message everytime he opens a specific Excel file: Cannot find F:\USERS\username\MISC\LBO.XLM!Auto_Open, which has been assigned to run each time "document na...
I have three columns:
Column A has Info
Column B has Info
Column C has numbers
I want to Total items in Column C if they meet both Column A and Column B criterias
Sample Sheet:
A...
I am working with a range, I would like to go to the end of the range and set the next cell below the range as active.
"Selection.End(xlDown).Select" goes to the end of the range, is there a ...
I want hide/unhide sheets.
In the Private Sub Workbook_Open() procedure the Unhide menu command is disabled:
For Each Ctrl In Application.CommandBars.FindControls(ID:=891)
Ctrl....
why does excel copy colon separated text into separate cells, and how can I stop it doing so?
I'm using Excel 2000 version 9.0.8691 SP3 - English version with all standard add ins enabled and the Dutch language pack active. I.E All menus are in Dutch.
When I try to use the WEEKNUMME...
I am developing an Access application with an Access interface and I create an Excel report.
How to avoid the error "Run time error '1004' No data was selected to parse when the txt file...
Hi,
1. My client is using Microsoft Office 2007
2. She has problem with Excel
3. Whenever she opens or uses Excel; if she waits for quite some times, the screens become "all jacking up" (...
Hi,
I have an admittedly really unusual question:
I have an excel table thats updated automatically, and one colum of the email contains email addresses...
Now, I am looking for a VBA c...
Hi Peeps,
I have a large dataset (Invoice) which is showing multple charges per Asset.
I need to summ the charges column based on the AssetID i wondered the best way to go about this
...
I have a spread sheet that has part number's in column A, but also has the word Total if there are several of that part number. What i want is a formula that will highlight the whole Row if t...
I'm sure I could figure this out from previous answers, but my brain is too fried today to try! How do I write it so that these two subs will perform the two operations below on Sheet1 only?
...
I'm trying to develop an Excel VB script that would loop through every cell in the B column - detect a different background color than the regular white and if so - place an 'X' in the A colum...
I'm printing an entire Excel workbook (all the sheets) and want to choose which pages print by examining the cells of each page. Once I determine that a page qualifies, I can "tag" it to prin...
Requirements:
1. Unprotect Sheet, with password, from the command line. (100 xls files) (help me with this)*
2. I have a tool I will be performing Search And Replace on strings in xls docu...
Hello there,
I have two lists of numbers e.g.
[a] [b]
345 654
466 656
546 000
788 242
656 12333
654 7896
What I would like to be able to do is compare c...
I know Ive probably butchered this real bad, but what Im looking to do is convert time into minutes in one cell then convert multiple cells into minutes in the same column and subtract those f...
Hi ya'll-
I made a macro to see how excel writes the VBA code for sorting. I then took that same code and placed it in my excel file and changed the names and cell reference. But I keep g...
I have a workbook that iI need to open regularly from within another workbook. How do I suppress the Update Links message?
My attempt below didn't work.
Thanks,
John
Workbooks.Open ...
Hi
I have a form in Excel VBA with two four column list boxes.
I need a simple way to write the contents of these list boxes to a text file
in the directory C:\My directory\
First I{ wan...
I would like to launch a MS access database from a button in Excel.
It's is a DB that doesn't use the original MDW file. Here is the full pathname:
"C:\Program Files\Microsoft Office\O...
On the spreadsheet I am trying to create. I need to be able to have teachers input the letter grade A,B,C,D etc. These letter grades need to be converted to a number so I can use that data in ...
