workbooks | interactive programming environment that ’ s perfect

The following code does everything I want: pulls email, saves attachments, extracts files EXCEPT save the original email to the folder fDest. I seem unable to see the solution.

This seems to be the problematic line as it won't save the email: "mi.SaveAs fDest2, olMSG"

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"

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:

When I use PowerShell, I only get one (Workbook3) of several window titles (Workbook1, Workbook2, Workbook3), but I want to get the entire list of all open Excel books. I am trying to use the following code:

I am wondering if you could help me with this, I have 2 workbooks, one that is the main table and is a list of books with their respective authors, and each author individual author has an ID that is stored on the other workbook named AuthorData. My goal is to have a formula that looks for each author and returns their IDs on the same cell, separated by ", ". For example, I have book XYZ by ABC and DEF, ABC's ID is 123, and DEF's ID is 456; ABC and DEF are on the same cell, like [ABC, DEF] so I need it to read each author individually and return their ID's in one cell separated also by ", ", so it should be [123, 456]. I have tried with many different things but this has definitely beated me.

This is the best I could do:

I want to create a macro where it will copy some data from one workbook (whose name stays always same - "SameNameWorkbook") and pastes that data in another open workbook whose name is changing everyday (because its name is a date). For example today my workbook which I want to paste the data in is called "11.06.2021". What I did is I created a =today() formula in the J2 cell in the active workbook (different from the other 2 and named "CurrentWorkbook") and created a variable in VBA for the workbook with changing name:

I’m importing some messy data from a range of Excel Binary Workbooks (.xlsb) using readxlsb and cell_limits(), from cellranger. I'm struggling to get enough (all) decimal places.

This can be illustrated with the dataset that is supplied with the readxlsb package. In the example data, TestBook.xlsb, in sheet Sheet3.1.1, cell E5. This cell contains e^1, with a range of underlying decimal places (2,71828182845905), but is only imported with six decimal places (2.718282).

In my real life data I have text in a lot of the top lines, which convert the data to charters, like column.4 below, where E5 resides, and raw data with ~16 decimal places. Is there a way I can tweak the code (below) to get all the decimal places without loosing cellranger::cell_limits()?

I'm trying to make a script that loops through files and vlookups the name into an excel sheet.

I'm trying to run a macro that does three things:

1. Loops through a series of excel files
2. Identifies a row containing the text "project attributes"
3. Uses this row to set a range to perform a merge operation

I constructed this out of building blocks of code I found elsewhere, and I know that each works independently (i.e. I can run through all files without performing actions, and I can identify the row and perform the merge) but when I combine them, I get a run-time 91 error "Object variable or With Block variable not set" - associated with this line " FindRowNumber = FindRow.Row ".

Looking for guidance as to how I can avoid having this variable set to "Nothing" as it appears in the Watches window.

Thanks!