Does Excel 2007 offer any features that provide an audit trail so you can see what changes have been made and by whom? So that the user can manage changes?
I have a file (attached) that has a count of items by SEC_CODE (two letter field) and an RP_Code, numeric value between 0 - 9999.
I want to sum each SEC_CODE by ranges of RP_Code. (1000's)
S...
Hi,
I have a datasheet in excel, one of the cells contains the reference to different PDF files on the PC.
I want to be able to create a "hyperlink" to open the PDF from within excel usi...
I have a form created in Excel 2003
In column D, I have the field names. If column F, I have empty "boxes":
D F
2 Phone Number: __________
...
Below is the Code Snippet
My computer freeze up and then restart and ask me for check Disk, finally hang in Deleting Orphan file record segment XXXXXX. Every time to i try to start the computer send to CHKDSK, Then i r...
I am trying to reconcile two sources of data and I need to identify missing information.
For example, I have a list of values;
175
179
179
184
185
185
188
191
194
205
206
206
...
I need help writing a VBA application to add print numbers to worksheet in an Excel workbook. The workbook will have many sheets. Most sheets are only one page, but this is not always the ca...
I would need to look and compare the ("Last Save Time").Value of a open workbook with the one on a server directory.
If the open workbook has a older date VBA should execute a macro called v...
I would like to change text color in Excel 97 based upon the results of an IF test.
As a pseudo code example:
IF( A > B , Use_Red_Text, USE_GREEN_TEXT) .
I had a question which has been kindly answered by an expert on the site but i would now like to ask the question, is there a reason for setting the created objects to nothing at the end?
S...
Hi Experts,
I have a spreadsheet which contains a series of serial numbers. I want to use these number in an SQL query. All of the serial numbers are in column A. See example:
QC000072
...
One of the Experts helped me to produce the attached spread sheet which has some very tricky sums in, I would like to be able to achieve the results in row 20 without having to have rows 12 -1...
Greetings,
I'm using VBA to export a query from Microsoft Access to Microsoft Excel using DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS... nothing special. After the export is comple...
i would like to have the plot area of a chart re-size to the maximum size using vba.can this be achieved.
I have a user form with a combo with several values to choose from.
These values are found in column A of worksheet "A." The worksheet contains several columns of date.
When a value is...
Hi - I've got a numeric field in a dataset that is the primary row header in a pivot table.
I want to sort the field in numerical order - this works fine until I group the field into bandi...
I have 3 columns that have cells that have the same color index i would like to get the range of the cells that have the same color index.
eg.columAr row6 to columAT row10 all have cells wit...
When you open an File on the Network that is already open by another user it doesn't display who its open by. See attachment screen Dump.
Any ideas
Thanks
Experts,
I've defined a name "Values" for a range of values which grow in nature by rows:
Sheet = "Workings"
Values = B25 onwards
=Workings!$B$25:INDEX(Workings!$B$25:$B$655...
I am getting multiple excel crashes. I have 3 to 5 workbooks open at a time and they will all just crash at random times. I don't have to be doing anything in them either. I can be in IE, O...
Can anyone tell me how I bold the word "Comment" in the below code.
Set rng = objsht.Range("a1").Offset(objsht.UsedRange.Rows.Count)
'rng.Resize(1, 1).Merge
rng.WrapText = True
...
I have the following data in column A:
abcdhtml
efgtxt
gpdfbf
dochtjk
I need to substruct the file extensions into column B:
HTML
TXT
PDF
DOC
I have 13 file ext...
A user reports that charts in Excel 2007 are moved (under, say, half an inch) and resized (shrink by 10% - 20 %) when the workbook is opened the next day. Has anyone seen this?
- His workbook...
Hi,
Excel Macro to check Data sheet and place all data in checklist sheet.For Reallocationfile
Check the sheet 'Data" and copy each data to the relevant fields and create new sheets for each...
