Column A contains Employee Id B contains Last name and C contains first name. I would like to develop a routine that:
When the user types the Emp id, last name and first name a new sheet is ...
I am writing VBA code to collect data from a DDE server in which the Alarms are coded in a bit field resulting in a format similar to "0,1,0,1,0,0,0,0,1,1,1,". What is the best way to capture...
Hi,
I have a financials sheet and I want to take a number like 5,550,000 and display it as "5,500k".
Is there a built in function for this or can someone help me with the VBA for a user...
Hi,
When I enter a dash in my Excel spreadsheet, it seems to get interpreted as a minus with Excel trying to build a formula for me. I've tried using both General and Text format, and get ...
I need to access an excel file that is password protected.
I forgot the password and now I need brake that password.
How do I go about doing that?
WE have several facilities (over 70 of them) that have returned their budgets. These all need to be placed into a single worksheet to be imported into our accounting package. The formatting ...
In my spreadsheet, I have 12 columns. Column E contains either Closed, Activated, Deferred, Open, Initiated, Approved, or Review. The range, i.e. E2 - Exxx, varies depending on what is retur...
I have a macro that copies and pastespecial into Word, and I believe that my macro is missing something. I want the pastespecial function to keep the formatting and colored cells setup in Exc...
Sheet1 cells A1 thru A100 contain a list of names. Sheet2 cells A1 thru A100 contain absolute references to the list of names on Sheet1, ie Sheet2 A1 formula is =Sheet1!$A$1
I made these r...
HI,
I have to long lists of email addresses, in column a and column b. Column a is much longer than column b.
I need to run a check to see which email addresses in column b are already in ...
I have a need to find all changes between an old version of a spreadsheet and a new version. The process is our customer updates the spreadsheet each week but does not have the capacity to ex...
Hi Experts,
I have a question regarding MS Excel Bubble charts.
I have a sheet with 4 columns of info, such as:
Product Risk Dev Cost ROI
A 2 ...
i have a list in excell of email adresses like this
user@domain1.com
user@domain2.com
etc
I need to take that and create it this way for a white list in word
user@domain1.com, user@do...
How can i open a workbook using an UNC path with EXCEL VBA-Code
Workbook.open "\\server\share\my_dir\abc.xls" doesn't work.
Do you know a solution ?
Regards
Guenter Haslinger
I am making a chart in Excel and need to distribute that chart in 4 groups and those groups must have different colors so that i can recognize and emphasize on those areas how can i do that in...
I have many people in my department and every time we print a workbook we need to manually add a footer to our excels that shows the filename, path and date printed. I am looking for an autom...
I got issue, something weired issue.
The problem is opening of only one excel 2003 from outlook 2003.
Currently this is happening only with one user and one email.
The Sender can open and...
This is a interesting problem. There is a spreadsheet that in the past would prompt that the file is opened by another user and marks it read only however, this is not the case any longer. T...
Hi experts
Recently I seem to have started having problems with remote links. I've never deliberately linked workbooks, but I do a lot of copy and paste between copies of workbooks. Recently ...
excel 2003
What I need:
I have data in Column A
words that are misspelled
I want to correct them and place the correct spelling in Column B
I would like to use the spell checker in...
I have an excel bar graph made. And I want to change the name of the legends on the graph. How do I do that.
Rich
I am trying to get the ISPMT function to work correctly, but I am a bit confused. The calculation is close, but not quite right. If I use peorid 0 as the starting point, then it is close to th...
Please could someone help.
I need to send out an email to all from a list of emails in a spreadsheet in excel.
For example:
Excel spreadsheet:
---------------------------------------...
I am struggled at copying sheets multiple times and giving them name by counting:
Sub Copy()
Dim x As Integer
x = 2
For numtimes = 1 To x
ActiveWorkbook.ActiveSheet.Co...
I export a Datatable into excel. While exporting I set the formats for columns based on the DataType of the DataColumn within the source DataTable. So for a Double I set the format as:
rang...
