Macro | Text editing tool that records & reproduces keyboard events | Keyboard library

Although I am very rusty on my VBA, I have saved sheets to new workbooks many times before. This code is failing with the error code "Method 'SaveAs' of object '_Workbook' failed"

My first question on stack overflow! I'm new to VBA and am building a macro that selects data from downloaded .CVS sheets and inserts them into an existing workbook. The downloaded .CVS sheets have names titled "payment history######-#_date" whose numbers (#) correspond to account numbers which represent the rows in my other workbook. There are more than 60 account numbers.

Now, I'm stuck on the most important part of the code. The idea is to loop through the range containing the account numbers and use a like function to match the account number to the number portion of the worksheet name. It would go something like this:

What I want the Macro to accomplish:

I want the user to be able to fill in data from E2 to E9 on the spreadsheet. When the user presses the "Add Car" button the macro is supposed to be executed. The makro then should take the handwritten data, copy everything from E2:E9 and put it into a table that starts at with C13 and spans over 7 columns, always putting the new set of data in the next free row. It is also supposed to check for duplicates and give an alert while not overwriting the original set of data

So my problem is, that I want the Macro I'm writing to take the information put into certain cells and then copy them into a table underneath.

I'm starting the Macro like this

I'm trying to import a macro defined in a utility package, but when I try to use the macro I get a message that says that debugger invoked on a UNDEFINED-FUNCTION my-macro and that my-package:my-macro is a macro, not a function. However when I call functions defined inside that same package I got no errors.

I'm fairly new to VBA in general, but currently I'm working on publishing a document utilizing IBM's Rational Publishing Engine which publishes a document out of DOORS (Dynamic Object Oriented Requirements System). After publishing there are a series of macros that are utilized to expandOLEs, merge paragraphs, centerFigures, etc. I'm looking to add a macro that will adjust my table of contents to only show levels 2. I was thinking something like the below would work, but have not had much success.

If I insert a header or footer from the quick part gallery, it usually adds a standalone paragraph character on the next line.

This is extremely annoying because it requires cleanup every time. Is there a way to prevent this behavior? A couple of the default headers from the quick parts gallery do not do this. The ones I've created myself do - for both header and footer.

I've currently got a VBA macro that adds all these headers and footers automatically to documents in a directory, but it doesn't do me much good when I have to go in and hit delete twice for every document anyway. I can find and replace the paragraph markers (^p^p) through the script (which only works in the header), but doing so strips the style from the header. I'd rather these just not be a part of the quick part if that's an option. They weren't there when I saved the part out. Any thoughts?

How can I refer in VBA to a previously newly created workbook within the same macro? For example, I copy something from A2 in the active workbook, then I create a new workbook, paste there in cell B3, return to the first workbook, copy cell A3, return again to the newly created workbook and paste in in cell B4.

So, what I need is the code for this part of the sentence: "return again to the newly created workbook"

My code till now is this:

I am trying to insert a table of contents into a Word document using one of the built-in building blocks that define a table of contents. When I record a macro and insert a table of contents the macro recorder gives this line of code:

I wanted to update the entire row with new submitted data based on ID. I have a form on my page that sends the data to my sheet using Javascript.

Here's the simple script that sends based on input ID: