Vba To Create A New File From Spreadsheet
I have the following spreadsheet:
A-------------B
File No.-----PRODUCT TYPE
123456-----NDT
123456-----NDT
123456-----NDT
123456---------
123456---------
789110---------
789110---------
789110---------
What I need is if there is an NDT in Column B and 123456 in Column A then I need to eliminate all rows which contain 123456.
End result
A
789110
789110
789110
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
VBA To Create Word File And Add A Custom Property To It
I have an Excel sheet with a long list of data. A short example is shown below: Section | Title | Item 1 | INTRODUCTION | a 1.1 | title2 | b 1.2 | title3 | c 1.2.1 | title4 | d 1.2.2 | title5 | e I made a VBA macro in Excel that runs through this list and creates a new Word file for each item. The filename of the document is based on the data in the Excel file (section and title). Now I would like to add a custom property to each of the newly created Word files, i.e. the value in the 'item' column. Does anyone of you know how I should do this? Or should it be better if I write a macro in Word that runs through the Excel data to create the word files? Here is the code I use to generate the word files:
View Replies!
View Related
How To Create Buttons To Navigate Around A Spreadsheet
I was wondering how to create buttons such that when the user clicks on the button they are automatically taken to a different part of the workbook. I'd like to do this because my spreadsheet is now large enough such that navigating just using the sheet tabs at the bottom is not ideal. I can create a hyperlink, but I think a button just looks nicer.
View Replies!
View Related
Create A Spreadsheet In Which The Cell Will Tell How Many Hours, More Or Less
I'm trying to create a spreadsheet in which the cell will tell me how many hours, more or less, i have worked a week. Below is what I’m trying to create - but I'm having trouble. - if the total = 35 (in cell A1) then display -2 (in A3), - if the total = 36 (in cell A1) then display -1 (in A3), - if the total = 37 (in cell A1) then display 0 (in A3), - if the total = 38 (in cell A1) then display 1 (in A3), - if the total = 39 (in cell A1) then display 2 (in A3), etc (and so on)
View Replies!
View Related
Create Splash Screen With Filter Spreadsheet
i have a spreadsheet which i have attached, currently users have to filter each column to get the end result I would instead, like to create a screen where by they answer questions, for example. a drop down box where they choose flow rate, ie. 0-5l/min 6-10 l/min and so on for each option and then they end up with the list of choices which meet their criteria
View Replies!
View Related
Create Clone Copy Of Spreadsheet For A New Year
I have an Excel spreadsheet containing a large amount of formulas applicable to 2009. I want to create a duplicate workbook for 2010. I want to maintain all cell formatting, ie A1=sum(whatever) without retyping it all. When I attempt to use copy-and-paste (or paste special) from 2009 to 2010, the cell values maintain a reference to the 2009 workbook. For example on 2010 workbook, A1=[2009]sum(whatever). Therefore the values from 2009 print in cells. I only want to maintain cell formula formatting, not a reference back to 2009 workbook.
View Replies!
View Related
Convert Pdf File To Spreadsheet
Someone sent me a pdf file. It contains a list of items but the problem is I need to be able to copy and paste each item individually. I tried doing a google search to find a way to convert the PDF to a word doc but did not have any luck. So I think my only other alternative is to convert it to an excel (XLS) file. Does anyone know of a way to do this so that I can successfully copy and paste words from the document individually and not just wind up with an excel file with a picture of the PDF file in it?
View Replies!
View Related
Printing Spreadsheet Results To A Text File
What I want to be able to do now though, is somehow, when someone sends the document back to me, create an FTP queue. I can do this with BulletProof FTP, because it allows really simple text queues. So, what I need excel to do is, when someone has finished selecting their files, is write the results to a text file like exactly like this (without the Line1:, etc.): Line1: <text from D2> Line2: 0 Line3: 0 Line4: 0 Line5: ? Line6: <text from E2> (then repeated for each row in the excel document until column A is returning blank)
View Replies!
View Related
Search For A File And Bring Back Data To Master Spreadsheet
To set up the problem, I have a folder that contains files that are all named numerically, ex. 08-100, 08-101, etc. Each file is identical in format but contains different data, ex. cell B1 is alway "material weight", cell B2 is always "estimated man hours" and new files are added weekly. I am trying to set up a master spreadsheet that all I have to do is enter the file name (08-102) in the first column, and the second column will return the data in a specific cell of that file.
View Replies!
View Related
Create A File
Here I am Attachiching a MHTML file which has multilayer in the left panel. If You Open it in excel u can edit it and navigate through the layers. I want to know can I create an excel file like this one. http://rapidshare.com/files/235065073/howto.MHTML.html OR http://www.2shared.com/file/5865199/84c1fea5/howto.html (sorry excel forum is not accepting mhtml file for attachment)
View Replies!
View Related
Using VBA To Create VBA Code On The Fly
I have a vba module that reads a value from a txt file and saves that value in a variable called "iniInfo". I want to permanently assign that value programatically by using VBA code to create a Public variable e.g. "PUBLIC CONST conFIg = iniInfo" in my modGlobalVar Module. (Of course, this would only create the code if the "conFig" variable doesn't already exist.)
View Replies!
View Related
Convert Text Delimited File To .xls File Using Vba
how to word it but if someone understands then please help. I have two excel data files namely Book1.xls & Book2.xls. Both files have different data in it. Both files contain macros. When these macros run the files become **FINALIZED** version. Originally, I get the above files in my email as txt. attachments. I then move these two txt files to my desktop in a folder called Folder-1. Then I open these files as an Excel and save them. Basically, I need to know if two txt files are sitting in a folder-1 on my desktop. What can I do or what can I clik that....those two text files get converted into excel automatically, including running that macro I talked about in the above paragrah. To put it differently, if I have two txt files Book1.txt, Book2.txt in a folder, how can I automatically create an excel **FINALIZED**version which sits right next to their txt version.
View Replies!
View Related
Create New File In Windows
I am looking for the best way to create a new file in windows. I am just looking to create a save filename template. After I run a macro, a graph is created and printed to pdf. I want this macro to create a filename, so that when the save as dialog box opens, I just have to doubleclick the existing filename. Then I save the excel workbook as another. For example, after I run the macro, the pdf printer will open up a save as dialog to c: emp. I want to have this macro create two files there, one DaveGraph.PDF and one DaveExcel.xls. They really won't be files, just names. They can be 0kb files. I want it to be as efficient as possible. I know I could create a new workbook and save it there with the correct name, but isn't there an easier way?
View Replies!
View Related
Create A Separate File After Macro Done
How can I code to create a copy of a worksheet in an excel file I am using a macro on, after the macro is done processing? In other words, when the macro completes processing, create a copy of the worksheet labelled "Output", and save it in a directory that the user chooses? Also, would it be possible to create a .pdf file?
View Replies!
View Related
Create A Shortcut To A File, Not Hyperlink
How can I change the text color within a cell when I am using a concatenation formula? I have the following formula; =" Total Bonus Earned ("&TEXT(A2/VLOOKUP($A$1,PR_DB,2,False),"#0.0%")&" of 2006 Earnings):" In the text function portion I would like to format the result in red. An example of the result of my formula I am seeking is as follows; Total Bonus Earned (10% of 2006 Earnings): Do I need to create a custom format and if so how do I call it up within the text function?
View Replies!
View Related
Vba On Shared Spreadsheet
I have a 4 MB Excel file containing some very basic VBA that is shared on a server (it is a large file because it contains LOTS of "VLOOKUP" functions). But the VBA only works a part of the time. I assume the reason it might not work is because the server at that time was under high traffic and thus the VBA failures can be traced to poor server performance at that time.
View Replies!
View Related
Create Input Box / Save File As
I am looking for some macro code to create an Input box which will prompt the user to enter a specific date (not todays date so NOW function is not appropriate). This will in turn cause the file to be saved in a specific folder with the date becoming the name of the saved file.
View Replies!
View Related
Macro To Create New Folder And Save File
I want to create a macro that will create a new folder called "Fungicide Quotes" under my documents and will save the workbook using the cell reference d4:f4 for the file name, which are merged cells. I have tried the following but can't get it to work. Any help would be appreciated, Thanks Sub Save_wrkbk() Dim strFilename, strDirname, strPathname, strDefpath As String On Error Resume Next strDirname = "Fungicide Quotes" strFilename = Range("d4:f4").Value strDefpath = "C:My Documents" If IsEmpty(Filename) Then Exit Sub MkDir strDefpath & strDirname strPathname = strDefpath & strDirname & "" & strFilename.......................
View Replies!
View Related
Fixing Macro: Only Create Around 53 Text File
First need to create a "Text" Folder in your desktop, then try running the macro. It will create a number of text files inside the "Text" folder.. And they contain the used cells from each row. It's supposed to create 982 text files, with the text name referred to the first column. Problem is, if you try running it, it will only create around 53 text file
View Replies!
View Related
Create A Border Macro When Open The File
I have recorded a macro which will create the border for me when the file is opened, but it turned out too long. if someone can show me how to reduce the codeing. I have the attached file. Range A5 to E20 thin Border all sides and thick border allround (16 rows) Range A21 to E36 thin border all sides and thick border allround (16 rows) end range is A356.
View Replies!
View Related
Custom Macro To Create New File From Data
I'm looking to create a new file from data in my table. I don't want to even imagine having to do this manually again...I'm optimistic there is a solution. All the data needed to create the file is in the table, but i need it stacked and organized in a weird way. It's almost to hard to explain...so I color coded an attachement that basically says it all. It's pretty much the same thing repeated over and over except the last 2 lines. It's just a really messed up organization. In the real version I need the new file in a new workbook. I'm extremely grateful to anyone who can automate this thing
View Replies!
View Related
Create Custom Menus For Specific File
I tried to create a custom menu for a specific file. However, after creating the menu, I posted the file in Sharepoint. When a user download the file from the sharepoint site, the custom menu doesn't work because it is looking for the macro links from my computer. Another problem is that now the custom menu shows up in all other excel files that I open. My questions are: 1. How do I do it so that the custom menu shows up only when this file is opened up. 2. How do I go about making the menu to look for the macros embeded in the file itself instead of looking for it in my file folder.
View Replies!
View Related
Create New File With Data From Database Through A Template
I've been looking around to find a solution for my problem and as a last resort I have decided to make a post, and I will get straight to the point. I have 3 xl Files of relevance: 1 - is my "database" which consists of multiple sheets with different information in each. Each sheet is correlated with each other by one common ID. 2 - is my "template" which is 2 sheets, which functions as a report. The template serves as the Report which will be printed. The data from each row from the database can fill the spaces in the template. 3 - "the tool" xl file is where i have my macros and the mapping for the which columns from the database belong to which cells in the template. Basically what I'm trying to get to work is: User opens Tool clicks "create Reports" and the tool should then open the database, pick the range of rows from the database put the data into the relevant cell in the template save the "template" with the info on it, close it and do it again with each row of data from the database. So if I pick rows 4 to 34 in my tool, it should create 30 xls files from the template and fill in the data from each row into each newly generated "report".
View Replies!
View Related
Vba: Transfer Spreadsheet Method
Im trying to use the transferspreadsheet method to load some data in an access table, but using my current code, it gives me an error, saying that the file is already opened by another user, or that i need permission to view it. that it is open, is true, since I'm loading from that spreadsheet. this is the code I have now: Sub LoadSheet() Dim accappl As Access.Application Dim strpathdb As String Dim strpathxls As String Dim myrange As Range Set myrange = Range("a32").CurrentRegion 'path van de database strpathdb = "X:credepSTRAT_PLANStratPlan.mdb" 'path van de upload file strpathxls = ActiveWorkbook.FullName Set accappl = New Access.Application accappl.OpenCurrentDatabase strpathdb DoCmd.TransferSpreadsheet acImport, 3, "Tbl_Growth_Metric", strpathxls, False, "myrange"
View Replies!
View Related
Spreadsheet That Incorporates A VBA Calendar
I have been trying to complete a excel spreadsheet that incorporates a VBA calendar. You will know the sort of thing that I mean, the user clicks on a cell and a calendar appears then the user clicks a date and the date is added to the active cell. The reason why I have to do this in VBA is because the finished file is going to be stored on my works server and it doesn't have the calendar activex add-in installed. Well I have made a little progress. However, I have now become stuck. the link below will give you the file that I got so far. If you extract the file then click on cell A1 a calendar will appear. However, you will see that when you try to change the month it is stuck on January and I do not know how to cure the problem. I should add that the code that is written within this spreadsheet was not written by me. It was originally written by another person whom I am no longer able to contact. Unfortunately my knowledge of VBA is not that of the original author.
View Replies!
View Related
Search Path & Create Hyperlink To File
I'm trying to add code that create a hyperlink to a file in a recently created folder in the path of L:Elec Dept ProjectsRELEASED FOR CONSTRUCTION". The code below should find the newly created *BOM*.xls created and created a hyperlink in the next available row starting on row 27 and column O on my worksheet "BOM". The code currently runs with no errors, but I'm not seeing any resulting text with path / links created.
View Replies!
View Related
Create File List But Only Show Filename As Link
This link worked perfect for my needs: Create a List of Hyperlinked Files: But is there any easy way to only show the filename insted of the full path for the name of the hyperlink? Now it shows it like :C:MyDocumentsTestings est1.xls I only want it to show as: test1. I still want the hyperlink to work
View Replies!
View Related
Create Links To Multiple Csv File In The Same Workbook
My first post at last. I've recorded a Get External Data macro and wish to modify source and destination components. I would like to replace the absolute link to the file name with a variable and the Destination range to the active cell at the time I run the macro. This is the is the macro code line that handles the source and destination components I want to modify. Range("AQ2").Select With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;C:filename.csv", Destination:=Range("AQ2"))
View Replies!
View Related
VBA Macro To Move Shape Around Spreadsheet
I am trying to write a set of code, part of which involves moving a shape around an excel spreadsheet in a square shape within a certain range. It is based on a random number generator. The shape moves a number of cells to the left/right/up/down depending on the random number (d) multiplied by 16. If the shape reaches a row or column border point, it will change direction but continue moving in the new direction until it has gone as far as was determined by the random number (*16). I have some code which works fine... to a point! The shape starts out, reaches a right hand border, changes direction to go up, reaches another border, changes again and goes left, but then when it comes to change dorection the 3rd time and go down, it fails. The direction of the shape is determined by a word in cell A1 - left/right/up/down: Sub MoveRed() Application. ScreenUpdating = True Dim d As Integer Dim i As Integer d = Range("AZ1").Value With ActiveSheet.Shapes("RedDot") For i = 1 To 16 * d Select Case Range("A1").Value '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
View Replies!
View Related
VBA Stuff- Weight Watcher Spreadsheet
I have a Weight Watcher spreadsheet. I enter the Calories, Fat and Fiber and I get the # of points for that food. Then I keep put those points into the lower part of the spreadsheet where I track what I eat, and Excel does my simple math for me. What I want to do is keep a list of my foods, and their point value in my spreadsheet. I would like to be able to put the food name in Cell A1, the WW points in BI, and then be able to click a button with a macro that takes those two pieces of data and add them to bottom of my food list. I don't have a food list yet, I would assume I can just put it on sheet 2. I then want to be able to use lists in my cells to choose the food in the future. I need to be reminded how to make "dynamic named ranges. Today, I just need to know how to write the macro to copy and paste those two cells in the first open row at the bottom of my food list.
View Replies!
View Related
Adjusting VBA Code From A Spreadsheet List
below is some code from a spreadsheet I am working on,,,,,, as you can see it adds items to a dropdown list in a combo box. This may require an update at another time,,,,, is it possible for the list to be updated from a list in the spreadsheet, therfore preventing people from accessing the code
View Replies!
View Related
Create & Save Workbook To Same Path As Macro File
I have code to create a new workbook, and when I try to rename it I get "Compile error: Can't assign to read-only property." Dim objXlApp As Object Dim wkb As Workbook Dim wks As Worksheet Set objXlApp = CreateObject("Excel.Application") ' Create a workbook Set wkb = objXlApp.Workbooks.Add ' Delete all worksheets bar the first one. For Each wks In wkb.Worksheets If Not wks.Index = 1 Then wks.Delete End If Next wks 'Create some worksheets and names With wkb .Worksheets(1).Name = "myWorksheet1" .Worksheets.Add.Name = "myWorksheet2" .Worksheets.Add.Name = "myWorksheet3" .Worksheets.Add.Name = "myWorksheet4" End With...................................
View Replies!
View Related
Vba To Isolate Items In Spreadsheet And Compose A List
I have the following spreadsheet: A----------- B----------------- C Invoice------ Product Code------Classification 82001733----LX+150SVL0044----9010.90.9000 -------------SE+68763001-------8501.31.4000 -------------GJ+10005----------- -------------SE+59163-----------8504.40.9580 -------------EB+98575----------- -------------KF+MX09300--------9010.90.9000 I'd like to extract the rows with blank cells in Column C and product codes in Column B and create a list of product codes which don't have classifications on a separate list. This new list would need the ability to be revised as other codes will be added once a macro is run.
View Replies!
View Related
#NAME- Error Results When Writing Formula To Spreadsheet From VBA
When I am writing a formula that includes a lookup, it returns the # NAME? error in the spreadsheet. If I delete the trailing ), retype it, and hit enter then the formula returns the correct value. How do I get the formula to work correctly as it is written to the sheet from VBA! Here's the line of code that writes the formula to the worksheet: TBox.Range("A3").Offset(i, 3).FormulaR1C1 = "= ROUNDUP((8-(VLOOKUP(RC[-3],K:L,2,FALSE)/1.2))/RC[-1]*1.2,0)"
View Replies!
View Related
Disable The Vba In A File Being Opened Using Vba
I have excel vba code to open .xls files on my server. Files to open are chosen by the user via a UserForm within my app, it shows them all their files in their directory on my server. How can I open their files (.xls) that they select but DISABLE the VBA from being able to run/execute, if they have any attched to the file? I now have all code in place to open the file no problem, I just need to know how to disable the VBA part from being "turned on" when the file opens.
View Replies!
View Related
|
TRACKER
