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'm looking for a way to automatically upload a file to an FTP site. I'm currently writing out a text file, but then have to use an FTP app to move the file over. any thoughts on how to best do this?
View 4 Replies View RelatedIm trying to upload an excel document to a PDA and it does not seem to be picking up the document in full ..... The document has a lot of coding and text boxes (through forms) - and it seems as though this is not being picked up ...
Is there any reason this may be happening ??? Do i need to refine the document to suit PDA format ????
I would like to write a script to upload image to this website. These images are in my local directory and their names are defined in excel file (cell J2:J5)This button in this website using flash so it make me hard.
i attached the file here
Using VBA to upload image to website
strCommand = cstrSftp & " -sftp -r -l " & pUser & " -pw " & pPass & _
" " & pFile & " " & pHost & ":" & pRemotePath
Shell strCommand, 1
how we can know that file uploaded to ftp or not. and how to know whether given username and password and host correct or not.
I'm uploading a .msg file but i can't seem to go through with the DisplayAsIcon option and i also want to put the Date at the end of the file's name,to somehow track the uploaded files and maybe sort them by date. At the time of the upload moment i see the filesname with the date at the end of the name but after i save the file it overwrites the objects icon the i end up with an envelop icon and the uploaded files name. Here's my code:
Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Select Case ActiveCell.Address
Case "$I$29": Run "Email"
[Code] ........
How to upload data in an excel listview using vba.
Will appreciate if anyone can give an example.
My case is:
I have five columns in the listview. Now i need to run a loop to upload data in each column.
I want to create a vba code in excel to select rows and upload into an external application called siebel. i can take care of the later part but I am not sure how to select the records and do the upload. In my case I would like to select records from the 17th row until the EOF..
Also pls suggest which is a better option
1) Selecting first row, upload it and then select the next row and upload (OR)
2) Select all the records at a time and dump the data..
I'm trying to accomplish. I have a series of addresses that I would like to import into a google earth type map (or similar mapping type program), which would put a "tack" type icon on the map where the address should be located, etc.
View 7 Replies View RelatedI need to upload the excel file (Book1.xlsx) which is placed in my desktop to the sharepoint 2010.
View 1 Replies View RelatedTitle says it all. By safely I mean the following:
I have hidden worksheets that I want to remain hidden
I want my formulas to remain hidden
I only want a few amount of cells to be edit-able
The idea is to upload an Excel workbook onto my website that other users can have access to, interact with, but not change.
Currently I have done userform which works fine. I have one issue:
Uploading data to sheets is extremely slow ( takes about 30 secs)
I suppose finding last row takes much of it. How to replace 'lastrow' concept?
[Code]......
I have a workbook with a number of active sheets, I am wanting to be able to create a button that allows the user to upload an image from their computer to a particular cell. I wish to be able to create a fixed size for this image so it crops it proportionally. In effect it is a button that open the insert picture dialog. I then want this picture to be placed in a particular cell.
I can then use this picture in other part of the workbook so that it inserts it in to other areas.
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.
The program:
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 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.
View 4 Replies View RelatedI 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?
Is it possible to open a file on an FTP site using VBA?
I've tried using the code below but it asks for a username and password even though it is in the code.
Workbooks.OpenText Filename:="ftp://username:password@ipaddress/ste1.txt", Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(0, 1)
i have 306 web pages listed in sheet 1, A1:A306
how can i get a macro to open each and scrape a piece of info from each, and then store in a row in sheet 2?
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
Currently I am working on a system uploading data from word(with what i think has a script) into a database one by one.(template of somesort) the data is stored into the database in word format.
can i place all the data in rows then get excel to transfer cell content into word and wait for it to upload then clear the contents(word) then do the next row(excel) until it did every cell that's filled? do i need any other applications for this one or can excel alone do it? i'd also like to add a new tab to excel for the command on when excel will do this.
I'm using VBA to upload the open workbook to app.box URL which is working great! Since I'm pretty new to VBA, I can't figure out how to get Excel to display the sucess/failed message from the server to the user. I used the VBA POST upload module from this awesome tutorial, but I can't figure out how to return the message to the user. I did figure out that on the website there is an "id="after_upload_message", not sure if that works. My code is below.
[Code] ......
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 have a string of information in an Excel download from PayPal that I need to upload into QB; but, the information needs to be in a different format. The string from the download is:
Property Address - 1116 South PaxonBorrower " Testa and Son Contractors,LLCLoan # - 1402088Acct Executive " Brandon Tully
But, I need it to be:
1402040;TPAPR;141 North Clinton Street, East Orange, NJ 07017;Leslie P Carter
Is there a formula that I can use to extract specific information from the original string into columns so I can then concatenate the columns into the information I need to upload? Or is there a better way to do this? The Property Address and Borrower Name are not static sizes so I can't use a formula that counts spaces.
how to copy data from one workbook to another workbook.
here's the process
1. Button upload is in book1 sheet 1
2. Copy data from book to book 1 sheet 2
Here's my code for starters.
[Code] ....
The following code works great:
VB:
Sub send_to_UCC()
Dim upcCode
Dim myTextField As Object
[Code] .....
But when the following code for a different page, does not work.
VB:
Sub send_to_UCC2()
Dim upcCode
Dim myTextField As Object
[Code] .....
Everything is the same except the URL and the textbox name.
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.
sum quantity and show total for each site.xlsx