Vba extract data website työt

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

...adapt an existing web crawler code to include specific features I require. This includes the ability to extract and filter data from multiple websites. - **Data Management:** I expect the total scale of the data to be relatively small, so the freelancer should have experience handling data sets of this size. - **Data Analysis:** After the information is extracted, I intend to use it primarily for data analysis. The freelancer should have a good understanding of how to structure data for this purpose. Ideal Skills & Experience: - Proven experience in customizing web crawlers and managing data. - Proficient in data analysis and structuring for insights. - Familiarity with handling small scale data sets. - St...

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm in need of an experienced developer to help with fetching and displaying user transaction details from WordPress to a React front-end in a headless WordPress project. Key tasks include: - Fetching user credit and debit details from WordPress: This data should be gathered and displayed in a user-friendly interface on our React front-end. As mentioned, we're looking to do this as soon as possible. The ideal candidate should have: - Strong experience in WordPress: knowledge of how to extract specific user data. - Proficient in React: able to work on a headless WordPress setup. - Good communication skills: as this project needs to be completed quickly. Please get in touch if you have the required experience and availability.

I want someone who can help me To extract leads

I am seeking a skilled data miner to initially extract at least 1,000 company names, telephone numbers, and emails of translation agencies in the United States. We will provide the names of the cities, and the data miner will be responsible for searching local translation agencies on Google that meet these requirements. The database is to be created on a Google Spreadsheet. Based on this information, please tell us how many entries you can complete per hour and your best rate per hour.

Task at hand is to extract vocals from a highly distorted audio file OF APPROXIMATELY 8 MINUTES. I DO HAVE OTHER FILES I WOULD LIKE DONE AS WELL, IF EXTRACTION IS SUCCESSFUL. As a client, my ultimate target is related to: - Enhancing intelligibility within the dialogue to bring utmost clarity. - Identifying specific words or phrases that may prove crucial. - The file is from a criminal setup with the audio of a father setting up his son; thus every word could change the narrative. The audio clip has been intentionally distorted over crucial conversation. Do whatever it takes to make the conversation extremely clear irrespective of the overall audio quality. Those offering skills and experience in forensic audio analysis, audio software engineering will ideally match the job req...

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro...the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

I'm in need of a skilled Delphi developer who can quickly generate a program that can dive into the registry of a Windows machine and extract the names of all programs listed in the "Add/Remove Programs" section. Key Requirements: - The code should be written in Delphi. - It should effectively scan the registry. - Extracted program names should be displayed in a listbox. This is a simple task, but it's important that the code is efficient and free from bugs.

I want a mobile application for iOS that can effectively extract text from images captured by the camera and then accurately highlights specific words. Key Features: - **Text Extraction:** Accurate OCR technology that can interpret and transcribe text from images with precision. - **Word Highlighting:** The app should be able to highlight certain words based on user input. I prefer these highlights to be done via color changes. - **Image Handling:** The app should allow users to take photos from within the application itself or upload from gallery Ideal Skills: - Proficiency in iOS app development. - Experience with Optical Character Recognition (OCR) technology. - Knowledge of effective text highlighting within a mobile app. - Familiarity with designing a user-friendly inter...

For this task, I am searching for a freelancer skilled in audio editing to extract names from a 20-minute audio. The quality of the recording is good. What is needed: - Eliminate names using a beep sound. The outcome should not interrupt the flow of dialogue, maintaining as natural a progression as possible. - Post redaction, convert the audio file to MP3 format. Ideal Skills and Qualifications: - Experience with audio editing, specifically redaction. - Expertise in manipulating sound while minimising disruption to surrounding audio. - Proficient in converting audio files to different formats. Please ensure you have the correct software and expertise before bidding. This project requires precision and attention to detail for effective completion.

I need a skilled Wordpress professional to update and arrange my blog posts on my Elementor site. The updates include text editing, adding and replacing images, and adjusting the layout. Key Tasks: - Update 4 blog posts: The main task is to rewrite some of the content and add or replace images where necessary. This update should be done ...use and publish them on the site. - Elementor and Wordpress proficiency: You must have a good understanding of Elementor and Wordpress to carry out the necessary updates and arrangements. The project is of top priority and needs to be completed ASAP. I'm looking for someone who can work efficiently, collaborate with me well, and ensure the tasks are completed to a high standard. You need to extract images from pdf's You need to uplo...

As the project owner, I'm seeking a professional skilled in Pine Script with experience in retrieving code from private scripts on Trading view. The key objectives of this project include: - Extracting the Pine Script code from a specific invite-only script (the script name will be shared privately upon project commencement). Unfortunately, it's currently unknown which specific script to be used, but clarity will be provided as the project progresses. - Discern the implemented functions within the script. The functionalities mainly centered around recognizable trading indicators like Moving averages, Pivots, Fibonacci and MACD. - The code extraction should consider compatibility with variable timeframes. Whilst exact timeframes aren't specified yet, flexibility should be ...

...dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA w...

I'm in need of a professional who can consistently extract data from a specific website on a daily basis. Key Requirements: - Data Extraction: Extracting various forms of data from a website. - Ongoing basis: This is not a one-time job. I'm looking for long-term cooperation, with the extraction ideally happening on a daily schedule. Ideal Skills and Experience: - Web Scraping: Proficiency in web scraping tools and techniques is a must. - Automation: Experience with automating the extraction process to make it efficient. - Consistency: Ability to maintain a daily extraction schedule accurately is crucial. Please include in your bid how you plan to approach this sort of ongoing data extraction.

...under or over exposed on purpose. My key requirement hinges on using comprehensive digital image processing techniques to extract hidden information from these photos. The ideal freelancer for this task would have a strong background in this field, with proven expertise and enhanced skills. Expectations from the investigation include: • High level of detail: I need precise features clearly identified, even clear text if possible. The ultimate goal is to achieve the best possible clarity on the obscured parts of these crucial images. Therefore, this job best suits individuals who are proficient in digital forensics, image enhancement algorithms, and any related visual data extraction techniques....

I need a professional who can extract data from a website on a daily basis. Key Responsibilities: - Extracting data from a specified website - Ensuring the data is accurate and up to date - Delivering the data in a specified format Skills and Experience: - Proficient in web scraping and data extraction - Experience in automating data extraction processes - Ability to maintain data accuracy and consistency - Knowledge of relevant data formats for delivery - Strong attention to detail and reliability This is an ongoing project, and I need someone who can commit to daily extractions. Be sure to include relevant experience in your bid.

...is proficient in Python, specially trained in Chatgpt, to build a web-based AI application for my business. I need the application to be specialized in natural language processing and sentiment analysis, and subsequently serve as a recommender system to provide information and answer queries. Key Features: - Natural Language Processing: The system should be capable of comprehending textual data, extract relevant details and produce appropriate outcomes. - Sentiment Analysis: Enable the detection and understanding of sentiments within the processed text. - Recommender System: The goal is to provide customized information based on the user's interests or preferences. - Information Provider: The AI should function as chatbot, furnishing necessary details upon a user...

I'm seeking a skilled analyst to develop a geographic profile map that displays crime rates within the city. The goal of this representation is to visualize and understand patterns in city-level criminal activities. Ideal Skills and Experie...within the city. The goal of this representation is to visualize and understand patterns in city-level criminal activities. Ideal Skills and Experience: - Proficient in Geographic Information Systems (GIS) or similar software for cartographic design - Background in criminology or relevant areas is beneficial - Familiarity with data extraction from various online sources Project Responsibilities: - Extract data from internet sources - Analyze and present the data in a geo-visual format - Maintain accuracy in repr...

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requir...with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

I am seeking a professional to develop a software that can efficiently extract and present the scripts used on a list of URLs provided. The software should be able to handle up to 1000 URLs at a time and run specifically on Windows. Key requirements include: - Extracting scripts: The software should be able to seamlessly access the provided URLs and list the scripts used on each page. - Bulk processing: The software should be capable of handling a significant amount of URLs, up to 1000 at once. - Windows compatibility: It is essential that the software is designed to run on Windows OS. Website Accessibility: - Restricted access: Websites that require restricted access or login should be identified and reported separately. The software should skip such pages and indicate the...

I am seeking an expert capable of efficiently and accurately pulling LinkedIn data from a list of companies and cataloging employees who previously worked at a specified set of organizations. The ideal freelancer for this project should have: - Experience in web scraping, particularly with LinkedIn data - Ability to extract data at scale - Proficiency in organizing and structuring data for clear analysis - Strong attention to detail to ensure data accuracy The project involves: - Using the provided list of target companies to source employees' data - Identifying individuals who have previously worked at the provided specific companies - Compiling the data in a spreadsheet format for delivery The successful applicant should not...

I'm in the religious industry, looking to extract a dove and keys symbol in an IPS format for my marketing and signage. I'm not sure if these elements are available in the original files, so you might need to advise on whether they should be recreated from scratch. Ideal Skills and Experience: - Graphic design expertise, especially in using IPS format - Knowledge of religious symbols and their connotations - Experience in marketing material and signage design - Good communication skills to advise on the appropriate approach.

...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and...

I am looking for a skilled freelancer to help me compile personalized information from a list of 400 LinkedIn prospects. The list includes their LinkedIn profile URL, email, phone, name, current employer, current title, industry, location, and company size. Project Requirements: 1) Review each LinkedIn profile. 2) Extract three pieces of personal information about the prospect that a friend might know. This could include: - Interests or hobbies - Recent achievements or career milestones - Personal anecdotes or notable mentions in bio or recommendation Deliverables: - A completed spreadsheet with the extracted information for all 400 prospects. - The information should be concise, relevant, and suitable for use in a personalized outreach message. *Opportunity for ongoing work. ...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

...Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're confident in your web scraping

I need a VRBO scraper to extract property details, pricing, and availability. - The scraper should be built with Python and the output should be in CSV format. - The data points I need include property title, description, amenities, pricing, and availability. - The scraper should be able to handle multiple URLs at once. - The code should be well-structured and commented for easy maintenance. Ideal skills: - Proficiency in Python - Experience in web scraping - Understanding of VRBO website structure - Ability to handle and store data in CSV format

I need a web scraping professional to create a script to extract specific data from , a popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookmarks+

I'm seeking a Python developer experienced with web scraping. This job involves setting up a Python script that can scrape a popular review site. Key details to extract: - Review text - Star rating - Date of review - Reviewer name - Star-ratings for sub-categories - Review ID - Reviewed person - Reviewed product name The site does not use captchas, so it should be reasonably straightforward. All reviews for a given provider should be scraped. It would be good to have an option to start with the newest and stop at a certain date. The specific review site can be seen in the sample URL in the attached PDF. I can send further details in a private message including screenshots. Preferred frameworks would be Beautifoulsoup 4 / Scrapy if sufficient and Selenium otherwise. Please...

I require a one-time data scraping project completed on multiple websites. - TASK: The task involves scraping text content from: Google searches: Commercial Real estate agency Saudi Arabia Commercial Real estate agency UAE Commercial Real estate agency Qatar Commercial Real estate agency Kuwait Commercial Real estate agency Bahrain I have made a start to the spreadsheet with a template for each of the regions which can be continued to be filled in. In the Google searches, just take the first 3 pages with the main agent listings and see what agent names/ email addresses you can find. - DATA REQUIRED: The primary data needed is text content. - TIMELINE: This is a one-time task, with no ongoing scraping requirements. Skills/Experience: - Proficiency

I need an expert in Optical Character Recognition (OCR) technology to convert text from high-resolution, clear photographs to editable text. Key Project Details: - **Purpose**: The primary objective of this task is to extract data from various documents. - **Image Type**: The text extraction will specifically be from photographs of text. - **Image Quality**: All photographs are high resolution and clear. Ideal Skills and Experience: - Proficient in Optical Character Recognition (OCR) technology - Prior experience in extracting data from images - Excellent attention to detail to ensure accurate transcription - Ability to work efficiently with high-resolution images

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I r...scraping professional with experience in extracting text and images from multiple websites. Your task will involve the following: - Scrape data from Sephora, Cult Beauty, Space nk - Extract specifically the Text, Images, Titles, Descriptions, and Prices A strong background in web scraping, data extraction, and working proficiently across different websites is critical for this project. Knowledge in web parsing methods and ability to bypass potential anti-scraping tools or blocks set up on these websites will be highly advantageous. Your goal is to accurately scrape the necessary information without causing disruption to the target websites, and ensure the data is comprehensible and ready for further use. I would like to see an example of 1 page done ...

I have a small LinkedIn network of less than 1100 connections and 1500 followers. I'm looking for someone who can help me consolidate their details into a neat spreadsheet with their emails. Key Requirements: - Extracting email addresses: You'll need to be able to extract the email addresses of my connections and followers. - Data presentation: Organize the data in a clear, logical manner which makes the spreadsheet easy to navigate. - Timeliness: I'm aiming for a quick turnaround on this project, ideally within 24-48 hours. Since I have explicit permission from my contacts to collect their emails, this project is ethical and should proceed smoothly. I'm looking forward to seeing how you can help me in this task.

I urgently need someone to extract shareholder information from the Madagascar business registry. The work needs to be done as soon as possible. Key Requirements: - Retrieve shareholder data from the Madagascar business registry - The data should be presented in a clear, easily understandable format

I need a Python Selenium application that can scrape blog posts from Site A and post them on Site B. Key Requirements: - The Python app should be built using Selenium for web scraping and automation. - It should be able to extract blog posts from Site A, specifically. - The extracted data must be posted on an existing blog section of Site B. Ideal Skills & Experience: - Proficient in Python, with experience in building web scrapers. - Strong knowledge of Selenium for web automation. - Previous experience with data extraction and manipulation. - Understanding of web protocols and site structures. - Familiarity with blog post formatting and publishing is a plus.

I'm looking for an Android developer to enhance my app to support zip and rar files. The functionality should include: - Support for both zip and rar files - Support for both password-protected and standard files - Ability for users to extract files - Ability for users to view file contents The ideal candidate should have experience in Android app development, specifically dealing with file handling and storage. Knowledge of third-party libraries for handling zip and rar files is a plus. The developer should also be comfortable with implementing password protection mechanisms. Please note that the app is already built, so the task would primarily involve adding the requested functionality.

...Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration &...

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database is mysql. Functionality for Taking Photos Using HTML5 and JavaScript, you can use an input element with the type file and the attribute accept="image/*" to allow users to take pictures of documents directly from the browser on a mobile device. Uploading the Image to the Server When...

I'm seeking a professional with experience in text annotation to help me enhance readability and extract key information from Arabic comments on both Facebook and Instagram. This project involves identifying key trends and patterns within these comments. Key Job Requirements: - Fluent in Arabic and English - Excellent understanding of social media platforms, specifically Facebook and Instagram - Strong background in text annotation - Ability to identify patterns and trends in text - Detail-oriented, with a focus on accuracy and consistency Your task will involve reviewing and interpreting comments, then accurately annotifying the content to extract the necessary data. This is a task requiring high levels of concentration and linguistic comprehension. Applying ...

I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box

...Statutory Registers Key Requirements: A. Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). B. Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). C. Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Related Annual Return). G. Preparation & Filing of Annual Returns Form MGT - 07/07A (Management Related Annual Return). H. Preparation & Filing of Minutes of 04 Board Meeting & Minutes of AGM. ...

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

...SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for new products, including the data required for the modeling process. Requirements: Pricing Comparison: Compile accurate, up-to-date pricing details, including different subscription plans and any additional fees. Feature Analysis: Evaluate and compare the capabilities of each 3D planner, including customization options and integration capacities. Visual Representation: Create a comprehensive table and visually appealing graphics to clearly compare the dat...

...model should be able to understand the text in the images and provide relevant responses to the queries. - The AI model should be trained to high accuracy standards, achieving results of 90% or higher. This level of precision is crucial for the success of the project. - The primary images that the AI model will analyze are photographs. The model should be specifically designed to handle and extract text information from photos. Ideal Skills and Experience: - Experience in training AI models, specifically in the area of image to text conversion. - Proficiency in deep learning frameworks and tools, such as TensorFlow, PyTorch, or similar. - Strong knowledge of natural language processing (NLP) techniques. - Proven track record of achieving high accuracy levels in AI model ...

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue(&quo...