Recent content by Kobe2932

I think this is not the source of the problem.If you look at my code, it always stops at adding a new module, however the variable (xlmodule) is properly destroyed at the end of the code Dim xlmodule As Object 'VBComponent Set xlmodule = xlbook.VBProject.VBComponents.Add(1)...

Hello there Seems like the original thread I opened was deleted when the database broke down a couple of days ago. So, my problem is that I have 2 databases, and 1 excel file. The databases are identical in their function and structure - of course, macro names, references, variables have a...

Aah...never thought that could be the problem. I will try to update my code to have only one application open

I checked it. Both file is downloaded, saved separately, no macro is run. Tried to copy the data with Vlookup manually, but cannot cross-refer to the other workbook. If I select a cell, I can enter the Lookup value, but cannot select the Table array - my selection just does not work in the other...

Hello I have run into the following problem with my database. I have 2 excel files: temporary.xls - this is an import of an access query, generated from access 2010, and adding / running some formatting amcro on it. test.xls - this file already exists in a network folder, I'm opening it up...

bumping the thread. Anyone can help me how to code step 2 I'm totally stucked with the previous codes. What I want to do is having a macro in access 2010 which opens up a given xls file and automatically inserts and runs a simple macro on the xls file (like Hello World, or something). Do...

I want to achieve the following steps with simply clicking on the command button in Access 2010. 1, Download the results of a query from access to excel, create the same common_id column in the file and save it as temporary.xls- that part is done, perfectly working 2, opening up a given excel...

finally I got some imporvements, the code properly appears in VBA on the proper Sheet (Sheet1): Private Sub Worksheet_Change(ByVal Target As Range) Dim lngLastRow lngLastRow = Cells(Rows.Count, "A").End(xlUp).Row Columns("X:X").Select Selection.Insert Shift:=xlToRight Range("X1").Select...

Hi because it is a report with a standrad format and I have to update regurarly, as a new version of the report is published. I simply dont want to write / record / copy the macro every week as it is very time-consuming, but I want to automatize it, creating the code and running it from...

Okay, I have absolutely no idea what's going on here. I use the same code and it gives me a totally different result, the macro always stops at this line, and in the excel file it inserts the code separately, not between Sub / End sub....just like before LineNum = .CreateEventProc("Change"...

Hi the good news is that I've got some improvements, the bad news that it gives a different error message now :D I'm not sure why but access 2010 was unable to insert the code into an xlsx file, had to save the file as xls first. So here is the updated code I use: Function...

no success :( if I modify with this, the macro opens up the file, and opens up the Visual Basic window in the excel file, but still nothing else happens, no code is inserted and run on the excel file

any advice would be much appreciated ! unfortunately I'm kinda stuck here and cannot go on with further detailing of the macro

Hello Could you please advise what am I doing wrong in the following codes? 1. I'm trying to open an excel file from a given network folder, and insert some codes into it (the code is pretty simpe, just insert a new column in the file)- all from Access. The file is opened, however the code...

Sorry, but no, it contains business-related sensitive information, which is confidential. Anyway, the above problem I described - can't edit the single records from the search form - is appearing with Dynamic Multi Search sample database. Thought I use it as a reference and create something...