Search results

Hi all I am still trying to create a report in Word 2010 from data out of Excel 2010. As part of report I need to apply styles to text within the report so that the table of contents updates correctly. Despite every effort I have been unable to apply the formatting. In the following I am...

Hi Narayan Thank you so much for your guidance. Following on from your comments, I think I have it sorted, it took me a while, but: Dim myrows As String myrows = objtable.Rows.Count If myrows > 1 Then For i = 2 To myrows For j = 2 To intNoOfColumns objtable.cell(i, j).Range.Text =...

Hi Narayan Thank you, I have spent hours and hours researching how to do that. Are you aware of an online resource that would allowed me to arrive at that? I have read so many pages but nothing I saw looked anything like that! The same is also true for right aligning the text in columns 2 to...

Hi All I am really struggling with the formating of the text that is sent over to Word. Would someone please take a look? I have attached the updated example file and what I am trying to achieve in a docx file. I changed the file extension to txt to upload. Cheers Shaun

Hi wudixin96 Almost exactly like that! I had hoped that the data went across in the same format as in the spreadsheet but that does not appear to be the case. Is it possible to retain the formating, especially the number formatting. Is it possible to do that? Thank you for your assistance...

Hi All I am trying to get data from excel in to a MS Word document and I have found some code which gets me most of the way, but I am not sure how to modify to take the data from the cells and enter into the table. There are a few conditions for the Word table: row one will always be the...

Hi everyone Thank you for your replies. Narayan: You are correct, the width of a sleeper can be ignored for this purpose. Height and length of the sleepers are the only considerations as I am trying to calculate the number of whole sleepers in a given wall. In terms of calculating the number...

Hi All I am trying to work out how many sleepers are required to build several retaining walls of varying shapes and sizes. I have a long holiday period coming up. The trouble is if I order too few sleepers and need to order more the colours won't match as each set of concrete sleeper is...

Hi Nebu That worked an absolute treat. Thank you, I very much appreciate it. Cheers Shaun

Hi Everyone I am using a vlookup to consolidate what will eventually be 4 quarters of financial information. When a value is not available I am getting the error #N/A which I would like to replace with a 0. In Excel 2003 there is the ERROR.TYPE() function which I have tried to manipulate so...

Hi Kelly I am not sure how to have the 60 day mark only, but I think you will require additional gridlines in your scale to keep perspective. You can change the gridlines to intervals of 60 days by right clicking the Y axis gridlines (vertical lines), then select Format Gridlines, once...

I can't believe I missed that. Thank you.

Hi All I have a situation where an Index/Match evaluates to #N/A for each column in the same row. For each B1 value the #N/A will shift rows or not be present at all! I have tried re-entering affected data manually, but this does not correct the issue. I have rechecked the formula and it...

Hi Everyone I thought I would share the resolution to my query for anyone else who may come across this. Instead of importing Colum A data as a date, I treated as text by changing: .TextFileColumnDataTypes = Array(4,1,1,1,1,1) to .TextFileColumnDataTypes = Array(2,1,1,1,1,1) 1 =...

Hi Narayan Thank you for your reply. The problem is the two day gap between the five days of data. I would like to remove the two day gap. When the data is imported it is being converted to a 41XXX format but displayed as dd/mm/yyyy and I think that Excel is expecting to see consecutive...

Hi All Does anyone have any ideas on how correct they way the data displays when I change the axis type to xlCatergoryScale? Or possibly offer a couple of ideas as to what might cause the problem? Cheers Shaun

Hi Everyone I am having some difficulty with a series of charts where the x axis is a date series where not all dates a represented, typically Monday to Friday. This leaves gaps in the charts as the series is date formatted. After I set axis 1 category type to xlCategoryScale to remove those...

Hi Shrivallabha Thank you very much for your reply. The VBA code you posted is exactly what I was trying to achieve. Now to see how it works. Again, Thank you for your help, I greatly appreciate it. Cheers Shaun

Hi All I have a series of .csv files which I need import and save as .xlsx files. The .csv files over time will change with deletions and additions and the files getting additional data periodically. I have recorded and utilised existing code to cycle through the list of .csv files in the...

Hi Luke M and SirJB7 Thank you both for your solutions to the problem. This problem has been successfully solved. Again thank you Luke M and SirJB7 Cheers Shaun

Hi All I have a list of "jobs" to be completed, as the work comes in I enter the date the work came in (column O), from there the work is allocated out to various people. What I would like to be able to do is if I enter a date in say cell O3 "07/08/2013" (August 7) I would like Excel to force...

Hi Hui and SirJB7 Thank you both for your quick solutions. I see where I was going wrong. Thank you both. Cheers Shaun

Hi Everyone I am having a little trouble with some conditional formatting. I have some due dates: A1 `15/05/2014 A2 `31/03/2014 A3 `28/02/2014 A2 `31/10/2013 ...and posibly some others What I am trying to do is set a rule which fades from green to yellow to red the closer I get to...

You are right, it would fail in that case I didn't give any consideration to that scenario occuring. Any tweak would result in more characters!!! That was a good challenge. I look forward to the next one. Cheers

Oh Wow, so it was possible, just not <139 characters I don't think I would have ever arrived at that. Especially the idea of reversing the string, let alone working out how to do it. Cheers