Programmieren mit vba 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.
Merhaba ben arduino wifi modüllerini kullanarak çeşitli projeler dişinda mit appinvertor ile kendi apk uygulamami yapıp arduini kartları ile uzaktan kontrol yapabiliyorum.
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
Sehr geehrte Dear Wir suchen jemanden der uns gleiche Handwerkerportal Türkisch mit türkische sprache erstellen kann die bei spiele sind es soll alles gleich sein sowie auch zahlungssystem es soll alle PLZ und Orten Türkei beihalten ist eine große projekt aber wir sind bereit Ordentlich bezahlen und in zukunft immer zusammen arbeiten
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.
MIT App Inventor ile yazılmış çalışır Android uygulamasının Eclipse platformuna taşınması. Teklifleriniz beklerim. İyi günler.
BMCLLC - Vermittlung von Finanzkontakten Hallo Freelancer, ich bin Hans G. Kessel, Manager der budget management & consulting LLC mit Sitz in USA; wir leben seit 10 Jahren in Paraguay. Unser Geschäft betreiben wir seit 38 Jahren. (Finanzdienstleistungen, AGENTUR für Kontaktvermittlung); Da wir diesbezüglich die eigentliche Kreditvermittlung NICHT durchführen, sondern ausschließlich beraten und an durchführende Kontakte vermitteln im Sinne einer ONLINE-AGENTUR, benötigen wir keinerlei Gewerbeerlaubnis oder ähnliches. Komplette Abwicklung läuft ONLINE - keine Hausbesuche oder ähnliches. Am besten ebook mal lesen. Wir wollen MEHR Kunden, die nach Finanzierungsmöglichkeiten suchen, sei es auf Grund von bisherigen Ablehnunge...
BMCLLC - Vermittlung von Finanzkontakten Hallo Freelancer, ich bin Hans G. Kessel, Manager der budget management & consulting LLC mit Sitz in USA; wir leben seit 10 Jahren in Paraguay. Unser Geschäft betreiben wir seit 38 Jahren. (Finanzdienstleistungen, AGENTUR für Kontaktvermittlung); Da wir diesbezüglich die eigentliche Kreditvermittlung NICHT durchführen, sondern ausschließlich beraten und an durchführende Kontakte vermitteln im Sinne einer ONLINE-AGENTUR, benötigen wir keinerlei Gewerbeerlaubnis oder ähnliches. Komplette Abwicklung läuft ONLINE - keine Hausbesuche oder ähnliches. Am besten ebook mal lesen. Wir wollen MEHR Kunden, die nach Finanzierungsmöglichkeiten suchen, sei es auf Grund von bisherigen Ableh...
...talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Featu...
Layout für die Website ist vorhanden in Figma. Es sind 5 Seiten (Startseite, Veranstaltungen, Kulturhaus, Verein, Kontakt + Datenschutz und Impressum) Auf der Kontaktseite ist ein Formular und es sollte unter dem Formular eine Map mit Standort von Google eingeblendet sein. Die Website sollte mit Wordpress und Elementor erstellt werden.
...development stack. Basically we need functionality such as shopping cart management, order modifications, returns and exchanges, product information, FAQs, store policies, discounts, and upselling/cross-selling capabilities. Probably most or all is in some github repository, which we are fine with using as well as GPT-4, which, if you don't have an account, we'll get you one. It is important to only use MIT or similarly licensed code such that it is legal to use the code or derivations in a commercial software. Freelancers should mention which development stack they would use. There are lots of Shopify repositories here: along with lots of code on the web. Ideally much of the functionality would come from already existing code, but GPT can also be used to rapidly
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
2 excel files with VBA macro as per customer requirement
One excel file with macro as per the customer requirement
...Marketing für ein breites Publikum, d. H. Die allgemeine Bevölkerung. Deutsch -sprechende Freiberufler gewünscht Ihr Verständnis unserer einzigartigen Position und Fähigkeit zur Bereitstellung von Strategien für hochmoderne ist begrüßt. Unser Ziel ist es, unsere Reichweite und unseren Kundenstamm mithilfe der neuesten digitalen Taktiken erheblich zu erhöhen, und wir erwarten, unseren Erfolg mit Ihrer Hilfe zu steigern. --- As a long-standing consultancy and matchmaking agency focusing on financial services, we are keen to reach more clients. To achieve this, we are seeking digital marketing experts to provide effective advertising strategies, particularly via TikTok and YouTube. Key Responsibilities: • Formulate ...
Wir wollen einen neuen Onlineshop bauen, der mit unserem JTL Wawi verbunden wird. Wir haben unter anderem spezielle Anforderungen, wie zB. Zwei Kundengruppen anlegen, die jeweils andere Preise sehen, also B2b und B2C. Unsere Produkte sind Schmuck mit mitunter vielen Varianten, welche auch in den Varianten ein Crossselling haben sollten. Vielen Dank
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-f...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...
Description: Erfassen, analysieren und priorisieren von Anforderungen in agiler Umgebung mit verschiedenen Stakeholdern Quartalsplanung erstellen und ausgewählte Features im Agile Release Train integrieren Gestalten von Geschäftsprozessen für Organisationsverwaltung mit Fachbereichen wie Administration, Lehre und Forschung Planung und Koordination der Einführung neuer Features sowie Kommunikation zwischen den Teams und betroffenen Parteien Requirements: Du verfügst über eine abgeschlossene Ausbildung als Informatiker oder ähnliches, Master-Abschluss wird bevorzugt Hochschulabschluss in Informatik oder einem verwandten Fachgebiet mit umfangreicher praktischer Erfahrung Zertifizierung als Product Owner und mehrjährige Tätigke...
I am looking for a Flutter developer to create a comprehensive PDF package (not APP). - The package should include functionality for: 1.)...the package. Example flutter package (for reference only): Payments will be done in phases after completion of each feature and it's related documentation. I do not want any server hosting for this package. What I mean is that I want on device capabilities for the features. Also if any code is used from anywhere, make sure that it comes under apache or mit license. I have provided a reference package. I would want the freelancer to use the exact api call as in the reference package, so that I can integrate with my existing flutter app without any issues. Just the underlying algorithms and logic need to change.
Für unseren geschätzten Kunden in Zürich sind wir auf der Suche nach einem erfahrenen SAP-Spezialisten, der sich auf dem Gebiet von SAP FS-CD auszeichnet. Was dich erwartet: • Konzeption und Umsetzung von Tests fü...erwartet: • Konzeption und Umsetzung von Tests für das SAP FS-CD Modul • Unterstützung des Teams bei Analyse und Design • Aktive Begleitung des laufenden Betriebs und Hilfeleistung im agilen Team bei auftretenden Ausfällen Was wir erwarten: • Erfolgreich abgeschlossenes Informatikstudium oder eine äquivalente Ausbildung • Mehr als 5 Jahre Erfahrung im Bereich SAP FS-CD • Versiert im Umgang mit ABAP OO (NW 7.5) • Zusätzliche Kenntnisse in anderen SAP-Bereichen, wie z.B. S4/...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
As the client for this project, I urgently require an expert in VBA.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Dat...based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially within Exce...
...Freiberufler, der sich mit 3D-Modellierung auskennt, um ein bestehendes einfaches 3D-Produkt so zu erstellen, dass es kompatibel ist bzw. mit dem Fancy Product Designer-Plugin für WooCommerce funktioniert. Der Schwerpunkt liegt auf der Anpassung des Modells für die Verwendung mit diesem speziellen Plugin. **Anforderungen:** - Konvertieren Sie eine vorhandene FBX-Datei in ein vollständig kompatibles Format mit Fancy Product Designer, einschließlich der erforderlichen Konfigurationen. - Fügen Sie endgültige Ergebnisse wie Screenshots und eine Umgebungs-HDR-Datei hinzu. - Stellen Sie sicher, dass das Modell für eine genaue Online-Darstellung korrekt auf seine realen großen Abmessungen **Ideale Fähigkeiten:** -...
I need a freelancer to assist me in connecting my MIT App Inventor to my HiveMQ broker. The main goal of this project is for me to gain knowledge and understanding about IoT connectivity. I have the arduino code working succssfuly when I enter the topic and the message manullay in HiveMQ broker. Now I like to use MIT App inventor to connect to broker and passes the topic & messages Key requirements: - Connection of MIT App Inventor to HiveMQ broker - Ability to switch ESP32 LED on/off Ideal Skills: - Proficiency in IoT connectivity - Experience with MIT App Inventor and HiveMQ - Strong understanding of ESP32 and MQTT protocol
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
