Search:
Type: Posts; User: brjames32
Search:
Search took 0.06 seconds.
-
August 5th, 2009, 09:00 AM
All sorted! In the end I created a macro within the apreadsheet with the following code:
Sub RenameFiles()
Dim SourceName As String
Dim DestName As String
Dim row As Long
For row = 1 To...
-
August 4th, 2009, 08:24 AM
Hey DataMiser
Thanks for the reply. Will try that out and let you know how I get on :)
-
August 4th, 2009, 05:16 AM
Hi dglienna
thanks for the reply. I think a bit overkill for what I need. All I need to be able to do is compare the filename with values in Column A in the spreadsheet. If it exists in that...
-
August 3rd, 2009, 05:29 PM
-
August 3rd, 2009, 08:08 AM
I think the countrol you are looking for is now called the TrackBar in VB.net
Or
there is also the HScrollBar depending on what you are trying to achieve :)
-
August 3rd, 2009, 04:50 AM
Hi people
I have around 1300 jpeg's that need to be renamed based on the value in an excel spreadsheet.
What I need to be able to do is parse each jpeg in a directory, compare the filename to a...
-
June 24th, 2009, 04:55 AM
Hi Hannes
Thanks for the great info as usual ;) It works a treat!
It was a mistake on my part. I took the code form an old VB6 prog I wrote years ago and forgot I couldn't just copy and paste...
-
June 24th, 2009, 02:46 AM
Hi people
I am trying to allow the user to launch the Windows Screen Saver by clicking on a button. I have the following code:
Option Explicit On
Public Class Form1
Private...
-
Hi
Sorry - I am using MSAccess
-
ComITSolutions - thanks for the reply
I get the error:
pointing to your line of code.
Any ideas?
-
Ah yes - didn't think about that. Will give it a go and let ya know how I get on.
Cheers for suggesting that ;)
-
My code is now:
Dim ukCulture As CultureInfo = New CultureInfo("en-GB")
Dim ukSDate As DateTime = DateTime.Parse(SDate, ukCulture.DateTimeFormat)
Dim ukFDate As DateTime =...
-
komalo
Thing is, I need the whole date though :(
-
Dglienna thanks for the help so far :)
I get the error 'Parse is not a member of String' for this part:
and also the error 'Value of type 'System.Globalization.CultureInfo' cannot be...
-
Hi DGlienna
Thanks for the reply. I can convert most of the code you gave me but not all of it. Any chance you can help me out??
Thanks
-
Just tried that and selected the dates: 01/05/2009 and 07/05/2009 but when the DataGridView is populated, the dates range from 05/01/2009 up until the present day!!
Something is swapping the dates...
-
Hi Hannes! :)
Cheers for the reply. I have tried this:
SDate = sDateTime.Value.ToString("dd MM yyyy")
and also changing the Format to custom and entering dd/mm/yyyy in the CustomFormat...
-
I am using a DateTimePicker to allow the user to select dates between which, info from a database is selected and displayed in a DataGridView.
This works fine exept that the dates selected by the...
-
That's great - thanks ComITSolutions ;)
-
Yep sorry shouuld have mentioned that - they are variables!
Will give that a go now . . . .
Cheers
-
Hi
I have a small problem with the SQL statement that returns the information from an Access 2003 table based on the dates input by the user. IT works fine if I manually code the dates as below:
...
-
February 26th, 2009, 02:27 AM
Cheers for the reply. Believe me, if this if Homework as you suggest then I must be the oldest student in Britain at 31!!
I was just very tired just like yourself after a 10hr shift then coming...
-
February 25th, 2009, 03:30 PM
Hi people
I am creating basic slideshow form to finish off an app I am writing. I have been at it all day finishing off the main app and am getting very tired now!!
Anyway, I have a form...
-
February 25th, 2009, 10:19 AM
I couldn't agree more!!! :)
-
February 25th, 2009, 09:44 AM
Forget it - my Brain just switched back on!!
|
Click Here to Expand Forum to Full Width
|