Data type mismatch in criteria expression vbamunkák

Webhelyre van szükségem egy ügynökségnek

SAP-bol auto-exportalt xls adatfajlokhoz kellene vba makrokat szerkeszteni melyek szinten automatizaltan lennenek futtatva. Mintafajl mukodo makroval rendelkezesre all egy bizonyos celra mar, a metodustendszert kell duplikalni mas adatokra. Szoval nem nullarol kell kitlalnod az egeszet. Nem kell durvan erteni a makrok irasahoz. ha record funkcioval, es belenyulkalassal eligazodsz, az mar eleg lehet - en is igy irtam az eddigieket. ~Muveletek: fajlok nyitasa, mentese, zarasa, munkalapok valtasa, kepletezes, ezek lehuzasa, filter, adattipusok es stilus formazasa, vlookup xls fajlok kozott, chart frissites. Ennel sokkal bonyolultabb dolgokkal nem kell nagyon számolni. 4 fo elemunk van: 1, adatfajl letrehozasa es formazasa friss sap adatexport alapjan, kepletezes, osszegzes 2...

Adott egy FÉLKÉSZ Access DB-re ültetett Excel VBA ügyfél nyilvántartó, projektkövető rendszer. A cégünk mérőeszköz kereskedéssel foglalkozik, 10-15 beszállítóval, 2-300 partnerrel és 2-3000 ügyféllel dolgozunk. Professzionális Access és VBA tudással rendelkező szakit keresünk, Magyarországon.

Create an android background service which unlocks the phone if certain criteria are met. Read the attached file for more details.

Szia! Van szabad kapacitásod? Lenne egy sürgős munka, aminek lényege az, hogy egy meglévő VBA kódot kellene módosítani az elképzeléseimnek megfelelően. Kérlek jelezz vissza, ha érdekel és akkor mondom a részleteket! Üdv, Pisti

Hi! I have a pdf full of questions about 1.8k them or so. I need some to extract all these questions and put them in a file in the following format: #Melyik a legjobb rövid távú ütemezési algoritmus? (S) //<-question start with '#' and after the question text there is '(S)' implying it is a single answer type. Thsi is mandatory this is the only type in this pdf. //<- blank line A Round-Robin, hiszen egyszerűen implementálható és kicsi az overhead. //<-wrong asnwer 1 A feedback, ennek valamilyen verzióját nagyon sok mai rendszerben használják. //<-wrong asnwer 2 Prioritásos, hiszen figyelembe veszi az egyes feladatok fontoss&aacu...

1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálása. BMó...

...the search table. I do not have a specific design in mind, but I am looking for a clean and user-friendly design. Timeline: - This project is urgent and needs to be completed within 1-2 days. Table Concept - We looking for this type of idea : - Our Current table is this : - and this : Ideal skills and experience: - Experience with WordPress development and customization - Strong knowledge of search functionality and filtering options - Ability to create a visually appealing and responsive design for the search table Understanding: - Only Bid if you understand Project - Forward us a Sketch of what you can offer in order for Work to be considered - Many have offered

...facilitating precise property searches. This may involve filters based on price range, location, property type, and more. - **Property Listings:** It's important for the site to have a large database of property listings, including residential, commercial, and industrial properties. - **User Login and Registration:** Users should be able to register on the portal, create profiles, save their searches, and receive alerts for new listings. - **List View:** The property information should be displayed in a list view format. This should be clean, easy to navigate and provide all necessary details of each property. I'm looking for a freelancer with a proven track record in portal development, particularly in the real estate sector. The ideal candida...

...technology sector. - Content Type: You'll be crafting blog posts, which means a conversational and accessible style is preferred. - Target Audience: The primary audience for these pieces will be tech enthusiasts and the general public with an interest in this field. Ideal Candidate: - Prior Experience: A portfolio demonstrating your experience in writing technology-related content, particularly blog posts, is highly desirable. - SEO Understanding: Knowledge of SEO principles and practices to ensure the content is search engine optimized. - Engaging Writing Style: The ability to create content that is not only informative but also engaging, ensuring readers stay interested. - Understanding of Target Audience: A clear understanding of the general public&#...

More details: Is this project for business or personal use? For an existing business What type of article do you need? Feature story Which industry does the article relate to? Healthcare

More details: Is this project for business or personal use? For an existing business What is the main objective of your SEO campaign? Increase website traffic Which type of SEO do you need? On-page SEO, Off-page SEO, Technical SEO Target to achieve SERP position 1 for company's Keywords

I have a 5-second clip that I'm looking to enhance with sound effects. The main goal of this sound design is to intensify the impact of the...to intensify the impact of the clip. Key Requirements: - The sound effects I'm looking for are like explosions and laughter. These should be impactful and attention-grabbing. - The intended use of this clip is as a transition video. I'm specifically looking for a 'woosh' type sound to be incorporated. Ideal Skills: - Expertise in sound design, particularly for short clips - Ability to tailor sound effects for maximum impact - Strong experience in creating transition sounds Please provide examples of your previous work in sound design, especially for transition and short clips. Your bid should in...

I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks

...and other services - Information display in a grid view format - Dormitory Profiles: Information provided in these profiles should cover Location, Pricing, Availability, Facilities, Reviews, and Ratings. - Search Mechanism: Users should be able to search for dormitories by Location, Price Range, and Amenities. Ideal skills for this job include: The ideal candidate should have relevant experience with frontend and backend development, a solid understanding of React.js, Java, PostgreSQL and an eye for UI/UX designing. - Proficiency in web development, particularly in creating user-friendly interfaces. - Experience with database management and system design. - Ability to integrate a search mechanism that can filter dormitories based on the desired criteria...

I want native Punjabi translators for my project. Translators should be of native Punjabi background and should also be proficient in English. I need 100% human translation. No AI or Google translation is allowed. 2000 words per day is mandatory without any excuse and I can pay 0.20 paise per word. This is a long term project and you can join us for a long term opportunity. Note: - Payment period is after 50 days. Please apply only those who can fit these criteria. Responsibilties:- 1. Translators will translate 100% human. 2. All the translators will be responsible for grammatical mistakes. 3. All translations must have the same meaning as the English. If you are interested, Bid on this job.

** Urgent Need ** I need 1 Script Description Content every day each one will be short 100-200 Words. Video Will be provided. Content Topic/Type Example: The Content should be like this type of topic and 100% unique and related to the subject. All the content should be well-researched and have accurate information. The budget is $10 Per Content. Newbies are highly welcomed.

I'm looking for an experienced video editor to help with editing a video for a social media post on TikTok. Key Requirements: - **Editing Type:** The project involves basic video editing. This means trimming and rearranging clips, adding text overlays, and ensuring the video flows smoothly. - **Platform Specific:** Understanding of TikTok is crucial. The ideal candidate should be aware of trends, styles, and aspects that work well on this platform. - **Engagement:** The video should be engaging, visually appealing, and compelling to TikTok users. Ideal Skills: - Proficient in video editing software - Understanding of basic video editing principles - Creativity and attention to detail - Familiarity with TikTok and its trends - Ability to create engaging content for ...

...vehicles equipped with the technology described in the 【2. Desired Technology】 section below. ※Note Do not gather information based solely on the information listed in the 【1. Background】【3. Reference Information】 sections (【1】【3】 are for reference only) 【1. Background】 This technology pertains to a system for updating the programs of devices installed in vehicles. Many devices are installed in vehicles, and these devices store programs. It has been proposed that by updating these programs, the functionality of the devices can be improved. In particular, it has been proposed that by receiving data for program updates from an external server via wireless communication, it is possible to update the program without going to a service station or the...

I'm looking to improve my job search in the Information Technology industry. I need some help navigating the job market and identifying suitable opportunities. Key tasks and responsibilities include: - Suggesting relevant job search platforms and resources - Assisting with refining search criteria and keywords - Helping identify and approach potential employers The ideal candidate would have: - Prior experience in the Information Technology sector - Familiarity with current job market trends - Strong research and communication skills - Ability to provide practical job search advice

...analysis L/4 partial analysis Shear design Hook anchorage length analysis Content must be included. This must be presented, so please carefully write an explanation in English next to each expression. In other words, make it like Sample, but the structure I'm looking for is exactly what Sample 2 analyzes. However, my object of analysis here is a slightly different length of beam, so I need to write an expression to reflect the difference. 1. write an expression to reflect the difference in the length of the beams, using the sample as a guide 2. write an explanation in English next to each equation. (I need to explain this in front of many people, not just after I solve it, so please write an explanation or interpretation pr...

...analysis L/4 partial analysis Shear design Hook anchorage length analysis Content must be included. This must be presented, so please carefully write an explanation in English next to each expression. In other words, make it like Sample, but the structure I'm looking for is exactly what Sample 2 analyzes. However, my object of analysis here is a slightly different length of beam, so I need to write an expression to reflect the difference. 1. write an expression to reflect the difference in the length of the beams, using the sample as a guide 2. write an explanation in English next to each equation. (I need to explain this in front of many people, not just after I solve it, so please write an explanation or interpretation pr...

I'm in need of a typing test application that focuses on an average typing speed range of 40-60 words per minute. This application should present the user with paragraphs to type. Upon completion of the test, the application should display a comprehensive error tracking and review. Key Features: - Average typing speed assessment: The test should be designed to evaluate a user's typing speed within a specific range. - Paragraph-based typing: The test should present users with paragraphs to type, as this more closely simulates real-world typing scenarios. - Error Tracking and Review: After the test is completed, the application should provide detailed tracking of errors made during typing, enabling users to review and improve on their mistakes. Ideal Skills:...

I am in need of a skilled programmer to create a bot, effectively able to filter out vehicle listings and send them directly to me on whatsapp , twillio etc (any) Key Responsibilities: - The bot should primarily use Craigslist, OfferUp, and Facebook Marketplace platforms for sourcing listings. - The bot should filter vehicle category listings exclusively. Vehicle Filtering Criteria: - Vehicle make and model - Year range - Price range - Distance Ideal Skills: - Experience with bot programming and development - Familiarity with Craigslist, OfferUp, and Facebook Marketplace APIs - Understanding of the automobile market, specifically characteristics and identifiers - Proven track record of creating bots that can quickly and effectively filter search resul...

...modern and minimalist in design, and include standard ecommerce functionalities like product search and filtering, shopping cart, and user registration and login. Key Features: - Product search and filtering - User registration and login - Shopping cart and checkout - Spin & Win game, like - Easy login with Google sign-in Design: - type branding guidelines for the design - Open to suggestions from the designer - Aiming for a user-friendly design both on web and mobile views Payment Integration: - Cash on delivery - Razorpay Ideal Skills and Experience: - Proven experience in ecommerce website development - Familiarity with product search and filtering, user registration and login, shopping cart and checkout functionalities - Prior experience in...

...certification and hands-on experience, especially with split HVAC systems - Previous work in casual dining restaurants or similar settings - Knowledge of best practices and current equipment for restaurant HVAC systems - Easy and clear communication, professionalism, punctuality and attention to detail. The chosen professional will be responsible for providing all necessary equipment and tools for the project. Please include in your proposal details of your professional experience, your availability, and a brief description of your approach to this type of work. If possible, I would appreciate references or examples of prior work with HVAC installations for restaurants of similar size and type. I'm looking forward to finding the right professio...

I'm seeking a designer to draw a floor plan for my house. The purpose of this floor plan is to establish a visual guide for future interior design projects and determining furniture placement. - Design Criteria: * I'm ok with with using software apps to create this floor plan with a scanner then adjusting manually if needed to ensure basic accuracy *. Deliverable will be both print version and electronic version - Skills and Experience: * Proficiency in design software is a must.

I ...ACF Google Map in the user profile. The list of posts will appear on the users profile page which is set up in Each custom post already has a latitude and longitude as post meta using ACF. I just need help with extracting the latitude and longitude from the Google map in the user profile and sorting the posts according to distance from those coordinates. Ideal Skills and Experience: - Extensive experience with WordPress custom post types and custom fields. - Proficiency with Advanced Custom Fields (ACF) Google Map integration. - Prior experience implementing distance sorting on WordPress websites. This is an urgent project so I would require the task to be completed in a timely manner. If you have the skills and availability to get this done, pleas...

I am looking for a skillful graphic designer to generate a unique, combination type logo for my professional dog academy and grooming business. Key Requirements: - The design should incorporate both text and icons. - Demonstrable creativity is absolutely essential as I am open to suggestions. - The logo should resonate with the professional nature of my business. Ideal Skills & Experience: - Strong background in professional logo development - Excellent creativity and ability to suggest designs - A keen understanding of combining texts and icons to make striking logos. I look forward to viewing your remarkable portfolio pieces. Let's create a logo that truly represents the professionalism of my dog academy and grooming business.

I am in need of engaging and interactive PowerPoint presentations for my Grade 5 Math classes. Expectations: - Create PowerPoint decks that cover the 5th-grade math curriculum. - Implement nice interactive animations to make the presentations visually appealing. - The presentations should be lively, engaging, and suitable for an in-person classroom setting. Ideal Skills: - Proficiency in PowerPoint and creating engaging presentations. - Understanding of the Grade 5 Math curriculum. - Experience in educational or e-learning content creation is a plus. The goal of this project is to make the learning experience more interactive and enjoyable for my students. This is a long term bulk order, I will be paying $2 for 1 lesson of PowerPoint. If you are not ok with ...

I'm in need of a professional to help design an e-commerce website for my physical product business. KEY REQUIREMENTS: - **Product Type**: I'll be selling physical products. So, the site should be optimized for showcasing and selling items. - **User Reviews & Ratings**: I want the site to have a feature for user reviews and ratings. This is crucial for boosting credibility and attracting more customers. - **Inventory Management**: I prefer the system to automatically update inventory based on sales. I want a seamless experience for my customers, with accurate information on product availability. & user-friendly login, checkout page Already i have - hosting, domain, Brand logo, Elementary Pro , razor pay payment gateway Ideal applicants for this job sh...

I'm in need of an experienced API developer(s) to assist with integrating our platform with multiple external systems in USA. Plaid API aggregates with multiple finance systems (banks mainly) and their investment aggregation didn't work for me. Since Plaid API didn't work for me I am thinking we will have our own APIs to integrate to any investment banks/ brokers like E*Trade, TD Ameritrade (now part of Schwab(, Vanguard, Fidelity, Robinhood and many more. See Following APIs are needed at high level: - Minimum 1) Get Holdings/ Positions (stocks, bonds, mutual funds, options, ETFs, etc.). We will pass institute name, account # or login/password, 2) Get Transactions (Dividend Paid, Bough, Interest Charged

We are looking for experienced 2D artists to participate in a creative design contest aimed at developing a background slider _2200px by 600px). This slider will be a central feature for a website or catalog that showcases a unique and whimsical collection of common and exotic household pets, all depicted in an extraordinary setting—outer space. Design Requirements: Theme: Each animal should be illustrated as a 2D-cartoon character in space, equipped with astronaut gear such as helmets or suits, appropriate for a space environment. Animals to Include: Common pets: Cats, dogs, bunnies, and parrots. Larger animals: Horses, zebras, lions, and wolves. Sea animals: Orcas, octopuses, and dolphins. Art Style: The characters should be vibrant and appealing, with a playf...

...multi-modal sentiment analysis and emotion recognition system. This system aims to analyze and understand human emotions expressed through various modalities, including text, images, and audio. The primary objectives of this urgent project include: 1. Multi-Modal Data Integration: Develop algorithms to effectively fuse information from text, images, and audio sources to capture the holistic context of emotional expression. 2. Text Analysis: Implement state-of-the-art NLP techniques to extract sentiment and emotion from textual data. This involves sentiment polarity detection, emotion classification, and fine-grained sentiment analysis. 3. Image Analysis: Utilize deep learning architectures such as convolutional neural networks (CNNs) to extract features from ima...

DCMS Create Growth Programme Competition 3 We are an Aerial Arts Studio in Devon, UK and seeking someone to write an application for DCMS Create Growth Programme Competition 3 I'm seeking a skilled and experienced grant writer with a successful background in securing government grants. The project is in the sector of growth, aiming specifically at increasing our company's revenue. The ideal candidate will have: - A proven record in writing successful grant proposals, preferably within the growth sector. - Detailed understanding of government grant structure and application process. - Strong research skills to ensure our proposal aligns with grant criteria. - Demonstrated ability to translate our business goals into effective grant proposal...

I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all su...

Please only bid if you have experience in song generation using AI. Your expertise will contribute to a cutting-edge project that combines music generation with voice cloning to create songs sing by virtual persons. We want our app to have the following features. - Create unique music based on user input information (speed, type, length...). - Create music based on the voice provided by the user - Change the voice of music provided by the user to the voice provided by the user Frontend is already done. The model we want must be able to perform two large functions. 1. Generate a song based on the text entered by the user using the sample voice selected by the user. 2. Converts the voice of the song uploaded by the user to the voice selected by the

I'm in need of an eye-catching and vibrant logo that will be the focal point on my new men's sweatshirt line. Key requirements: - The logo must primarily be designed to fit on the product itself. - It should be colorful and vibrant, to attract the attention of potential customers and stand out against the background of the sweatshirt. - Ideally, the design should be trendy and appealing to the target market, which is young adults aged 18-30. I'd be thrilled to see your portfolio of similar past work, so please share that when you apply. Your experience with logo design and your ability to create something that fits the criteria will be key in my decision-making process.

I'm in need of a professional writer with a deep understanding of the freelancing industry. Your task will be to craft highly engaging and insightful educational articles for a weekly newsletter I'm launching. Key Points: - **Target Audience**: My newsletter is exclusively aimed at freelancers. The content should be tailored to their needs, challenges, and aspirations in the freelancing world. - **Content Type**: I'm looking for educational articles. These could cover topics like freelance productivity, time management, client relationship building, skill enhancement, and so forth. - **Frequency**: You'll be required to produce this content on a weekly basis. Ideally, you should have: - **Proven Experience**: To be considered, you should have a ...

...for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensu...

I need a freelancer for a copy-paste task without specific details. I have a few files that need to be copied and pasted. While I haven't specified the type of files, the volume is manageable. Ideal skills for this task include attention to detail, efficient in data entry, and ability to follow instructions carefully.

...TEMPORAY SKETCH LAYOUT WITH A SAMPLE WITH BE APPRICATED TO HELP US IN MAKING A DECISON WHO TO AWARD THE PROJECT TO. *** Functionality: - Advanced filtering: The table should allow users to filter data based on multiple columns. - Custom filtering: Users should be able to specify criteria for filtering. Responsiveness: - The Bootstrap table should be responsive, ensuring optimal user experience across different devices and screen sizes. Columns: - The table will have 4-7 columns, which should be properly displayed and organized. Ideal Skills and Experience: - Proficiency in Bootstrap: The developer should have a strong understanding of Bootstrap and its components to create a responsive table. - Front-end development: Experience in front-end develo...

I'm in need of a skilled video editor with a strong understanding of YouTube content. Here's what I need for my project: - Expertise in editing YouTube videos: Your role is primarily to edit and refine my raw footage into polished and captivating YouTube content. The type of my content is unspecified, therefore, versatility is essential. Ideal Skills: - Proven experience in video editing specifically for YouTube. - Proficient in video editing software such as Final Cut Pro, Adobe Premier Pro, etc. - Versatility in editing styles as the style for my videos hasn't been determined yet. - Understanding of YouTube content featuring a variety of video formats and themes. Since I haven't provided information about the average lengt...

I'm in need of a 3D model, but I didn't specify the type, its intended use, or its level of detail. Would you like me to help you specify these details, or do you have a specific model in mind?

...crafting logos. I don’t have a specific type of logo in mind, be it a wordmark, symbol/icon, or combination mark; I am open to all those possibilities. Feel free to surprise me with your creative instincts. Planners First™ ( add trademark) The color scheme for the logo isn't a limitation; I'd like to see what colors you think best reflect the ethos of my brand. The logo should encompass 3 important principles: - Professionalism: The design should be sleek and refined. - Creativity: Put on your creative hat to achieve a unique, standout design. - Simplicity: The logo should be easy to perceive and understand. Ideal Skills: • Excellent graphic design skills • Knowledge of latest logo design trends • Creativity and innovative thinki...

Job Position: Residential Property Cold Caller and Appointment Setter Location: Remote Job Type: Full-time Responsibilities: - Identify and contact potential leads through cold calling. - Collect detailed information about residential properties. - Evaluate and finalize profitable real estate deals. Requirements: - Proven experience in cold calling with a focus on real estate acquisitions in the residential sector. - Excellent proficiency in English with strong communication skills. - Robust negotiation abilities. - In-depth knowledge of the residential real estate market. Qualifications: - Experience in real estate acquisitions and sales. - Ability to work independently and in a fast-paced environment. - Professional demeanor with e...

Require a skilled professional in computer vision. I have public videos from YouTube which you can use to follow the project. In these videos, children are playing games. We need the following features to find the severity/confidence scores (0-9, where 0 is non-Autism and 1-9 represents increasing severity) by using any technique or model (pre-trained / ML / DL) so that we can find the individuals with autism levels (such as severe autism, mild, medium, lower, or no autism, etc). For example, maybe you can see Face landmark detection () that has a confidence score. I expect you will find a better technique. By applying the following feature techniques: facial expression analysis, gaze analysis, body movement analysis

... I am currently working with a client who has an old website built in ColdFusion. The website is going to be moved over to WordPress to give the client more flexibility updating etc. One of the challenges I have is that I need to migrate over about 400 photo galleries from ColdFusion into a WordPress Custom Post Type. Here is the current Structure: Primary Gallery Name - Sub Category (Year) - Gallery (with all the gallery images) Now there are 18 primary galleries, then under each primary gallery there are approximately 19 subcategories (the years), then within the subcategory is the gallery itself. I am looking for someone who can scrape the content from the existing website, and structure it exactly the same way in WordPress using ACF (Advanced Custom Fields...

I'm looking for a talented clothing designer to assist with creating designs for both men and women Key project details: - Clothing Type: The focus is on creating stylish, comfortable clothing. - Design Style: The designs should be in solid colors, Images, creating a sleek, minimalist aesthetic. Skills & Experience: - Experience in fashion, particularly casual wear. - Strong understanding of colour theory. - Ability to work based on a brief and deliver creative, unique designs. Creativity and a keen eye for detail are crucial in this job setting. Please provide a portfolio or examples of prior work in the men's casual wear space.