Search results

This will open two workbooks and you can refer to them as wb1 and wb2. Public Sub FormatExcelSheet() ' removes excess row data from spreadsheet Dim AppExcel As Object dim wb1 as object dim wb2 as object Set AppExcel = CreateObject("Excel.Application") set wb1 =...

Remove the code that closes the book and then you can keep referring to it.

You also don't say why the code you found in the repository wasn't quite what you were looking for.

Wow not heard of anyone wanting to do that before. Try this

Or you could appoint more moderators or open up editing posts etc. to the vip group. I've seen what I suggested work elsewhere, they don't pay their moderators and their boards are busier than these boards.

Meh, who cares about posts or reps. How about a petition for site mods to start enforcing decent thread titles and use of code boxes?

Just the excel object library I think.

What you're doing really isnt that hard. Split function to split the postcode into 2 halves For the first half parse the string until you come to a numeric value thats the first part you need. The remainder of the string is the second part you need. For the second half parse the string until...

This should work for the first half. Sub blah() Dim i As Long Dim firstquarter As String Dim secondquarter As String strString = "M27" i = 1 Do While IsNumeric(Mid(strString, i, 1)) = False firstquarter = quarter & Mid(strString, i, 1) i = i + 1 Loop secondquarter =...

here's soem code I worte a while ago: Sub CreateGraph(ws as excel.worksheet, cht_sourcedata As Excel.Range, cht_title As String, _ x_name As String, y_name As String, xlapp As Excel.Application) Dim cht As Excel.Chart Set cht = xlapp.Charts.Add With cht .ChartType =...

Wow sounds like an ill thought out requirement. Best bet would be to use the "split" function with the space as a delimiter and then use the code you have to divide the two halfs you will get returned from the split function.

Whats the objective here? Are you trying to validate that postcodes are valid or something?

Yeah he can act in any role as long as it is a fat bloke from london.

Dave Grohl, undoubtedly the best drummer I have ever seen and he can sing and play guitar to boot.

I can't see any. If it is there you can point it out to me That doesn't make it any more likely that god exists No there really won't be. Ah so if I start wanting to hear imaginary things then I will hear imaginary things... explains a lot It must be true then:rolleyes:

Ahh you're hedging your bets. Doesn't the big sky fairy know this so he will kick your ass anyway? or does he not care why you worship him just that you do? I'll try and live a good life but not because some fairy says so rather that its the right thing to do, I really feel sorry for those who...

If the theists would just keep their superstitions to themselves instead of trying to get them enshrined in law no one would care in the slightest about what you believed.