vba problem

Hello to everyone I have a small problem...When I save my xlsm page in CSV UTF-8 with simple way File --> Save As --> .... the file is saved correctly and works normally. ΅When I save with this VBA code: Application.DisplayAlerts = False Sheets("SYSTEM (CSV)").SaveAs...

The exercise is: There are 5 employees in your small business who can perform any of the 5 different tasks that your company has. The following table shows how many hours of working time are required for each employee to perform each obligation. Your job is to split these responsibilities so...

This VBA code I am using has a problem I hope someone can help me with. The code is posted below. What the code does is concatenate columns A-G into K but what makes it unique is it bolds the first sentence of each cell in the result column K and preserves the way dates are actually appearing...

I'm using Excel 2003 and my code is supposed to delete the calculations leaving just the values. Everything seems to be working like it should 'till the code is supposed to delete the original data rows / columns: Rows("1:67").Delete Shift:=xlUp Columns("A:AJ").Delete Shift:=xlToLeft The code...

I'm trying to find some code which when exiting a VBA text box will check its contents are in the right format I.e time or %. What would the code be to throw up a stop message if incorrect?

Hello This works fine with excel 2003, but now I´m moving to excel 2007 and don´t know how to change "filesearch" code. Can anyone help me?? thanks in advanced _____________________________________ Private Sub Workbook_Open() Application.DisplayAlerts = False On Error Resume Next...

Hi, I'm trying to input a formula into a cell using the FormulaR1C1 method, but I've hit a small problem. Basically the formula I'm inputing refers to the adjacent cells e.g. Activecell.FormulaR1C1 = "=RC[-1]+RC[-2]..." However what I'm wondering is is it possible to input a formula that...

Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I've got a For..Next statement that inputs a piece of text into the activecell, then colours the cell and adds a border. My problem now is that I need it to adjust the column width so I can...

Hi, I'm wanting to input a formula (and not a value) into the activecell, which adds the first cell to the left and right of the activecell e.g. if my activecell was B1 the formula would be "=A1+C1" What I'm wondering is, is it possible to generalise the above, that is, if my activecell was E1...