-
Hi Sam, Yes, that sounds like a lot of effort. Lifting a finger and all... You could code something that retrieves data from the other workbook without using the query editor. Basically an Open-Copy-Paste-Close action would do the trick. A userform could be used to create some flexibility for parameter...
-
Hi Rembo, Thanks for your post. Let me give you a brief background about the probelm The file that I am sending to my client already has a sheet which is getting data from an external file. Now my client thinks its too much of an effort to right click on a cell containing the data and then click on Edit...
-
Hi Sam, You could store the query (.dqy file) and use the following: Sub StartQry() Call Shell("Drive:\PathTo\msqry32.exe Drive:\PathToQry\YourQuery.dqy", 1) End Sub Haven't tested it under Windows Vista though. Rembo
-
I have a query on a sheet (pulling Data from another Excel File). I want to display the Edit Query Dialog whenever the user Activates the sheet. 1) I dont want to use the Sendkeys method 2) I have tried the below code in the Worksheet_Activate event and It errors out for some reason.... Private Sub Worksheet_Activate...
-
I'm having some issues importing external data from an Oracle 9i database. Here is what is happening: I am initially able to import data from the table I want to into Excel. I do this through "Data -> Import External Data -> New Database Query" where I have my .ORA data source. I'm...
-
Craig, Thanks for your post. I am not very familiar with ADOX so you will have to help me with the following a) Where do I specify the Path , File name and sheet name of the destination file b) Where do I specify the Range containing the table that I want to add. TIA Sam
-
Nick, Jan...thanks for your suggestions...I tried both but could not get them to work...could some one please help... Alternately Is there a way to excure DROP TABLE on a sheet without deleting the header rows... TIA Sam Excel 03
-
Does anyone got a code snippet to check if a specific MS Excel workbook is loaded when working within MS Access environment? Many thanks Alastair
-
I am trying to add a 3 column Table to a closed Excel File which has no Header rows Source Data is on Sheet1 from Cells A1:C20 - Named as Data Eg CLIENT REGION AMT ABB NORTH 123 CGL SOUTH 145 etc The Closed File is Called DB.xls and has a sheet called DB_CUST, located in D:\DATA\DB.xls There is no data...
-
Omar Certainly I suspect you will need to have multiple cells, which would not be ideal. I would suggest using a Pivot Table rather than the 'flat data' and then you could set up the employee IDs as a page field for example and filter out some. For help with Pivot Tables, there is some info on...