Recent content by forrestgump

I found the reason for what was going wrong i needed to put xlapp in the destination part Destination:=xlApp.Sheets("Sheet1").Range("A1")

Unfortunately, I wont know how to do all the manipulation in Access that i need to do. Which causes other issues.

Hi thanks for your reply What I am trying to achieve is:- open excel from access then open the csv file in excel so i can edit Does that make sense?

Hi there, I tried the above, unfortunately I couldn't get it to work. Any ideas? Regards, Forrestgump

Can you expand on the above how do I import a file into access using this? Kind regards, Forrestgump

Hi all, I am trying to open a blank excel workbook from MS Access and then bring in the data from another excel file. I need to do this because of the file i need to open is a csv file and if I open it normally i lose leading zeros. I have tried the below code but i cant get it to work. Any...

Thanks that works great!

Hi there, I have a stacked rows of data in a table and i want the query to just return the entire row of the row with the earliest date. I have tried a varitety of things to achieve this but with no luck. I tried by Group By on just the emp id record and then selecting on first for all the...

Hi All, How do i open a new instance of an excel workbook from MS Access? I can open workbooks that are already created with the below code but not a new blank workbook:- Set xlWB = .Workbooks.Open(Me.filepathbx & Me.lstFileList.ItemData(i)) Any help would be much appreciated. Regards...

HI there, I am trying to open an excel file from MS Access in MS Excel so I can add some vba to remove the top 3 rows of the excel sheet. However, with the code below I keep getting a "User Defined Type Not Defined" error on the first line of the code. How can I stop this so the code will...