Search results for query: *

Hi all, What I'm trying to do is feed data from a table that has data loaded via a macro from Excel. What I then need to do is to feed this data into a query as a parameter, but at the same time use wildcard characters. The problem is when I use ClientName (which is the column from the table...

Got a bit of a weird one here, and I hope I'm missing something obvious. I have a workbook with 19 worksheets that make up a nicely formatted report. Each sheet has been set with the "Page 1 of ?" in the centre footer. Altogether there are 27 pages that should printed (some worksheets have...

Using Excel XP. I've created my own '.chm' help file for an Excel Application I've created. I want the help file to be available when the user presses F1, rather than the default Excel help file. I've assigned the file under the 'Help File Name' in Project Properties in the VBE window, but it...

I'm currently using the following code to open an access database, and then run a macro. I now want to apply a database password, but still have Excel open the database. Any ideas on how this can be done? I've checked and the OpenCurrentDatabase doesn't seem to have a password option. Sub...

Using Access 2000 on XP. I’ve got a main report which contains 3 sub-reports. The 3 sub-reports are based on nested queries. The report runs okay when I have a small number of records from the main query (around 50) but fails with anything larger than 200 records. It runs for about 30...

Is it possible to count the number of Windows open on a pc using Excel VBA? I.e. if I had open Excel, Outlook, Access, IE Explorer, it would return 4.

I'm calling a website (not google) from Excel using the below: Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.Navigate("WWW.google.com") The website automatically generates a spreadsheet in a second instance of Excel. This is all hard coded on the website and...

Why is it if you save a workbook as an HTM file, you get 262144 rows on a sheet, when a normal workbook can't do this? Excel 2002, OS XP.

Just came across this in the Access VBA forum, thought it might be of some use in here as well: thread705-796841

I'm trying to get the last part of a filename from the last "\" character. As an example I have: "\\servername\folder1\folder2\folder3\filename.xls" All I want is the bit "filname.xls". The problem is that the filename length will vary, so I was trying to use...

Hi All, I am running a macro in Access from Excel using: Set acApp = CreateObject("Access.Application") acApp.Visible = True acApp.OpenCurrentDatabase ("C:DATABASE.mdb") acApp.DoCmd.RunMacro "MacName" However it takes a long time to run, and Excel keeps...

Hi All, I know how to output data to an Excel workbook using: DoCmd.OutputTo acQuery, "Qry-Report", "MicrosoftExcel(*.xls)", "C:\Output.xls", False, "" But is it possible to output to a specific worksheet within the workbook? Thanks, Ian

Hi All, I'm having real problems searching for the month and year part in a range of dates. In column A I have a range of dates from 01/01/2003 to 01/06/2004 in that format (DD/MM/YYYY). I am trying to find the first occurance of a date that is greater than the 31/12/2003. I've recorded...

Is there anyway using VBA or not to get a clock in Excel. I know how to call up the current time, but as far as I can see that only takes a snapshot of the time the function is carried out. Is there anyway to get Excel to keep on refreshing itself? Thanks in advance, Ian