I have a spreadsheet that has a column of number of days - ie 10, i want to add this to a date, but want the days to be business days (weekdays). so if I were adding 10 days to 3/1/06 the res...
Hi i need a solution or Function which i can use to remove all non numric characters from a cell.
For Example if a cell contains $A16 i want to be left with 16.
Your help is appreciated
...
I created a macro and stored it in my Personal workbook so that it could be accessed from any workbook. However, I need to either edit or delte the macro as it does not work properly. Howeve...
I have an Excel spreadsheet where a user can select one or more of the cells in a column.
I don't know in advance how many cells in the column will have data, but I know that the cells will...
I have defined column widths in my Excel Worksheet. I have about 10 columns with varying column widths. I want to export this data to a FIXED WIDTH Text file, so that I can import that FIXED W...
I have a macro that does the vlookup from one sheet to the other, the code's below..
Application.CutCopyMode = False
ActiveCell.Formula = _
"= VLOOKUP(RC1,'[" & wb2.Name &...
Hi
I have a locked spreadsheet and i want to be able run a macro from a button to do the following:
1. Unlock the sheet
2. Ask user for a populated cell which they want to attach a hype...
Hi there - real newbie with the power of EXCEL and I'd like to be able to create / generate a bracket style tournament / competition draw in EXCEL but dont know where to start. There would be...
I have an Excel spreadsheet that I want to export to a csv (for later import into another application) but I need to have each field enclosed in quote marks. here's an example:
"John","Smit...
I have an Excel file with several sheets. I accidently deleted a sheet that I need. I know that deleted files can be recovered from the recycle bin when needed but is there anyway to recover...
When the end user opens Excel and closes excel they get the error Compile error in hidden module: DistMon. After clicking ok Excel works just fine.
I have a process running that is building a string log of events that I want to report in a text box. The string will get very long, but I want the text box (multiline is True and vertical scr...
I have column D on worksheet1 with 192 rows of data. I have column C on worksheet2 with 500 rows of data. I want to compare the data in worksheet2 column C to the data on worksheet1 column D b...
My Excel 2003 VBA Macros need to support both Outlook and Lotus Notes. Lotus Notes is new to me so I am experiencing a couple of problems.
Couple of Problems:
1) When remotely opening Lotu...
Hi experts,
I received a file exported from Notes into CSV format. Before I import it into an Access database, I load it into excel.
During the import to Access, it failed. I noticed tha...
I have a macro that I created in Microsoft Excel 2000 and it has been running correctly in version 2000 and version 2003 for a last couple of months. However, just last week, if the macro is r...
How do you calculate eigenvalues for a matrix in excel?
I am trying to convert text in one cell to Ascii Characters using a particular syntax. I know how to do it using Excel formulas, but what I would like is VB to replace the formula.
Cell C10 ...
Hi everyone,
I have this issue with 2 Excel files. No matter which one I open first, this error comes up. I can open another excel file with either one, but if both are open at the same tim...
I am making a chart of server processes that run in different timezones. I need to make a master list of these processes in GMT. Can someone suggest how to do this in Excel?
The heading w...
I have a database that can export data into various delimited files. What I want to do is write a vba macro that will read this text file that is created and insert the data into an Excel Spre...
Every time one of my users tries to open Excel, Excel appears to try installing something then gives an error saying D:\pa561401.cab is missing. It only allows you to retry or cancel. I am n...
We have one copy of office 2007. Evryone else is using office 2003. We are seeing extreamly slow file opening in the office 2007, about 1-2 minutes. Files are on the server (server 2003) Offic...
I am looking for VBA code that will parse out the text located in cell A1 into separate rows. Row 2 contains an example of what I am looking to accomplish. Some info on this problem:
1. T...
Hi,
I'm outputting recordset results from Access to Excel and would like to dynamically add the code to the spreadsheet necessary to provide the ability to click on any column header and so...
