Hi Isaac,
Thanks very much for your feedback and apologies for the late reply. I'll certainly look into this. At face value, getting rid of select/activate etc. seems quite daunting but I bow down to superior knowledge on the subject and I'll have a gander.
Thanks again.
That's what's strange! It's quite an extensive excel macro with a number of tasks being run and goes without a problem. It even opens and closes other excel files without a problem later in the code. It is purely when I try to close a specific file (that will already be open at the time of...
The below is the code in my access module. It opens the excel file containing the macro perfectly fine.
Dim XL As Object
Set XL = CreateObject("Excel.Application")
With XL
.Visible = False
.displayalerts = False
.Workbooks.Open path...
Hi All,
I have a module run from access that does a few things then opens an excel file and runs a macro on that excel spreadsheet. Running the excel macro from both excel and access worked perfectly fine. I realised that one of the excel files that will be opened as part of the excel macro may...
Hi Both,
Thank you for your replies and I apologise for the delay in getting back to you. I have found a solution by the user being able to switch between an "edit" mode and "search" mode on a form. So at the click of a button they can record straight to the table or view info. I would like to...
Hi all,
I have a query that gets info from 3 tables. (See attached)
However using the links that I have used and require It does not allow edits or additions. I understand why it is not letting me do this but I am asking for the best work around. I would only need to make edits and not...
Hi,
I am hoping there is a way to lookup a value in multiple excel files from Access VBA.
There are multiple excel files in location "F:\EVERYONE\Toby" that all start with "SP2240-170" and end with a date range. This date range will be generated by the Excel file automatically based on data...
Hi RanMan,
Thanks for you reply. I'm wanting the parentform to be in datasheet view for general use. I'm was saying that in form view it seemed to work.
The subform is linked to the parentform on SN field.
Many thanks.
Hi All,
I have a form with fields [RER] and [SN]. The record source is Table_1.
There is also a subform that has fields [RER] and [SN]. The record source is Query_1. Query_1 is a Select Query from Table_1.
subform is linked to parentform on the SN field.
I have a macro On Current event of...
Hi Minty,
I love this! Looks very useful for the future. Unfortunately I can't get it to work for just folder names. It seems to want to limit it to files as you have to define the file type ".xls" or ".doc" for example. I've had a play around with it but with no success. I'll keep trying as it...
Sorry for the late reply! Not been able to get back to this until now.
I have tried this:
excelloc = Dir("F:\CELAB\EVERYONE\Toby\DSL Database\SP" & lassy & "*", vbDirectory)
excellocs = "F:\CELAB\EVERYONE\Toby\DSL Database\" & excelloc & "\DWGSET\" & ljob & ".xls"
But it still isn't taking...
After fiddling around with it it seems as though it isn't picking up anything before the SP2270 and is defaulting to this new local location.
I set up a textbox that shows the path just for fault finding purposes and it's only returning "SP2270" onwards...