import

Hello, (First; I have Office 2016 at home) I want to run a statistical analysis on my photos that I have taken over the years to see what my most used focal lengths are. The focal lenght in the EXIF data is available for windows explorer and can be seen like this: In excel, I just learned...

I have daily .txt reports that I would like to import into excel as separate sheets in the same workbook. My problem is that 3 of the 4 files have fields that are numbers that are 20 digit account numbers and import as scientific notation. I want them import as text. I am currently using the...

Hello there, Although this is predominatley a Power Query Question, the criteria are obtained from an Excel Sheet and the output placed on 1 Excel sheet. I have some PQ code (Windows Excel 2016) that will load a single pre-specified CVS file into Excel as follows: Excel Sheet1: Excel Name...

Hello, I haven’t used Excel for anything other than work info recently and need to import my phone bills into Excel. I’ve tried converting them to .txt files prior to importing and the results are…not great. Does anyone have any tips on a better way to import? The phone bill is for multiple...

I have a VBA macro that i want to run. It is supposed to pull MP3 + Wav meta data into excel. When I run it, it seems to work but doesnt actually pull in any data. Can anyone suggest what might be wrong? I am very inexperienced with VBA. Thanks, WC

Using Google Sheets. Column A contains a list of products. That list is imported from outside Google Sheets (Shopify). The list constantly changes as new products get added or removed. When products are added they don't necessarily get added to the bottom, they get added anywhere on the list so...

Hello gurus, I've been trying to nut this one out but it's got me stumped. Scenario: I have two worksheets. The 2nd (System Security Plan Annex Template (March 2023)) is considered a new version of the first (System Security Plan Annex Template (December 2022)) therefore it will mostly have the...

Hi! I have a macro/vba that imports a .txt file (i wanted to be able to assign the macro to create a button to import rather than copy/paste), I just wanted pastevalues starting with a specific cell, keep the layout/formatting because its in a nice grid. I had it working fine for a week then...

Hi, I have this google sheet, with these columns: EAN, TITLE, AUTHOR, PUBLISHER, YEAR, PRICE Starting from EAN data in column A is it possible to pull the other data (title, author, publisher, year, price) from https://www.ibs.it/ as in the example (raw 3)? Thanks very much!

Hi, I have looked around and haven't found a workable solution for what I am trying to achieve. I have a query (importA) importing data from txt files, and I have a sheet (ManualData) for data to be put in manually. I want to add a setting option (toggle/radio button) to set the query source...

I have multiple word documents (over 200 individual word files), that I need to import to an excel spreadsheet. The excel sheet is already populated with specific fields (columns) that the data from the word documents needs to be mapped to. However, the word file is not really prepared in any...

I have some vba to import a document and I call it using a button but I found if I select nothing and hit 'cancel', it's closing the entire workbook. How do I avoid this? Code I'm calling: Sub ImportR() Application.DisplayAlerts = False Application.ScreenUpdating = False...

Hi all, I am currently wondering how to allow only a single user to use my excel spreadsheet. That is I send it to the person, they download it, and then if they try to send it to someone else, the formulas in the spreadsheet stop functionning. My inital thought was to make a formula ,using...

Hi All I have recently used a VBA code, which works with selenium. The code allows you to use an excel spreadsheet to send messages via whatsapp, automatically. You may have seen the youtube video for the guy who wrote and offers the code, along with the spreadsheet: However I have vast...

I need a macro that will import an excel file into my current file and replace a sheet with the imported file. How would I do this?

Hi, I’ve got a folder that has got multiple excel files (50+) with each file containing a weekly summary. As it is a weekly summary, each week, a new excel file is added to the folder. Currently, I’ve got a “master” excel file that is linked to that folder using PowerQuery and imports all the...

Hello. I need a macro that I have no idea how to even start making. I have multiple images in multiple subfolders. The file structure looks like this: /Excel_file.xlsm /Images/Object1/Image1-1.jpg /Images/Object1/Image1-2.jpg [...] /Images/Object2/Image2-1.jpg /Images/Object2/Image2-2.jpg [...]...

Hi, I have a spreadsheet with 40k rows or so which is added onto every week. Each row has an Employee ID, Employee’s Shift Number and Hours worked column (see attached image for sample data). The problem is that I have the work out the Hours worked from a database to which I have an ODBC link...

Hello I am trying to modify a code that i got for importing into a excel file, this is the code that i currently have Sub Get_Data_From_File() Dim FileToOpen As Variant Dim OpenBook As Workbook Dim ws1 As Worksheet, ws2 As Worksheet Dim destLastRow As Long, sourceLastRow As...

I have a list of items in a spreadsheet which are maintained by a designated person to ensure they are current and applicable. I have created a pdf form which is pretty much empty apart from simple things like an email address, logo. I want a different designated person to open that form and...