quotes

I want to provide for automatic updating of values between two independent workbooks. Workbook A contains several price quotes. I’ve copied those quotes, using Paste Special/Paste Link into Workbook B. However, when I change the values in Workbook A, the new values are not automatically...

What I'm trying to achieve should be simple, but Excel keeps making it very difficult for me. All I want is a macro that does exactly the following and nothing else: Export all of the data in the active sheet to a text file in the active workbook directory The filename should be the name of...

Hi Guys Ok, So i'm trying to do something using VBA for work. Here's what i'm trying to do. A excel document that on the first slide has a list of numbers that will be quote numbers I then want to make it so i click a button and it will create a new worksheet with the next in line quote...

Hi, I’m trying to create a .CSV file separated by semicolon instead of a comma, like this exemplary file here, but some of the rows contain special characters and all the data must be wrapped by double quotes. I have changed the list separator under the Region in my windows control panel to be...

Hello, I am trying to determine if there is a way to create a workbook template for a sales quote that references other workbooks. In other words, is there a way to automate the population of data fields (eg. supplier, cost, description) when a manufacturer product number is entered into a...

Two questions: 1) I have an if statement with 2 vlookups and want to augment the formula to return a blank rather than N/A when the lookups yield no results. Formula I'm using: =IF(BH61="Parent",VLOOKUP(A:A,A:AI,35,0),VLOOKUP(BH:BH,A:AI,35,0)) 2) I am attempting to concatenate some cells...

So, I have used concatenate often in my spreadsheets. But I have encountered this situation in using it. I have an output from the Concatenate formula that is like this, $A5:$P5 It is dynamically generated with the input being two MATCH functions, i.e., <tbody>...

Hey everyone, This one might be hard to explain so please be patient with me. What I'm trying to do is create a formula that will go into a closed workbook, and calculate the amount of times the letter "P" is in column "N:N" in specific worksheets of that workbook. I have the name of the...

Hi all, I would like to create a master workbook, preferrably a spreadsheet, of the following: Part Number Quantity being quoted Price per quantity being quoted Supplier I would like to easily and visually see which supplier offers the lowest price per product as well as the quantity I must...

Attempting to match acct #s on source sheet with account numbers on Template but the numbers on the source are = to the cell value while the numbers on the template are equal to finding the source cell value in the template. Let me explain with code. Set Source value: Set FirstIO =...

I have a web query of stock quotes in one worksheet and I want to know how to continuously refresh its' contents. Does anyone have an idea as to how I can go about doing this?

Hello - I have, with the expert assistance from a user here, the following code. I need to, however strip the text file it creates of the " marks Excel has decided to add in before I close the file created. Does anyone know how to accomplish this by possibly adding a line of code in? I think I...

Hi, Just wondering what the easiest way to import a live, self refreshing stock quote would be. I want it to be just the quote ie 62.10 so that it can tidily fit into one little cell. Thanks

I've been looking around on the web for an answer to this quandary, but haven't been able to nail one down yet. Everyone says they get a #VALUE error, but I think I've figured out why that error happens. Just can't think of how to fix it. =VLOOKUP("Totals","'G:\Folder...

Hi i have a string like this ('hello'). How can i get the string inside the quotes ie hello?

Hi, I want to convert Excel file to CSV but Excel won't allow to add double quote in text data. So, I have to find a way on my own. I found a very useful code here http://www.ozgrid.com/forum/showthread.php?t=132763 by AAE (Thank you very much, AAE) However, the above code does not fulfill my...

Hi I need to develop a macro that extracts substrings from a string like: IF ‘lookup 1’ < 2008 AND ‘lookup 2’ <> 0 Then ‘lookup 3’ = 0 I am looking for values between quotes ‘ ’. The expected output will be sub strings: lookup 1 lookup 2 lookup 3 Thanks

VBA Novice Excel 2003 I've recorded a macro in Excel that retrieves accounting data. When recording the macro I select a specific Job number. The results are as follows: "WHERE (MASTER_JCM_JOB.Job= '08-007')" I would like to make the recorded Job number a variable that other users can...

Sorry, I couldn't find any post that has already answered this. I have a huge project where at different occassions I am querying an access database. A part of the query is a string that comes from a text box and can sometimes contain single quotes. For example: str = "Hell's right here." qry...

have an excel spreadsheet that I need to save as a CSV file to import into another application. For this other application, the values in the CSV file must be wrapped in quotes (which Excel does not do by default). So I need each row to look like this: "value 1", "value 2", "value 3" instead...