Incorporating DropBox Files Within Excel

Oct 31, 2013

I have a number of files organised in a number of folders on Dropbox. I create a macro to enable me to be able to navigate to a particular folder and then get a list of all the files in that folder to be placed within certain cells on the spreadsheet I'm working with in Excel.

View 2 Replies


IF Incorporating VLOOKUP

Aug 10, 2009

I have a spreadsheet containing all products in sheet 1. I have a list of promotional codes in sheet 2. In sheet 1 I want to say 'If cell A2 is contained in column B of sheet 2, then say YES, if not then leave blank'.

I've tried the following but it doesn't work:

=IF(VLOOKUP(A6,Sheet2!B:B,1,FALSE),"Yes"," ")

I get #N/A when the item is not in sheet 2 and #VALUE! when it is.

View 9 Replies View Related

Incorporating Variable Into Loop

Jun 29, 2013

I'm trying to use loop to activate 3 workbooks "OSB1", "OSB2", and "OSB3" and their respective sheets. "OSB1" has sheet "OSB1" in it, workbook "OSB2" has sheet "OSB2" in it etc.

The digit on the end of each OSB is the variable I am using in the loop.

What I am trying to come out with is the following 3 workbooks and sheets being activated:


I've given up the code as I can't work out the inverted commas:

Dim x As Integer
For x = 1 To 3
OSB" & x & ".Sheets("OSB" & x & "").Activate
Next x

Is it possible to do this at all? The bit after "Sheets" is correct. It's part with the first "x" after the first "OSB" which is incorrect now...

( In my actual code I'm trying to do more than just activate the 3 sheets but need to work out the syntax for this to be able to edit the remainder).

View 9 Replies View Related

Making Dropbox From Datatable?

May 6, 2014

I am a Coach who will be using this data table to call pitches via a catcher's wristband. The band is obviously completed below; however, I need to create a separate sheet where the numbers correlate to the pitches that are being called. How it works: everything in the table(s) with a dash is a pitch i.e. 2-1, 1-3, 1-U, etc. The numbers on the columns and row are what is relayed to the catcher to call the corresponding pitch. For example, I would signal is 113 (first number = row second number = column). 113 is 4-1. I need a way/ formula to where I can see which numbers are to be relayed in for each pitch. It would possible look like 2-1: 101, 411, 422, 501, etc.

View 5 Replies View Related

Conditional DropBox (5 Variables)

Jun 11, 2014

I have a table with a lot of variables and i need to extract some of the values of that are conditionated by 5 variables and put them in a drop box. How can I do that???

The first picture is a part of my "help table" and the second is the table that i want to fill.

In yellow are the problems...


View 12 Replies View Related

Sum Based On Dropbox Date

Jan 31, 2014

I have a drop down box in "U2" which is pulling a date. 31/01/2014, 28/02/2014 and so on..

In "S6:AD6" I have the same dates. I want to be able to, in "AE16" have a sum from anything before or equal to the figure in "U2".

View 5 Replies View Related

Incorporating Lookup Value In Macro

Oct 2, 2007

I have the following sendmail macro. However I need the "To" section to be the result of a lookup in a worksheet. The specific function that i need it to be is: =VLOOKUP(A837,'Tenacity Jobs'!1:65536,5,FALSE)

How can I incorporate this function so it will insert the result of the lookup into the "To" box ?

View 11 Replies View Related

Can Worksheet_BeforeDoubleClick Work Over A DropBox?

May 13, 2009

I have a macro procedure that runs when doubleClick. This procedure is writen on the Sheet code under the "Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)".

I realize that when there is a dropBox, the procedure does not start. It drops the dropBox menu instead of running the Macro.

Is there any way to make the procedure run even when doubleclicking on DropBoxes?

View 7 Replies View Related

Incorporating Macro Import Within Another Sub?

Jan 13, 2012

The following code (blue font) finds specific worksheets in an active workbook, and copies them into a new workbook then names the new workbook the same name of the worksheet. It all works perfectly.

The second code below (red font) imports some vb into the new workbook. It works fine if I manually open the new workbook and run it in the immediate window. However, I would like to incorporate the red code into the blue code so it all runs as one. I've tried inserting the red line after the "ws.copy after" line and after the ".saveas" line, but no dice.

For Each ws In wb.Worksheets
If UCase(Left(ws.Name, 2)) = "CC" Then
Set NewBook = Workbooks.Add


View 9 Replies View Related

Use Dropbox When Sheet Is Protected

Jan 26, 2009

I have a dropbox located on a sheet which other information needs to remain protected.

How do we give access to users to the dropbox while the remainder of the sheet is protected?

View 9 Replies View Related

Incorporating An IF Statement To Basic SUM

Dec 3, 2009

I have the below formula to make a simple calculation:

I would like to adapt the formula to ask IF AG1880 is empty or not. If AG1880 is empty then I would like the formula to NOT make the calculation, but instead return "--" (nothing).

If it contains information, then I want the calculation (AC1880+AJ1880) to be made. If AG1880 contains information it will be text in a text format.

View 9 Replies View Related

Combine Dropbox Selections Into New Columns?

Mar 13, 2014


What I'm after is an easier way to get data combined without having to type it all out. If you look above I would like to have A-C actually as dropbox's or listbox's, something I can click, then drop down to the proper name and select it. Then on E I'd like a timestamp for when this action was done with the date and time as shown along with the reason. Then in F I'd like the Name fields combined so I just need to right-click on F and copy/paste into the other program I use.

Maybe one column can just be the names of everyone with a selection box and I click this stuff then when I am done it resets?

View 1 Replies View Related

Using Macro VBA To Select From Dropbox On Webpage

Nov 4, 2013

The thing is I can open ie explorer and navigate to the page I need. What I'd like to do is be able to select from a drop box on the web page when it's already open is this at all possible.

View 1 Replies View Related

Dynamic Name Range Incorporating VLOOKUP

Aug 27, 2009

I'm trying to create a dynamic Named Range using VLOOKUP in place of a sheet name. (Using Excel 2003 & Win XP Pro SP2).

To illustrate:-

Employees.xls contains employee's details on separate sheets for each department, e.g. Production, Admin, Sales, Personnel, etc. Each sheet is 12 cols. and 1 header row. Sheet 1 of this book contains a 2-column Master List of all employees and their departments. MyBook.xls has an employee's name in A1.

I can get his department by using =VLOOKUP(A1,MasterList,2,FALSE) and what I want to do is incorporate that into the following in place of 'Admin' so that the range will refer to the correct department for whoever's name is in A1.


View 9 Replies View Related

Convert All CSV Files In A Folder To Excel Files?

Apr 8, 2014

I is it possible to convert all comma separated text files in a single folder in to excel files. But the requirement is to have 2 sheets in each new file. first to be the full file - with all columns, and in the second sheet to keep only colum A B D G H K L M O P R S T V W from the first sheet. The second sheet name must be the same as the first one but without the first "wlist_" in the name.

One more thing. The third column in the second is called "COUL". there are short letters for colors in french

can they be converted with the sort in English like it goes:

NO = B
BA = W
RG = R
SO = P
JA = Y
BE = L
GR = G
VI = V
OR = O

Here is a link to the both CSV and an example excel file with the end result. In this example i haven`t change the shorts for the colors. It takes me too much time with the find and replace function. And at the moment i`m really pushed from time.


View 9 Replies View Related

Incorporating Data Analysis: Regression Into A Macro

Apr 10, 2009

I'm trying to write a macro that will analyze data from one spreadsheet and do a regression. The information I want to be output on the same sheet. I tried to use the record function, but I got an error. It said "Run-time error '1004': ATPVBAEN.XLA could not be found. The code read:

View 2 Replies View Related

Range Name + String As Source For Data Validation DropBox

Jul 16, 2009

I have several cells with data validation's drop Box. Every data validation uses a range name as source (myColorList). Here goes the hard part: I need a new value inside the dropBox list, but The problem is that I can NOT modify the "myColorList" range.

-- Is there any way to build up the dropbox source using the range name and the new value? Something like

View 2 Replies View Related

Incorporating Variable Into Average Function To Locate Cells

Nov 12, 2012

I am trying out VBA to write a macro in order to average every 25 cells in a column. My attempt so far is

Dim myrow1 As Integer
Dim myrow2 As Integer
myrow1 = 2
myrow2 = 25
ActiveCell.FormulaR1C1 = "=AVERAGE(R " & myrow1 & " C3:R " & myrow2 & " C3)"
myrow1 = myrow1 + 24
myrow2 = myrow2 + 24

So I am hoping the first ActiveCell.FormulaR1C1 gets read as =Average(C2:C25)

However I just get Run-time error '1004' Method 'FormulaR1C1' of object 'Range' failed.

View 3 Replies View Related

VBA Open All Text Files In Excel In Folder And Save Them As Excel File

Dec 7, 2013

I have some daily text files in a folder (so about 30 of them each month), which in the end of month, I need to open them up in excel, format them so that I can use the information for my analysis.

I would like to create a macro, to quickly open them all up at once and save them each individually in .xls or .xlsm format.

I am new to VBA and after some research online, I was able to have the files open with the following code. but now I don't know how to proceed further to save them one by one with the same name but in .xls or .xlsm format.

Sub Opentxtfiles()
Dim MyFolder As String
Dim myfile As String


View 2 Replies View Related

Linking 2 Columns To Fill 2 Columns In Dropbox List?

Mar 3, 2014

It's quite easy, I am trying to do a droplist (that's easy) but I want that drop list to take infos on 2 different columns and fill the 2 columns I want in the main sheet (see attachment)

On tab 'dealers' I have dealers name and account numbers. On tab 'Mileage' I have a cell call "NAME' and a cell call 'Accnt #/NB'. Here is what I want to do:

On sheet 'Mileage' I want to choose from a drop list a dealer name and I want Excel to populate the cell "Accnt#/NB" automatically by chosing the account number that is appropriate to the dealer choosen which is column 'B' in the dealers tab.

View 2 Replies View Related

Incorporating A Formula With "" Into A VBA Module

Aug 18, 2006

Part of the data I'm collecting from a CSV file is in the form of a hyphenated materials specification. In the current system of manually importing and formatting the tables from the CSV file, the formulas

=If(A10>0,MID(B10,1,SEARCH("-",B10)-1)," ")
=If(A10>0,RIGHT(B10,2)," ")

are used to separate the two components of the specification.

For example, a material specification of 362S162-43 would be separated into
"362S162" under one column and "43" in the next.

The quotation marks are giving me headaches when I try to write the formulas to the appropriate cells using VBA, however. I've got an understanding of what the formulas mean, but I don't know how else to go about splitting the relevant information at the hyphen with another technique.

View 3 Replies View Related

Why Does Excel Open Some Files As Csv

Dec 16, 2008

I receive excel reports every day. But the last couple of days when downloading the reports I get them as csv. Also older reports I have saved on the hard disk open as csv.

Well, the ones I have saved have are now csv files and I haven't done anything (knowingly) to change them to csv.

View 9 Replies View Related

Excel 2007 Tmp Files

Jan 29, 2009

I use Excel 2007 which is creating a whole load of tmp files of the spreadsheet that I work on.

Is there a way tostop Excel from creating and saving the tmp files?

View 14 Replies View Related

Convert CSV To QBO Files Via Excel

Dec 1, 2008

I Use the Quickbook 2009 for accounting. I need to convert CSV files over to QBO files. Any Software are not to Convert CSV files to QBO files.

It's Possible to Convert the CSV files to QBO Files via Excel.

View 6 Replies View Related

How To Merge Two Excel Files One Below The Other

Dec 3, 2013

I have two separate excel worksheets from which i want to merge two columns from each worksheet into a new sheet. from the first sheet column A & E and from second worksheet column B & D. The values of second worksheets need to start where the value of first sheet ends. Want a macro to run this automatically every time.

Have tried to merge and consolidate but macro does not work.

View 3 Replies View Related

How To Send Files Via FTP With Excel Macro

Sep 22, 2012

I want to send via FTP to a linux server the following.

1- All files that are named checked.XXX.YY.mtc to path /var/docs
2- All files where the name begins with checked.conf to path /etc

PD: I have the IP address, user and password of the server.

View 1 Replies View Related

Exporting To Multiple Excel Files

Feb 23, 2013

I have a spreadsheet with sales information contained in Sheet1. There are a number of columns including the Region column. I would like a bit of code that exports sales information to a number of Excel files dependent upon the region column. In other words the Region column can contain either North, East, South or West. I would like a different Excel file per region and I'd also like the file names to contain the name of the region + the month and year of the previous month ie if i was exporting today then the North Excel file would be called: "North Sales - Jan 2013".

View 9 Replies View Related


Apr 22, 2014

I received an email with a WORDPERFECT attachment. I couldn't open so I downloaded application (COREL)from Internet. I finally got to read my WORDPERFECT file but found out that COREL had changed all my EXCEL files to WORDPERFECT. How do I change them back to EXCEL flies?

View 4 Replies View Related

How To See Excel Files As Separately On Taskbar

Apr 5, 2005

When I open more than one Excel file, it used to display them as separate icons on my task bar. But for some reason, now I only get one one icon, and I have to go to Windows on the Menu Bar to switch between them. I can't use Alt/Tab anymore. It only affects Excel.

View 4 Replies View Related

Excel 2010 :: Can't Open WK3 Files

Dec 19, 2012

We use wk3 files a lot at work, but since switching to Excel 2010 I can't seem to read them anymore. Used to work fine with 2003.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved