Creating PDF File From Word Document Inside Folder With ID Number And Reference Number?
Jul 31, 2014
I have an excel database where I register cases. I have in it a button that creates a folder with and ID nr that is in column A (I create new ID nr in the next row, when I press the button it will create a folder with that ID nr and inserts a blank word document in it). We have a template that we copy to the folder (depending what type of case). The idea would be that once the template is filled in and ready to print, It would take the values from the ID nr and a reference number a few cells to the right. Is it possible to tell excel to open the word document in the folder and create a PDF version with the ID nr and reference number. (there are only 2 templates, so the macro would have to look for one of the two in the folder) The names of the templates are: "Standard" and "Other". I guess the best way to start maybe this would be that I select the cell with the ID nr and then press a macro button to have this done. One thing that needs to be done, is to put a copy in the same folder and another in a second folder called "Binder" in my documents folder.
View 1 Replies
ADVERTISEMENT
Jul 31, 2014
I have an excel database where I register cases. I have in it a button that creates a folder with and ID nr that is in column A (I create new ID nr in the next row, when I press the button it will create a folder with that ID nr and inserts a blank word document in it). We have a template that we copy to the folder (depending what type of case). The idea would be that once the template is filled in and ready to print, It would take the values from the ID nr and a reference number a few cells to the right. Is it possible to tell excel to open the word document in the folder and create a PDF version with the ID nr and reference number. (there are only 2 templates, so the macro would have to look for one of the two in the folder)
The name of the templates are: "Standard" and "Other".
I guess the best way to start maybe this would be that I select the cell with the ID nr and then press a macro button to have this done.
One thing that needs to be done, is to put a copy in the same folder and another in a second folder called "Binder" in my documents folder.
View 1 Replies
View Related
May 31, 2014
I'm trying to copy the content of a word document (File A) to another (File B) using Excel VBA. File A has about 100's of pages (not sure of the number as it varies) and this needs to be split to different files, each having 15 Pages.
Below is my code, where I'm able to select the content of the first Page and paste it in the target folder, but not sure how to determine the number of pages in word using excel VBA.
Note: Copying the content should be done, page wise only.
[Code] .....
View 1 Replies
View Related
May 18, 2006
I am working on a project where I am creating analysis using a subroutine in excel/vba and I would like to have the subroutine generate a report that is a word document. I have never used excel/vba to create and modify a word document and don't know how to approach it. I imagine that I will have a template.doc that I can access and save as another file. Does anyone have an example of creating and modify a word document in this manner.
View 2 Replies
View Related
Feb 6, 2014
I am running an ordering sheet that I need to attach reference numbers to, no format for the reference number has been determined.as yet. I need this reference number to change when the 5 digit number changes, see example attached.
Capture.jpg
View 11 Replies
View Related
Dec 22, 2009
I need a macro which checks for next available number from list of filenames in a folder. Then it returns that value to one predefined cell in a new document (here Untitled.xls). For example:
c: est
has the following files:
Untitled.xls - read only
abc-09-001.xls
abc-09-002.xls
abc-09-003.xls
abc-09-004.xls
Next available filename should be "abc-09-005" and macro returns that value to predefined cell in a new document (Untitled.xls). There should be NO saving at this point whatsoever. Macro simply picks the next value from a filelist. As you've noticed the value has some constants too. New document doesn't know the last picked value before macro is active (predefined cell should be empty at startup).
View 6 Replies
View Related
Jan 29, 2009
I would like to attach a pdf (or word) file inside an Excel sheet so that it is seen as a pdf icon or word icon when viewing the sheet. Any of you who knows if this is possible and how to do it?
View 2 Replies
View Related
Mar 14, 2014
Our client uses an Excel spreadsheet that we provide to adjudicate/comment on our delivered products (primarily documents and reports). The spreadsheet has columns for:
DefectCode, SectionPage, Comment, FinalDisposition, FinalComment.
At the end of the process of client meetings and revisions, we must generate an MS Word-formatted report. I've written a macro to parse the comments and columns and generate a mostly-formatted Word document. What's missing are the corporate headers, footers, logos -- the standard template or basic document stuff that all of the details would fill in. For now, I auto-gen a Word document and merge it by hand into the corporate template.
So my question is: if I want to "include" a corporate Word template with the spreadsheet, can I bundle it with the workbook somehow or must it always remain a separate file?
My current thinking is that since a *.xlsm file is really a ZIP file underneath, could I store the Word template there where it would effectively be hidden from the user? Or what is the best way to bundle an extra file like this with my workbook app?
View 2 Replies
View Related
Jan 23, 2009
I have recorded some script in excel to import a *.dat file, delete the first 19 rows of data, then export the data as a *.csv file.
My problem is I have circa 30 *.dat files to import, all of which have large file names and I am fed up with copying and pasting them in.
So my question is, in the below code, can I somehow use a reference at the start such as:
abc1.dat = "1"
abc2.dat = "2"
Then where the files were used, reference the "1".dat and its exported version "1".csv for the abc1.dat case.
View 10 Replies
View Related
Jun 3, 2014
I have on the first tab a screen where you can fill in the name of the .doc or .pdf file.
That works fine, but now I would like that when I fill in a number and click on test, it opens te .doc and .pdf file that is attached for that number.
If you take a look at the pdf file you will see a second and a third tab.
First column is the number they need to fill in and the second column is the name of the .doc or .pdf that needs to be opened with that specific number.
How to link it and open both files for that specific number.
But not every number has a .doc as well as a .pdf.
View 5 Replies
View Related
Apr 23, 2014
Just striving to have this kind of "picture arrangement's macro" to work, macro that whenever you choose a certain cell and operate it on hotkey it'll:
1. Create a new folder named "PicturesAuto" beside the excel file (wherever the excel file located).
2. Inside folder "picturesAuto it'll create a new subfolder named by the same name of the sheet related to that cell you operated the macro upon. (let's say this cell placed on sheet named: "happysheet"- that'll be the name of the subfolder created.)
3. Inside the subfolder "happysheet" it'll create a new subfolder named by the text of the cell you activated the macro upon (let's say you initially operated the macro on B5 cell -which has the text "montana" so it'll create "montana" subfolder also inside subfolder "happysheet")
4. Lastly instead of having only the text "montana" in "B5 cell" like we had initially before activating the macro, the macro'll also add to that text "montana" the link to "montana" folder (path of excel file->picturesAuto->happysheet->montana)
The way I'm planning to use this is to add a lot of HR pictures inside those folders created by the macro that related to that specific sheet, and that specific cell I've activated the macro upon. Plus just having those pictures so organized is just outstanding in every scale, and the excel file will keep running smoothly without any resource consuming overload.
View 7 Replies
View Related
May 26, 2006
I have an excel program that is supposed to count word instances in a word document. I can't seem to find the right declaration for a word document.
For example to declare a workbook in excel its
Dim wb As Work Book
I've tried
Dim doc As Word.Document
'or
Dim doc As Word.Application
as shown in some of the forum posts, but an error user-type not defined keeps displaying.
View 2 Replies
View Related
May 22, 2013
I know about
(isnumber(match({,12054, 12056, 12058}).....
How could I express a range of numbers to identify 12054-13001. How would that expression be written?
View 5 Replies
View Related
Nov 13, 2007
Each cell below contain a number and a time + ET. if like say i want to delete the time + ET and leave only the number inside all cell.
1.1425 8:20pm ET ON A1
3.0805 6:10pm ET ON A2
814.30 6:42am ET ON A3
798.70 11:27am ET ON A4
380.00 9:10pm ET ON A5
View 9 Replies
View Related
Jul 6, 2009
Is it possible to export Excel cell contents to Word fields in a protected Word document? For example...
What code would be needed to tell Excel to open up, copy and export the contents of A2 in the active sheet of a workbook to "Field 2" in a Word document named "Report 01" and then put the contents of B2 to "Field 2" etc?
Do both applications have to be opened up at the same time or is Excel able to open up Word on its own? Will the macro be able to....
1. Automatically open up the correct Word document?
2. Look ONLY in a certain folder for the "Report 01" Word document?
or
Bring up a "selection" box that allows you to select the document you wish Excel to export it's data to?
3. Close and save the Word Document without any user intervention?
View 2 Replies
View Related
Jun 9, 2009
Have problems using find and the Dictionary
What Im trying to do is find a certain word in a string then return the number associated with that word
View 7 Replies
View Related
Feb 2, 2014
I am processing a fair few Invoices, which are being sent to me via e-mail as excel documents, very often they contain mistakes, a decent amount of mistakes. Usually the prices are wrong.
I keep track of every single entry on the invoice on my own document - Tracker, which I consider to be the superior/more correct document to the Invoice presented to me by my contractor.
Both of the documents have a reference number, which is a specific docket number, and horizontally, in the invoice, there is going to be a price for this docket. In my document, there is going to be a separate column for the total price.
Is it possible (I guess with VBA) to check for mistakes in the Invoice, but use the Tracker as a reference for this check.
Tracker has
columns
A - Name
B - Department
C - Date
D - Docket No.
C - Total price for the docket (calculation of E to Z)
E to Z - all smaller entries
Invoice has
columns
A - Date
B - Docket No.
C to E price for that docket, but it is spread, because departments are separated out, so each VAT account can be charged accordingly. I guess it is possible to do a separate column for the price, if it is easier to do a script that way.
Basically, I need to check if in the Invoice document, the price (C to E) for Docket No. (B) is the same as the price (C) for the Docket No. (D) in the Tracker.
I would like the wrong entries to be highlighted on the Invoice Document, so I can see straight away, that this needs attention.
Not always the price is wrong, sometimes the Docket No. is spelled incorrectly (Dyslexic contractor), hence the highlighting.
View 3 Replies
View Related
Feb 7, 2014
How do I change a Positive number into a Negative number inside a cell formula?
I have a figure in Cell AE 101 which has the positive number 141
I have another cell W1 which has the positive number of 437
I want to create a formula in cell X1 that takes the number in cell AE 101 of 141 and convert the number inside the formula of 141 into a negative number of -141 and then subtracts that number from Cell W1 of 437 leaving an equation inside the formula to read. 437-141 = 296
Since the number in Cell W1 changes all the time and the number in AE101 Changes all the time the new formulated number in X1 will change all the time too as the cells get updated.
View 6 Replies
View Related
Feb 13, 2014
I have made a Excel base "Application form".....it is a master copy.
I want to send a copy to a client....which has a unique serial / code number e.g. IF/001/2014.....
Presently, I am doing it manually, as application send to many clients...it become a hectic job to remember / note down the serial number....
I am trying to use a "Active X control" button to generate the desired serial number.....
There may be five categories.... IF, IA, OGG, WC, TU respectively.
I want five button to perform this job....
View 2 Replies
View Related
Jun 12, 2008
I'm trying take a reference from some workbooks (e.g. WB1.xls,WB2.xls,WB3.xls,...etc)
They are all placed in one folder but there filename is subject to change,
I need to get the result of Cells A1 from WB1.xls+A1 from WB2.xls + A1 from WB3...etc
to shown on AA1 in another workbook(e.g. Collected.XLS)
Is this possible knowing that workbooks filenames are changeable?
Moreover Can the value of A1 from any new workbook added to the same folder be added automatically?...
Can the formula typed in AA1 from Collected.xls be draged down?(So as to show the sum of Cells B1 and C1.....etc) from each workbook?
View 9 Replies
View Related
Apr 15, 2014
Is it risky for someone to edit an excel document while it is still in the flashdisk or external hard disk? I was told that this habit can lead to loss of data or the data can be affected if someone does this. I was told that I have to copy/cut paste the document onto my desktop, edit/ work on it then move it back to the storage device. Is all that work necessary, or can I simply work on the document while it is still in the flashdisk or external hard disk..
View 6 Replies
View Related
Jan 17, 2010
I want to switch on Caps & Number lock on opening an Excel document. I'm using the following code;
View 10 Replies
View Related
May 28, 2009
Is there a way that I could monitor the number of files in a folder and its contents (including subfolders)?
Folder A: (total count of files)
Subfolder
Folder A.1 no. of files containing boy
Folder A.2 no. of files containing girl
Folder A.3 no. of files containing boys and girls
View 11 Replies
View Related
Mar 7, 2014
The code below is sending back an error. It's supposed to create a folder and a subfolder within it and if the folder already exists then a msg box should pop up saying that folder already exists.
[Code] ....
View 14 Replies
View Related
Nov 7, 2008
I am creating a review sheet/skill matrix using excel and need to be able to convert a particular selection to a number in the adjacent cell to work out the users efficiency (long story that i wont bore you with)
So basically i have a question/statement in cell A and a drop down answer menu in cell B containing up to 5 possible answers (very poor, poor, ok, good, very good). In cell C i would like to insert a formula that allocates a number dependant on the selection in cell B. So if the user selects very poor in cell B cell C states 1, if cell B has poor selected then cell C states 2 etc etc
View 4 Replies
View Related
Jun 5, 2013
I am trying to create a spreadsheet to keep track of an online racing league that I'm in. I have created columns for the racers, and rows for the races. What I would like to do is type in 1st, and it represent the number 13 for when I do an autosum at the bottom of that column. It would be easier for me to type in the position place, instead of the points value. The position place will always carry the name numeric value. Here is what I have so far:
Start & Park Season 1.xlsm
View 14 Replies
View Related
Dec 31, 2008
I have used this formula to get the last value in a column:
=LOOKUP(9.99999999999999E+307,Items!A:A)
That seems to be the most elegant formula that I have seen at this Message Board.
But what about the most elegant formula to get the last word or value or error or TRUE/FALSE in a column?
I have used this formula (entering it with Ctrl + Shift + Enter):
{=OFFSET(Items!A1,MAX(ROW(Items!A:A)*(Items!A:A""))-1,0)}
How many of you know other more elegant or efficient formulas?
View 9 Replies
View Related
Jan 23, 2009
a method of accessing all files within a folder to get the number of rows/records and contents of "A2".
The file could ideally look at the current folder it's in and collect the requested data.
Hopefully I can work and develop the code to suit.
View 10 Replies
View Related
Aug 24, 2013
Is there a way to rename every file in a folder and subsequent sub-folders to begin with a number in memory? Say my number in memory is 5000, I'd like all the files to be renamed something like this:
5000Picture.jpg
5000bookreview.txt
5000startmanual.img
5000HighFive.mov
-->5000SUBFOLDER01
----->5000SUBFOLDER02
View 1 Replies
View Related
May 14, 2014
I have a column with codes coming after a # symbol and want to extract just the code from the cell. The code could be 2 or 4 characters in length. Some examples:
#AA abcdef
From this I would want the formula to return #AA.
#ABCD qwerty
From this, I would want the formula to return #ABCD.
The #Code should but may not always be the first word in the cell, so it needs to find the # symbol and then take the next x characters until a space is found. Note that the reason code may be the only text in the field, so a space may not be there at all. For instance,
#RR
Should just return the #RR.
Edit: This actually has become more complex now. The cell could be
#AA{text}
And for that, I would just want the #AA.
The formula would need to begin at the # and return just the next x capital letters.
View 9 Replies
View Related
