I have an Excel spreadsheet with columns: | A | B | C | D | | Job number | Status | Actual Hrs | % Complete | 1___|____________|________|____________|____________| 2___|____________|________|____________|____________| I have a macro to obtain the following string from…
I have a directory containing tens of thousands of csv files (that used to be HTML files but I wrote a different vba script that changed the extension to csv), that I want placed into one Main xls file (called…
I'm trying to extract the Compression attribute from several thousand jpeg files. How can I do this with either Excel VBA or PowerShell (or some other method)? Some users haven't used the correct technique to convert tiff or png files…
I have a column in Excel where I have downloaded data, I would like to create a macro that would take that initial column of data in JSON and then return new columns of data where the information is correctly…
I'm trying to generate a draft email using VBA code from excel file. I'm stuck from adding the default signature and maintains its format. My current code can add the signature but the format has been changed. What should I…
I am trying to set up a macro within VBA to pull a price from a specified website and update the price within my worksheet. I am not very experienced in VBA or HTML, so I followed some tutorials on…
I am currently encountering an issue with the xlwings package while working on a project in Excel. When I use the command xlwings vba edit to import VBA Modules into Visual Studio Code, all special characters (such as "ä", "ö",…
I'm currently working on a script where I import a .json file into a microsoft access database, so far each field enters without issue, except for one field where the characters are more than 255. To overcome this, i've tried…
I'm working on a project to automate the extraction of data of how the various stock indices are performing into Excel from Yahoo Finance. But the problem is that all the code and help videos I have found online use…
PHP Excel - modify .xlsm file with macros without loosing macros Is there any php library or approach to modify xlsm file which has macros without loosing macros. I want to export large data in xlsm template. the xlsm template…