I have tried to search these forms for some information on how to have VBA code check a file saved in an FTP site. I am hoping to use this file to contain version information where the workbook code will compare the version of the workbook to the version log saved in a text file on an FTP server. If they are different, I would like a pop up window to appear that notifies the user that there is a new file available, and perhaps a prompt to save that new file to the user's computer (it does not need to update and replace current workbook).
Is it possible to have VBA check an FTP site for this if I put the username and password in the code?
I've got a basic spreadsheet that I edit at home and at work, and I am always forgetting to either email it to myself or copy it to a flash drive. So I figure I'll use my ISPs webspace given to me, and then just edit it on the ftp site from home and work so there is just one copy. I can add the ftp site and my name and password in Excel fine. BUT when I open it, it is always read only. How do I open it with write access? I have specified my ftp username and password in Excel.
I'm working with a file from SharePoint (FileA), "FileA" goes out to Sharepoint and opens "FileB" (if not already open) then copies information from "FileA" to "FileB". However if "FileA" is left open, or someone else has it open I am unable to open "FileA". How in VBA can I check to ensure I don't have it open locally (if so swich and continue), checkout and open in SharePoint (if not already open) or Prompt with options to force checkin, checkout to copy info?
I have the following code, saving created files to a local network. I need to change the save location to an FTP site (with username and password). Is this possible/How do I do this?
Sub Filter() Dim name As Object Application. ScreenUpdating = False Application.DisplayAlerts = False ActiveSheet. Unprotect Password:="letmein" MYCOUNTER = 100
I have a master workbook called "BoM count" which I would like to have capture all the materials used on site. This info has already been captured on the workbook "Survey of materials used on site" (There are losts of these, 1 per site)
I want to open the survey within the BoM count workbook and pull out the relivant numbers of materials used and also list the site ID to show that, that survey has been completed.
I have a some problem with connecting between VBA Excel and web site.
I wrote a macro to insert the data from excel but there is one problem with displaying the correct view.
I use this site to get the price of the bonds: [url]
it is the site of russian exchange
First of all I write the ISIN code, for example RU000A0E6X12, in the "Quote Search" field and then press Enter for getting the data. After it I can choose the History information or Online from the last field in the left margin. I want to chose "History" and after it the dates from and till are appearing automatically. The automatization of it is my task. And I have only one problem in the end.
I have the vacation sheet so I can track my vacation hours used and available. The last thing I need is a way to count the number of days I'm not at my site. It doesn't matter why (Training, Holiday, Travel or Vacation) I need to track total days of site.
I am working on a spreadsheet that hits an external site. My questions is, I need to hit the site about 80 times becuase I search for different info. It there a way to get the vba to go down a list 80 of names rather than me entering the vba code 80 times with the different names?
I am trying to create a spreadsheet to record the amount of cars in a car park at any one time.
I have created a basic sheet with columns for car/reg/visiting and a drop down box for time in and time out (both done using validation lists) and a duration column that calculates the time between in and out.
What I am looking to do is create something that tells me how many cars are onsite at any one time, taking into consideration what time cars come and go.
Then from this I am looking to produce a chart with axis of to time/cars.
I've created a VBA-Form to import csv files into a spreadsheet. Problem is IT have moved them to a secure server, and i've been given FTP Access to this server: \00.0.00.0folderfolder.
I have a module which can locate a folder and count how many csv files are in that directory. Problem is if i put in the ftp address it doesnt connect because i need to login via the RUN window, by putting the FTp address then entering my userID and password.
Is there anyway i can bring up this dialog box without using the RUN window. i've attached a spreadsheet with a screen dump of the dialog box
I am trying to fine an easy way to sort the attached spread sheet. it is a down load from our supplier which has a lot af data that i am not interesed in the only ones i need are columns description (r) and units (o) and name (g).
I am wanting to split each waste i.e oil fitters, acid batteries etc and each site so that the total amount each site has returned can be tabled ,so that i can create graphs showing who has/ has not return their waste steams.
I am using a vlookup formula to a series of data sets. I am trying to get something so that it will display the relevant score for that site. However the lists are not the same size, how do i get a vlookup to read a score for a site if it is the the array but display "0" if the site name is not in the array?
It is coming up with #N/A and I can't do anything with that.
I've attached a sample workbook. Data Table 2 on the Data Tables sheet is what I'm after. Basically I have a formula that sums up quantity 1 (Q1) and quantity 2 (Q2) for all widgets at a site name and month. So for example, go down through column site name and column month and add up all of Q1 for site1 in the month of Jun 2014 (all widgets). This works but it shows duplicate totals which makes sense as there are mutliple widget types at each site. I think the example workbook explains it better. Note the Pivot Table sheet is an example of what I'm showing currently and what I'd like to show. While I understand that depending on how I set up the Pivot Table I can get similar results using either Table 1 or Table 2 but the other thing is that my users like to do some filtering of the data sheet itself without regard to the Pivot Tables.
import data from a website that requires a login/password (no login page, it pops up in a separate window like when trying to log onto an FTP).
I've got the login/password, and it's a simple call to the page to import it, but each time it asks me to authenticate when connecting (get the "Windows Security" popup asking me to authenticate).
Even when I select "Remember my credentials", it doesn't seem to, and so every time I end up having to manually hit enter to get by it.
Is there any way to pass the login/password information via VBA, or to get the "remember my credentials" to stick?
I have a website (National Lacrosse League - 2013 Regular Season - Standings), that I want to pull information off and automatically into Excel.
I have been using web queries on other websites, and they have worked beautifully, however the tables that I want aren't recognised by the web query wizard (no yellow/black arrows). I can import the whole page through a query, however that's not really practical.
Is there a way I can import just specific tables on this site?? I'd like both the 'east' and 'west' tables.
Sub send_to_UCC() Dim upcCode Dim myTextField As Object upcCode = "0001234512345" Set appIE = CreateObject("INTERNETEXPLORER.APPLICATION") appIE.navigate "http://directory.gs1.org/gtin" appIE.Visible = True Do While appIE.busy DoEvents Loop With appIE Set myTextField = .Document.all.Item("queryByGtin_key") myTextField.Value = upcCode End With Set myTextField = Nothing End Sub...........................
Everything is the same except the URL and the textbox name.
Cell A1 value is: www.yahoo.com B1 Value should automatically show "Possible" Cell A1 value is: www.icallindia.net B1 Value should automatically show "Possible" Cell A1 value is: www.jigarparekh.html B1 Value should automatically show "notvalid"
I need a formula which can automatically see the status of the website address and updated in B column. which means that one dose not need to go to the website page to see if it is correct or not.
I have lot of website in the one sheet and i don't want to go all this website and check if they are correct. I want the status of this website in b column once when i have the website name already in the A column.
We have a list of around 800 clients containing client id, name and e-mail and i need to add contract number. I can only get the contract number by accessing the admin (password-protected) using a URL that looks like this admin/index.php?client=id.
Problems:
1. if i use the From Web option in excel's data tab, i get the entire table not just the needed cell 2. if i get the data using the above mentioned option, i can only do it from one client at a time
Is there any way to have a web query stay connected and get live data from a site while still being able to use excel at the same time?
Basically the site has information that changes by the second and i need to keep a running record of it, and when it hits the variables needed i want to be able to trigger a set of code.
Fabrication and Site Visit in Budget/Spend Analysis - Budget, not pulling through information from drop down boxes - in both cost type columns (they dont seem to be active any more either, not sure what I have done there!
I have a list of web address in column A. All of the web address belong to the same site and are different products at the store. I want to be able to some how launch the sites and have Excel copy the text string which follows the word "PRICE:" on the site back into Excel into the corresponding cell of column B.
I have a spreadsheet where raw data is entered ("RAW_DATA") for each month it is collected. There are 7 questions that are tallied and each of those responses are transfered to a separate data table for analysis (7 individual tabs within the spreadsheet). I'm currently manually data entering the values from the raw data tab to the other seven tabs.
I would like to have VBA code that could transfer the data from one month ("RAW_DATA") onto the other 7 tabs based on the date and facility identified in the raw data tab. I have not attempted the VBA since I do not know where to start with searching on two variables.
Automating Excel from Access, I'm attempting to generate a single sheet workbook and save to a Sharepoint site. This process works fine on my machine (XL2007, XP), but on a coworkers computer (XL2003, XP), the code throws a 1004 error on the save as line. However, the really odd thing is that stepping through the code doesn't throw an error on the coworkers machine.
Here's the sub being ran; the line it errors out on is the first branch in the .saveas block.
Private Sub PublishXLtoMOSS() Dim objXL As Excel.Application 'Object Dim wb As Excel.workbook 'Object Dim ws As Excel.Worksheet 'Object Dim rs As DAO.Recordset Dim i As Long
I was asked to create a userform for the use of our whole team which would enable them to select a name from a dropdown list and then it would display their business contact details in the rest of the form.
I'm running Office 2010 and Windows XP server/enterprise edition (not quite sure which). After some research I've managed to use VBA code to open the userform while hiding the workbook, then when the close button is clicked it closes the user form and it's associated workbook using the code below.
Code: ' ThisWorkbook module Private Sub Workbook_Open() Application.Visible = False UserForm1.Show End Sub 'UserForm module Private Sub CommandButton1_Click() Unload UserForm1 ThisWorkbook.Close (False) End Sub
This works great when the excel file is accessed directly. However when the excel file is accessed via the link on my teams Sharepoint site it doesn't. When the Userform is closed the underlying workbook and data is then displayed which then has to be closed separately.
