Recent content by lestatdelioncourt

u can do this in VBA, or with a macro. If u want to do it manually just import the file into excel, select the column and copy/ paste transpose. This will convert the column into a row. Here is the macro to do one file (called:tran001.txt) Sub Macro1() ' ' Macro1 Macro ' Macro recorded...

it depends on ur skill level. You can: 1) use an update query to update the column (would have to do each variation in spelling singly. i.e. one run to correct REMO to REM, one to do REMS to REM). 2) use a macro to do the update. 3) Use a vba module. This has the most flexibility and could...

or: Dim test As String = "c:\My Documents\Records\2096 My FileName.pdf" Dim fileName As String fileName = Regex.Split(test, "\\").Last.Substring(Regex.Split(test, "\\").Last.IndexOf(" ") + 1, Regex.Split(test, "\\").Last.IndexOf(".") - Regex.Split(test, "\\").Last.IndexOf(" ") - 1)

here is an example using regex: Dim test As String = "c:\My Documents\Records\2096 My FileName.pdf" Dim res As String() Dim fileName As String res = Regex.Split(test, "\\") fileName = res(res.Length - 1) fileName = fileName.Substring(fileName.IndexOf(" ") + 1, fileName.IndexOf(".") -...

this does too: Run ("workbook1.xls!Test()")

this seems to work: Private Sub CommandButton1_Click() ActiveSheet.Cells(1, 1).FormulaR1C1 = "=Workbook1.xls!Test()" End Sub

you do not need to use code. in the database properties is an automatic compact on close option

you do nto need to use code. in the database properties is an automatic compact on close option

looks like ur problem with the HLLAPI is that u need to call start up first: http://support.attachmate.com/manuals/extra/apis/whllapi.pdf

hi, I have done a similar thing before but I embeded the rumba window directly into access. This allows u to connect to the mainframe and do all of the processing without having to do sendkeys. This was a good few yrs back, so I can not remeber exactly how to do it, might be worth lokking into...

the excel interop relies on excel being installed where the program is run.

look into the excel interop classes, these allow u to create an excel spreadsheet, and populate the data.

you could just check to make sure that the previous days data is in the tables before u run the queries. (might not work if there is no data for weekends/ holidays). Alternatively change the process that populates the previous days data to populate a run date somewhere, then even if there is no...

set the background of each horse to transparent, not white

the: Dim Primary As New Form needs to be global then in ur code do: Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click Try Primary.Show() Catch ex As NullReferenceException Primary = New...