automation excel

New to browser automation here. I am trying to open a webpage and browse a list of entries. The bot has to open the first one , execute some tasks ,once done proceed to the next entry until the end. Can someone with exp. give some hints. Thanks a ton. I get a "object doesnt support this method"...

I start with I apologise if this sounds confusing. I am working with Excel 365 but also needing it to be compatible with Google sheets. My workbook has 6 sheets in it a dashboard which I am pretty much fine with then 5 other sheets. Each sheet has a range of A1:FI625. The data is broken...

Hi everyone, Can someone please help me with my query regarding automating data reports from attribution model in google analytics. I have a report to do on a weekly basis for which I need the following data: Tool: Google analytics Within attribution projects Model comparison Report by...

Hi, So as the title says i'm a novice when it comes to VBA used it once before about 2 years ago and didn't really get it :') so the time has come where I require it and still don't get it :) So what i need VBA for: I am currently manually populating a worksheet based on the values from...

I am attempting to fully automate some processes overnight, but this is the one thing causing some issues right now. I have found a solution to automating the Classification system my company employs by calling functions that set the mouse position and then click which then allows me to save...

Hi All, Can some one help in automating the notepad data replacement. I have data of 6 columns and 2 rows that consists of names and numbers count, and I have a date in my notepad along with same components that are in excel. I need to automate like when ever I had updated values in excel...

I need to be able to have individual sheets from different WKBKS to link data to another WKBK which is my dashboard. What I am trying to achieve is I need is to be able to open all WKBK'S in a Folder automatically and import the data, sheet1 from each WKBK so that the sheets copied will...

I need to download .PDF files from url. I tried the below code and it is not working. Option Explicit Private Declare Function URLDownloadToFile Lib "urlmon" Alias _ "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal _ szFileName As String, ByVal dwReserved As...

I'm trying to automatically append any new data from one excel tab (ReportExport) to another tab (MappingTool) if the vlookup on the MappingTool tab is equal to N/A. Example: A new ReportExport is run everyday. The Report Export is linked to the Mapping Tool tab using a VLooup to confirm the...

Hello, How to do Auto Spell Check in excel, and please how to remove the format after correction. thanks:)

I made up this sports data so none of it is accurate or even remotely right but it is for the sake of the real data I am using. (Sorry it's a long explanation) http://i.stack.imgur.com/3ay85.png Overview: This is a picture of a scorecard I am working on that reports on various metrics related...

Hello, I could really use some help getting this program to work via command line. I am trying to automate the process without a GUI popping up. THe company provides the following command line information csv2ofx.exe mapping1 file1.csv file.ofx The respective parts I am using are...

I have been researching the solution to this problem for several days with no results that match my problem. I am hoping it is possible and I have come here in hopes that someone will know. I am using Excel 2007 but have access to Excel 2010. My boss has been using an Excel sheet as a template...

Hi Dear, Please help me for automation using excel macros. I am spending so much time to prepare master file using vlookup & some more functions. But i need help to auto update by opening master file with daily dump file. In my master file i have fixed columns are Order numbers , order...

I need to import data from the census.gov website, specifically historical data. Building Permits Survey > Permits by Metropolitan Area This is the query interface for the website. It creates data sets that look like this. http://www.census.gov/construction/bps/txt/tb3v201401.txt I noticed that...

Hi, I am new in this forum, but have monitored long time and have become a big fans of it. This forum had helped me a lot in vba excel problems. However this time I couldn't find any answer for my new issue to use translation.babylon.com I have function which work perfectly with google...

Hi, in my project I need to call some user-defined functions written in VBA from a C++ program. Specifically, there are some objects created in VBA, and we have some user-defined VBA functions to dynamically calculate some values based on these objects. I need to pass these calculated values to...