vba & excel 2019

A little bit of a strange one for me as I have experienced this issue before . I have a sub which is a file picker. This allows a user to navigate to a windows folder and select 1 or many text files and then import them into Excel. Excel is *supposed* to import all selected text files in to an...

Windows 10 Excel 2019 In Column K, the cells are populated by a formula. In some cells the formula will have nothing to return ("") and Excel inserts a (') Apostrophe which I need to remove but only for the cells where the formula has returned nothing. I have the code below that selects...

Sub CopySheet() Worksheets("Sheet3").Copy after:=Worksheets(3) ActiveSheet.Name = Format(ActiveSheet.Range("D28").Value, ("DD-MM-YY")) End Sub

I have a cash statement as in above picture for a specific cash account, which includes the following: Transaction date Amount in or out Charged account number and name Description Document reference Transaction currency and exchange rate I need to convert this statement into journal entries...

HI All, Am looking for a vba code to select a file from a folder and unzip the file in a different folder with different file name. Can you please assist me with the code. Thanks in advance.

Hi Team, I'm facing the current scenario, I will start by placing the sheet that i'm working in and then bring up what has to be done: ABCDEFGHIJKL12UUIDWhatsover1Whatsover2Whatsover3Whatsover4Whatsover5Whatsover6Whatsover7Whatsover8Whatsover9Adjust and...

Greetings everyone, I have a question (as seen in the title), which is kind of a pickle. (Using Microsoft excel 2019, on Windows platform) Basically, I have an Excel document filled with Tables. 50+ or something. The logic behind what I want to do is easy enough; I want to select specific...

Hi Friends, I am trying to add sequence/following numbers in ColumnA based on cell value in ColumnB. I been doing it manually, but its taking countless hours to go through thousands of rows. Thought that I can get some little help here. Attached the spreadsheet to understand more. ( Hightail...

Hi friends, I been trying to find some vba automation to fill my needs today. Attached are sample test file along with outputfile format. I did used vba for inserting number of rows required at some point between rows. Please take a look sample output file with highlighted rows and compare them...

Hi, I am trying to pull (from an Excel 2019 workbook) the text effects (outline, shadow, reflection, glow) applied to different paragraphs (or 1st word in each paragraph) of a Word 2019 document. When I run the code, although the Word document has text effects applied to each paragraph I get a...

Hi Friends, I have 100s of Excel workbooks with single sheet in each. Every time I have to open each workbook and run the macro to do the job. I am looking to modify and run the macro on list of workbooks in folder one by one. So Macro will run through all excel files in folder one by one and...

Hi Friends, I tried looking mrexcel posts and google sources for query to find VBA answer. Here what I am looking for is: Sheet1 ColumnA has data of boolean strings like attached in the document. The row numbers varies every time whenever I change the data. Boolean example has shown in image...

Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details. Need a formula to find list of words before a (,) comma from sheet2A:A in Sheet1A:A(there is no data range like A1:a10) and extract text before the...

Hello, This may or may not be a simple porcess as I am very new to coding for macros. I have 3 processes I want to implement into my excel. First, I want to change my current highlighting process for columns I & J. They are highlighted green for all non-blank-cells. I wish to highlight them...