Search results for query: *

it's ok, worked it out ...

Anyone know where it is ... i can't find anything!

Does anyone know how I can kick off a DTS package from xl vba?

Sorry should have said, db i'm using doesn't accept TOP !!!!

I've created an ADO connection within DTS using vbScript ... can I limit the number of records returned? I've tried using MaxRecords but it doesn't like it! If Not isNull(recSQL(5).Value) then connDW.MaxRecords = recSQL(5).Value End IF connDW.Open = "DSN=" & recSQL(2).value &...

Cheers guys, i was using the wrong wildcard. J

Thanks for the reply, but I tried that, it doesn't work either. Using Chr(34) was just a different way of enclosing in quotes.

Using ado from excel to execute sql statements against an access db. I have a problem when using the "like" statement though, as it never returns any data. Even though if i paste the same sql into the query builder it returns data. i've tried diff wild card characters ... anyone help???? sql...

Simple! I do love VB ... Thanks for the reply ... it's starting to make sense. Cheers James

Hi all, Can someone give me a clue what this function is doing? I'm not, as you may guess, familiar with Javascript, but doesn't stop the boss asking me to look into it! The function I believe, should be counting the number of jpg's in a folder 'charts' that start with a specific string ...

Is it possible ... if so how?

1. Can you remove options from the autofilter drop down list ie the (Blanks) / Top 10 etc. 2. Can you detect when an autofilter has been applied / removed?

I have a column of TEXT formatted cells in the with dates in the format DD/MM/YYYY. when using cdate in vba to convert to a date, the dates seem to randomly convert to both UK & USA date formats, even if i use the format command to try and force it to DD/MM/YYYY ... any ideas?????

Is it possible in workbooks open, to determine if a reference is missing to avoid the compile error message. Is it also possible to select another ref instead, ie if word 10 missing and work 9 available use that???? Cheers J

I do have that in already! Sorry just edited out that bit of the code. calculation is turned off too.

I'm using the code below as part of a subroutine to reformat some Excel data files. When I run the code from an Excel module it takes around 1 to 2 minutes to process the data. When I run it from Access, after creating an excel object etc, it takes 30 minutes +. Can anyone suggest why / how I...

do you really want to delete it? You dan just hide TexboxName.Visible = False Or disbale it TextboxName.Enabled = False

Can you disable macros when using workbooks.open? If so what;s the syntax? cheers

Actually pressing f9 (calc) causes the same error so it's not nec. vba related ... but still any ideas why this is happening?

Hi all, I've got numerous workbooks made up from the same template workbook. On the Workbooks_Activate event there's a line: Application.Calculation = xlCalculationAutomatic Which works fine on some workbooks, but on some i get a critical error, asking me to send report to MS & recover etc...