Search results

THis won;t work, as then all the remain rows will only have the first 11 columns exported and not all 23. Thanks anyway Geoff

Hi there, I have a table which is 23 Columns Wide, the data in Row 1 only contains data in the first 11 Columns. I need to export this to a csv file but I can use the usually export features of Access as it adds 12 extra delimiters on the first line which causes the file to fail in the next...

Dear all, I have the following code, I just can't get my head around this, I'm more use too writing code in Access which i so much easier than excel Private Sub Workbook_Open() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Range("A1").Value = "Field01" Then...

Thanks works great now

Hi there, I am trying to fill in a webpage with data from access using sendkeys, I see that you managed to get it working could you please post the code you used. Thanks Geoff

Thanks for that, I have been using this but can't work out what to replace "Calculator" with Any ideas? Thanks Geoff

Hi there, I am trying to activate the internet exporer window with no luck. Does anyone know the correct code for doing this. Thanks Geoff

Hi there, I am able to open a particular web page in access, but what I now need to do is populate a text box on the web page with a value from my database. Is this something that anyone has been able to do. Thanks in advance Geoff

Hi Pat, What I am trying to do is sort of transpose the data, as it comes in 4 rows and 1 column, I need to append it too a table with 1 row and 4 columns. Hope that makes it a little clearer. Thanks Geoff

Hi there, I have the following code Option Compare Database Option Explicit Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" _ (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, _ ByVal dwReserved As Long, ByVal lpfnCB As Long)...

Hi there, I have the following data ID Field1 84 "<font color=""#000080"">MILANO</font>" 88 "<font color=""#000080"">IT</font>" 218 "<font color=""#000080"">LONDON</font>" 222 "<font color=""#000080"">UK</font>" I need to wite the value in row 84 to column 1 of my table, 88 to column 2 and so...

Thanks Ken, I have automated the download now I get a text file with html tags but I can work with that. Thanks Geoff

Hi there, I then import the text file and take the information from the 4 of the rows that I need, I have it working manually but need to automate the download and saving of the web page. Thanks Geoff

Hi there, I want to be able to open a Web Page and save it as a Text file using vba, but I need to do it in the background so you don't see explorer. Any ideas anyone? Thanks in advance Geoff

Hi there, I have a text file which I need to import the 28th, 30th, 78th and 80th line from. Can this be done? Thanks Geoff

Hi there, Use DoCmd.SetWarnings False 'Before DoCmd.SetWarnings True 'After Thanks Geoff

Hi there, I am using open/save.browse dialog box for saving the file path to photos the problem I am having is that I need the dialog box to open with files shown as thumb nails. Any ideas? Thanks in advance Geoff

thank you very much works a treat thanks geoff

Me.PartyName = StrConv(Left(Me.PartyName, InStr(Me.PartyName, "-")), vbProperCase) & StrConv(Mid(Me.PartyName, InStr(Me.PartyName, "-") + 1, 50), vbProperCase)

if you use instr to find "-" and then proper case the two names and rejoin, that will work