Description:
Microsoft Office Excel newsgroup.
|
|
|
Using Excel to WRITE to a closed Excel file
|
| |
Somebody told me that the best way to use Excel (and VBA) to write to a closed (.xlsx) Excel file is to first open the file, write changes using VBA code, then close the file. Well, I don't really want the target write file to open on the screen and let my users see the file changes happen. My question... more »
|
|
Alternative to Calendar Control 8.0
|
| |
I noticed that the Active X Calendar Control 8.0 control is not currently installed on my machines at work, and for now I am assuming that I will NOT be allowed to install it at my highly secure workplace. (I couldnt find it anywhere in the "Additional Controls" area) So.... Does anybody have any bright ideas on how to implement... more »
|
|
Calendar control code
|
| |
I have a calendar pop up using Ron DeBruin’s code. I use this in many of my spreadsheets and most have always worked as intended. I have two separate worksheets that now the calendar is changing size each time they are opened. The mystery is that on one the calendar gets larger, to the point that it... more »
|
|
Problem reading with Percentage values
|
| |
Hi, I am using OleDB provider to read excel file. I am facing the problem when reading percentage values from some excel sheets (very rarely). Suppose a cell has 42.3%, when reading the value it comes like 0.423... but while reading other Workbook's excel sheets (for those actual value is... more »
|
|
Do you need MS Access to query on an Access table?
|
| |
I'm asking these questions because I have looked at a lot of stuff in the discussion groups and still confused. I am fairly good at Excel programming but haven't been able to get Excel and Access to talk. First, I have Office 2003 Professional at work and Office 2003 without Access at home. I want to work on developing Excel programming at home which... more »
|
|
Application-defined or object-defined error
|
| |
I need help with this error. I get the error on line "ws.Range("E7").Value = mondaysDate(Weekday(Date)) - 7" The function run fine, its just that the erroe comes up when control is returned to the subroutine. And I don't know what the problem is. Any help will be appreciated. Thanks. Private Sub Workbook_Open()... more »
|
|
ListBox TextAlign-Property Question
|
| |
Hi, I'm using a ListBox with 5 Columns in a form. Is it possible to align the value for every column differently? Eg. Column1 left, Column 2 right, Column 3 left ... Regards, Rainer
|
|
Ribbon X macro not available
|
| |
I have created a Ribbon and everything was working fine until the last button was added then I got the macro not available error. I have all my trust settings wide open. Is there a limit to the number of items that can be added to a ribbon. Here is my XML The error happens on anything below Character Count... more »
|
|
Simple Range Syntax Question
|
| |
Right now, I have the following line of code in a macro: Range("B6:B129").FormulaR1C1 = _ "=YEAR(RC[-1])&TEXT(MONTH(RC[- 1]),""00"")&TEXT(DAY(RC[-1])," "00"")" Now I want to generalize the reference to select, starting in cell B6, a range that is X rows long and Y rows wide (X and Y determined elsewhere).... more »
|
|
retrieve an AVERAGE of a range using VLOOKUP to locate start/end d
|
| |
Can I calculate the average of a range based on VLOOKUP? In other words, can I get Excel to "look up" the respective START / END dates of an investment position listed in Sheet 1 and then go and locate those 2 distinct cell values in in a different sheet (Sheet 2) utilizing VLOOKUP function and then... more »
|
|
|