Search results

Hi everyone, I am building a select query which is grabbing data from multiple tables with items being linked by a unique field "Certificate_ID". I have created joins between table A and Table B, and Table A and Table C, linking both by Certificate_ID All have the join property set to...

I changed the code to search for *.xlsx files and it was successfully able to grab the desktop file which it would not before. Although I guess this solves my problem I am still quite confused. When I only had *.xls it was still able to grab the file from my network drive, even though that...

That doesn't seem to be the problem. The path has a backslash.

Hi all, I have a module for importing several excel files from a folder in Access. The user is prompted to select the folder which contains the Excel files. The issue: The code works fine if I select a folder from my company network drive (strFile variable returns with correct file name)...

If I link them will the user of my Access DB also have to have the excel files on their computer or some shared drive? Also the names of the excel files will changes each time. A timestamp is part of the filename.

I am not sure I understand what you mean. I already have a way to get the data into Access as separate tables. What I need is a way to combine the Access tables of similar type. And likely do so using VBA so someone not techincally inclined can perform this.

Yes. They are extracts from a larger database that represent different periods of time. So the 6 workbooks might be months January - June for example. So in the future there will be more workbooks, and the time increment might be different. Workbook 1 might not always be just January.

Hi everyone, I have a database which is importing several Excel workbooks, each with multiple worksheets. Every workbook has 20 worksheets, with the same 20 worksheet names. When they are imported they come in as one table for each worksheet, named tblWorkSheetName_X with X starting at 1 and...

Hi Rx, I ended up spending too much time trying to pursue this access solution and instead had to work around by building 2 macros in Excel which 1. Pull all of the 6 files together into one with separate worksheets (120 worksheets), and then 2. combine similar worksheets to create one...

Lazy is far from a good word to describe you after how much effort you are putting in to helping me out! Private Sub Command0_Click() Dim blnHasFieldNames As Boolean, blnEXCEL As Boolean, blnReadOnly As Boolean Dim intWorkbookCounter As Integer Dim lngCount As Long Dim objExcel As...

Oops. Ok so with the variable names fixed I am able to step through my code with no error messages. I am confused on the purpose of this new code though was this just to test some things?

Rx, thank you for continuing to work with me here! Error in this line ==> objxl.Visible = True "The error was 91 Object variable or With block variable not set"

When I execute debug -> compile db, nothing seems to happen. In references --> tools I have Microsoft Excel 14.0 OBject Library checked and don't see any other excel items. When I try to step through the code it skips straight from the break at Set objExcel = GetObject(...

Wow thank you for the tip Rx. When I perform this action it highlights the line in the code you gave me. objexcel.visible = true with "The error was 429 ActiveX component can't create object"

Hi all, I am very new to using VBA so could really use some basic help! I have a set of Excel files with several worksheets in each. These worksheet names are common across the files and all of the files are located in one folder. I want to import all of these files into Access as separate...