Vba activex işler

...numaralı kısımda bahsettiğim web servis aynı zamanda bir takım sorgulama ve raporlama imkanları verir (bir tür APİ). Bu web servis yapısı ve dokümanları var, çok karmaşık değil. Ben google spreadsheet ve excelde vba üzerinden rahatça çalışabiliyorum bunlarla. Bizim ihtiyacımız burada basit bazı tablolamaları belirli aralıklarla AİP'ler ile sorguladığımızda görebilmek. Ardından buradaki veriler ile canlı gelen verileri karşılaştırarak ve oradan çıkan sonuçlara göre yeni web servisler çalıştırmak. Not: Bütçe sembolik yazıldı, lütfen abartmadan (uzaya araç göndermeyecek, ben bunların hepsini VBA ile yapıyorum ama excel şişiyor ondan kurtulmaya çalışıyorum) kendi fiyat ...

Sütunları 2, 3, 4lü ... gruplandırıp grup benzerlik oranlarını hesaplayan VBA istiyorum. Aslında böyle bir VBA daha önce hazırlatmıştım, ama bu VBA belli sütun sayısından fazlasını yapamadı. Belki bu dosyada değişiklik yaparak da işimi görebilirsiniz. Ben 300 sütuna kadar karşılaştırma yapmayı istiyorum.

Hisse senedi, emtia ve yatırım fonu alım satımlarım için grafikler ile kar zararı gösterebilecek güncel fiyat bilgilerini internet üzerinden 15 saniye de bir çekip güncelleye bilecek excel tablosu istiyorum.

Excelde çeşitli ebatlarda olabilen bir tablonun hücrelerinde bulunan değerlere göre bir çarpanla çarparak satır ve sütünları değere göre sıralayacak. Rank order clustering isimli bir matematiksel bir çözüm yöntemi.

Excel VBA kodları olan bir excel türünde bazı sayfa ve hücreler şifreli durumda. Bu şifrenin kaldırılmasına ihtiyacım var.

Merhabalar, Temel olarak, adı Matriks (MTX) olan bir masa üstü uygulamadan DDE veriler alabiliyorum. Bu sayede ilgili verileri excel’e çekebiliyorum ve aslında bundan sonra anlatacağım her şeyi VBA üzerinden yapabiliyorum ama excel'in sınırlamaları nedeniyle, eğer yapabilirsem excel'i aradan çıkartan bir uygulama yaz(dır)maya çalışıyorum. Yapmak istediğim şey kısaca; 1. MTX'in DDE verilerini al (excel olmadan doğrudan MTX'ten tercih edilir. Excel’e ben DDE linkle veri alıyorum, sonra da excel dosyasını python ile okuyabiliyorum ve CSV’ye yazabiliyorum, ama bu istediğim şey değil). Biliyorum DDE eski bir veri noktasıdır, ancak MTX'ten veri almanın başka bir yolu -yani TCPI veya başka bir yöntem- ol...

Mevcut bir excel dosyasında adlı siteden veri çekiyordum. Ancak 1 haftadır siteden veri çekemiyorum. Excel dosyasında module kısmı düzenlenerek dosyaya yeniden veri çekme işlemi gerçekleştirilecektir.

Yeni bir parakende mağaza açılışında giderleri tahmin etme ve kar zarar analizi yaparak mağaza açılıma uygundur veya değildir tarzında bir rapor sunacak excel istiyorum.

google excel sheet üzerinden birden fazla firmadan teklif alarak fakat verilen teklifler birbirinden gizli olacak şekilde açık arttırma ihalesi gibi bir makro excel oluşturmak istiyorum.

BENİM BELİRLEDİĞİM HÜCREYE GÖRE OTOMATİK FİLTRELEME YAPACAK EXCEL VBA YAZILMASINI İSTİYORUM

Makale üzerinden modelleme yapılarak vba programı ile ülke ligi ile ilgili program yapılacak

VBA'de egzotik opsiyon fiyatlandırılma kodu yapılacak. Monte Carlo simulasyonu kullanılacak. Detayları ilgililerle paylaşıcam.

Embedded Linux işletim sistemi gömülü olan falat root olarak erişe bildigimiz DVR kayıt cihazından mevcut web tabanlı izleme editörünün(Activex) yerine html5 video oynatma standartları ile izleme yapabilecegimiz ekbir activex kurulumu gerektirmeyen uygulama geliştirilmesini talep etmekteyim. Not: Uygulama ile ilgilenen arkadaşlara erişim için dvr cihazının ip adresi ve kullanıcı bilgileri verilecektir.

I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.

I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data

I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compensated on a daily basis, with payment based on the number...

I am looking for a VBA expert who can develop a solution for generating detailed reports from Excel files for my business case. The primary objective of this project is to automate the report generation process, making it more efficient and less time-consuming.

I need an experienced Excel VBA programmer to modify my VBA Code macros. The job involves enhancing an Excel form and including a 'modify' function. Modify "Agency" file to be like "Testttt" file and include the Modify button. Key requirements: - Modify an existing Excel form - Include a 'modify' function in the form - Improve the overall performance of the form The ideal freelancer would have: - Extensive experience in Excel and VBA - Ability to optimize data modification processes - Skills in designing user-friendly forms The project also involves changing some aspects of the form's appearance: - Removing some fields from the form - Changing the layout of the form The successful freelancer will be able to deliver a w...

I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points f. Co...

...all extracted data is neatly organized and formatted for easy access within Excel. Provide clear, user-friendly functionality to paste or upload listings and automatically trigger the data extraction process. Skills Required: Strong experience with web scraping or API integration to pull data from Zillow, Redfin, StreetEasy, and other platforms. Proficiency in Excel automation, preferably with VBA or Python (pandas, openpyxl) to integrate the data extraction functionality. Familiarity with Zola NYC and NYC Open Portal to access zoning and building-related data. Knowledge of real estate terminologies and zoning regulations in NYC. Experience with data validation to ensure accurate and reliable data extraction. Ability to work autonomously and deliver high-quality, maintainable co...

Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.

I'm seeking an Excel expert who can help me code a MACROS to automate a process in Excel. The task involves analyzing employee data and generating results related to loans and other similar dat...process in Excel. The task involves analyzing employee data and generating results related to loans and other similar data entries. Key Responsibilities: - Develop a MACROS script to automate data analysis on employee data. - The macro should be able to provide results for specific data entries related to loans and other similar metrics. Ideal Skills and Experience: - Proficient in Excel and VBA programming. - Prior experience in developing Excel MACROS for data analysis. - Understanding of employee data metrics. - Able to deliver efficient and effective solutions for data processin...

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

Bonjour, nous avons deux fichiers Excel comprenant deux colonnes comportant des codes postaux français : colonne C "CP départ" et colonne D "CP arrivée". Nous avons besoin que dans la 3e colonne "Distance en KM" vous trouviez via google ou par VBA Excel la distance en KM entre ces deux codes postaux. Exemple ligne 2 du fichier "Tri 2024" : CP départ 54710, CP arrivé : 28500, distance en km : 408 km

Description: I am looking for a skilled developer to help deploy an existing solution that automates Word document text replacement using VBA and outputs a PDF file. I already have a fully functional VBA code and an HTML interface to generate the code. The project involves using this existing logic and expanding it to work seamlessly on a server-based environment. Key Requirements: PDF Output: The system should take user inputs through the existing interface (or an upgraded version) and automatically replace the specified keywords in a Word document. Once the replacement is complete, the system should generate and provide the user with a downloadable PDF file. Database Integration: Create a database to store keywords used for replacement. Provide an option to select prev...

I'm seeking an Excel expert who can help me with a project needing to build a client pipeline excel sheet which provides the ability to multi select checkboxes from a drop down for certain columns. Also need to have the checkboxes grouped under a heading with indentation/ categorization The project requires the development of advanced macros and VBA scripts. Ideal Skills: - Extensive knowledge of Excel - Proficient in writing complex VBA scripts - Experience in creating advanced macros Key Responsibilities: - Develop an excel sheet with certain columns having the ability to list checkboxes and support multi selection. - this drop down multiselect checkbox list also will be categorized under a few main parent checkbox - upon multi selection and pressing ok, the values ...

I'm looking for a skilled Excel VBA expert to create a macro that converts data from my Excel file into PDFs and sends them to multiple email addresses. The Excel sheet has several tabs, each corresponding to a different group of recipients. Key requirements: - The macro should be able to handle 4 or more separate groups of recipients, as per the different tabs in the Excel file. - Email addresses are provided in a comma-separated list format. - Each tab contains sales reports that need to be converted into PDFs. Ideal candidates should have: - Extensive experience with Excel VBA and macro programming. - Previous work with automating PDF conversion and email sending from Excel. - A strong understanding of handling and sorting data for different groups. Please note, th...

Create a Word document linked to populated Access tables. The project involves inserting data via bookmarks & VBA into a Word Template document that outputs a new Word report. This output report should have no bookmarks or VBA while maintaining the required table and text formatting & styles.

I am a project manager handling diverse projects and need a professional Excel dashboard to track and manage my work efficiently. The dashboard should provide a clear, user-friendly interface and visual insights to monitor progress, timelines, budgets, and key metrics for the following: CSR Fund Tracking: Monitor inflows, outflows, and utilization of CSR...components like charts, graphs, and summary tables for easy tracking of progress, KPIs, and pending tasks. User-friendly interface to import/export data and make updates seamlessly. Sections for tracking timelines, budgets, and overall project status. Deliverables: A fully functional, customizable Excel dashboard with instructions. Source file in Excel format. Freelancers with expertise in Excel, VBA, and data visualization are ...

...semplificare e velocizzare il processo di inserimento ordini riducendo gli errori manuali. Requisiti chiave: - Esperienza con SAP SuccessFactors e integrazione con Microsoft Outlook. - Capacità di creare macro o strumenti di automazione personalizzati. - Comprensione di come leggere e processare dati da file PDF. - Forti competenze in programmazione, preferibilmente con conoscenze di linguaggi come VBA, Python o simili. - Buona comunicazione e attenzione al dettaglio per garantire che il tool sviluppato rispetti le specifiche richieste. Responsabilità: - Analizzare i requisiti e proporre la migliore soluzione per l'automazione. - Sviluppare e testare la macro o il tool per assicurarsi che funzioni senza intoppi e in modo affidabile. - Fornire documentazione e...

I require an experienced VBA programmer to write a script for my Office 365 Excel workbook. The task is to automate the printing process of a specific worksheet based on a cell value in the 'Component Index' worksheet. Key Requirements: - The 'Component Index' worksheet contains the cell value that determines the number of pages to print. - The script should allow for changing the name of the workbook without interrupting the print process. - The automation should seamlessly integrate with Excel's regular print button. The ideal candidate for this project should be proficient in VBA programming and have extensive experience with Excel 2019 and Office 365. Knowledge of Excel's print processes and handling of workbook events is crucial. Please ...

I need a skilled VBA programmer to help me add a macro to my existing Excel file. The macro needs to automate some of my repetitive tasks, specifically: - Data entry: I want to streamline the process of inputting data into the spreadsheet to save time and reduce errors. - Data analysis: I need assistance with automating some basic analysis to derive insights from the data. The data for these tasks will primarily come from user input within Excel. Ideal skills and experience for this job include: - Proficient in VBA programming with a strong portfolio of Excel automation projects. - Excellent understanding of data manipulation and analysis within Excel. - Ability to work with user-generated input and create a seamless automation experience. I'm looking for someone ...

I need a VBA script in Excel that will help me to import data into Word. The main purpose of this script will be to merge data from Excel into a Word document. Key Features: - The Word template will include text data, tables and spreadsheets, as well as charts and graphs. - The imported data will need to be formatted with custom styles, not just standard formatting. Ideal Skills and Experience: - Proficient in VBA programming. - Strong understanding of Excel and Word integration. - Experience with creating custom styles in Word. - Able to work with diverse types of data.

Looking for a freelancer experienced in Excel and VBA to develop a tool that automates the creation of Sorare teams based on data from three sheets: "Sorare Bot," "Classifications," and "GW." The tool should: Generate valid 5-player teams for competitions following specific rules (positions, exclusions, etc.). Organize teams into blocks categorized by competition. Create a list of unused players with exclusion reasons. Include a button to update the "GW" sheet whenever the other sheets are modified. Skills Required: Advanced Excel and VBA expertise. Data processing and automation. Attention to detail for applying prioritization and exclusion rules.

I'm seeking an expert excel/vba programmer. I'm using an existing vba macro excel program that needs to be upgraded. It was created to automate the process of building a single inventory list from multiple vendors feeds. The website is now using the Shopify platform and requires data to be imported into different column names and for more columns added. Summary of work required: 1. Need to change the import process to a single form, where feed can be added, vendor profile selected, map file column names to names in the program, save profile and import feed. 2. Adjust Export functionality to use similar template with different columns for different export options. 3. Data in compiled list needs to be read only unless enabled for in-line editing 4. Need a butt...

- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us

An excel file that will import images from a folder. According to a specified layout, and having a filter and sorting feature.

I need a talented individual to create a system for my Excel workbook that intelligently transfers mixed data (text and numbers) from one sheet to another. The data transfer should occur daily, triggered by updates to the data. Key Requirements: - Proficient in Excel with extensive experience in creating complex formulas and logic. - Familiarity with VBA or similar programming languages for automating tasks in Excel. - Ability to understand and manipulate mixed data types. - Experience with setting up systems for daily data tracking and transfer. Ideal skills include attention to detail, problem-solving abilities, and a strong understanding of data management. Please apply if you can help me streamline my data management process.

I need help with capturing data from a website. The data is displayed in a table format below a chart for a particular facility. I want to capture monthly data for all time periods for all facilities on the website. Key Details: - The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of use. Ideal skills for this project include: - Proficiency in Excel, particularly with creating and using macros. - Experience with data extraction from websites. - Attention to detail to ensure all data is accurately captured. Budget is $50

Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validation rules. Excel Reports: Gen...

Hello. It's supposed to generate teams based on data from multiple sheets, but it doesn't work like I need. When I run the script it gives me an error and I can't solve it, can you help me?

I'm seeking a VBA macro expert who can help optimize my code for faster execution. The macro is currently used for generating reports from data stored in Excel sheets. The main goal is to reduce the runtime of the macro to improve efficiency. Ideal Skills and Experience: - Proficiency in VBA programming - Experience with Excel-based data manipulation - Skills in code optimization and performance improvement - Ability to enhance code readability for future use Freelancers who can deliver a fast, efficient solution will be prioritized.

I'm seeking assistance with specific small tasks in Excel that may require the use of VBA coding and formulas. Key Requirements: - Creating macros to streamline processes - Using the macros for data validation and cleanup Ideal Skills: - Proficient in Excel with extensive knowledge of VBA - Experience in creating macros - Capable of performing data validation and cleanup tasks

I need assistance with my Excel VBA and Python integration. I can open a Colab Notebook from VBA, but I'm having trouble getting the code to execute automatically upon opening the Notebook. VBA-code: Sub StartColabScript() Dim colabLink As String colabLink = "" colabLink End Sub I cant get this code to run my Python-script. I also tried: # Add code to Colab Notebook !python /path/to/ !python (I dont know if the Notebook is called the right way. The name of my workbook is: Ny241028Hent33Tickers3Blokke5y I guess its .py How do I refer to this workbook from VBA, and how do I get to autoexecute

Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validation rules. Excel Reports: Gen...

Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!

I'm in need of a professional who specializes in Excel VBA and Outlook email automation. I have made some experimental progress but I am currently stuck and would appreciate assistance in troubleshooting my existing code and learning basic coding concepts. The specific tasks required include: - Automating email generation from specified Excel worksheet cells on a schedule based on corresponding dates in other cells. - Incorporating specific types of content into the body of these emails, including text and hyperlinks. - Assisting me in understanding and learning basic coding concepts. Ideally, you would have extensive experience with Excel VBA and Outlook, and be able to explain concepts in a clear and understandable manner. Your role will not only be to help me progre...

I'm experiencing an issue with a combobox in my MS Access database. It's directly bound t...experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am no...

Excel VBA Macro Debugging - Compiler Error Fix I'm encountering a compiler error while running a macro in Excel VBA. The macro is primarily designed for data manipulation and includes various functions. I need assistance to diagnose and fix this issue so the code can run without errors. Ideal Candidate: • Extensive experience with Excel VBA and macros. • Strong troubleshooting skills to resolve compiler errors. • Proficiency in data manipulation using macros. • Ability to maintain existing code functionality while fixing errors. Important Instructions (Read Carefully): 1. To Be Considered: You must resolve the error and provide the complete, functional code. I will test the code, and payment will only be made if it works as expected. 2. No...