Search results

I have tried this code but the excel file opens but all 3 tabs are selected together. It isnt selecting just the first tab. I know I can change the code so that I dont see the Excel file open by changing the xl.visible to False but then I need to select the first cell in the first sheet and then...

Thank you I will try this on Monday

They are make table queries.

Thanks any idea what VBA code I would need to open the excel file that I have created and set an active sheet?

It just automatically names the tabs with the name of the query that it is exporting. So there are 3 tabs named as follows. Portfolio_MainLive Portfolio_LimitedAvailability Portfolio_Clearance

The code below exports data to an Excel workbook with 3 tabs. The code works without any issues however when you open up the Excel file for the very first time it has all 3 tabs are selected and you cannot use any of the buttons on the Data tab ribbon until you select one on the tabs. Not a real...

You are just brilliant, thank you. works like a dream

thanks but I am not sure what you mean, where would I add these sorts of references. I just want to default the folder to point to for them to select the file from.

Just one last thing, is there a way to code in the VBA to default the browse dialog to a specific folder?

this did work after adding the library reference (as suggested by Gasman) but TheDBguy suggested a working alternative. thanks for you input though. This has taught me something new today.

thanks for this, works perfectly. Although I did have to add some further code to error trap when the user cancels out of the file Browse Filename dialog box. I just error trapper error code 2522 to exit out of the sub. You are a star and I didnt even have to add any library references for this...

I have the following code which imports a CSV file from a hard coded directory and filename (which is created dynamically) but I now need to change it so that the user receives a prompt to select the file they would like to import from a hard coded directory. This is my current code which works...

Thank you all so much for your input. I have a lot to read and digest here so I will come back to you once I am able to comment. Not sure what I will understand as I am no expert like you guys are. One thing I am wondering is how to properly close a connection once I close a form because it...

I tried that originally but couldn't get it to work, i think its either because I have a parameter looking up a reference on another form to filter the results or because I am concatenating a multi valued field. I might just remove the text box altogether to see if the issue goes away first...

I cannot make the concatenation query the record source of the form because I need to use a different query for that. But thanks anyway.

I just need to find out how to close them after they are no longer required. As I say I am no expert and still learning.

thanks for this. I have been using it this morning and it is very useful. I need to do some more testing using this but hopefully I will get to the bottom of the issue.

I am using on of Allen Browne's functions (see below) to concatenate related records into a string. However I am occasionally and randomly getting an error 'Cannot open anymore databases' and the title in the error message suggests that it is this function. One suggestion is that the function...

If I could have worked out myself that I only needed 4 lines of code then I might have tried it. The sample application looked a little overwhelming to a novice like me to wasn't going to attempt it especially as I am using a navigation form which in hindsight probably wasnt the best solution...

Yes it is really a navigation form which yes I wish I didn't use but I am stuck with it now. I wont bother with attempting synchronising the scroll bars now, the end user will just have to put up with it. Thanks for saving me a lot of wasted time.