My objective is to present a quick view of stored Word documents within an XL userform frame (a userfom listbox would contain the file names and a selection would display the doc within the userform frame). Not quite there yet. The following XL code copies the contents of the Word doc, pastes it...
Hi Everyone,
I was hoping someone could help me.
I need a macro that can got to a folder
FOLDER_PATH = "F:\MY Docs1\New1\Run New Project\Data 1 sheets"
and open every xlsx doc only then run a macro call "repair1" then close and save
any ideas the best way to do this bearing in mind the folder...
ı am new vba and here. I am working on stocks and ı need your helps. so firstly as you can see on tittle, ı want to choose automaticly in down list what i write on my excel. So ı need amortization information from this web site website in "MALİ TABLOLAR"page amortization in turkish is amortisman...
Alright folks,
I'm trying to set up a file that pulls up a company Intranet via IE, fills in a few fields and then hits "go" to populate a list. It's triggering an "automation" runtime reror because of the Set doc = IE.document line (Line 7) and I suspect is has something to do with...
I have a workbook with a column of 1000+ hyperlinks that link to numerous files of different types in numerous different folder locations on one drive and I want to automate the process of saving those documents to one folder location using the adjacent cell as the file name. There will be a mix...
Hello all -
I have a workbook that wipes clean radio buttons and input cells upon reopen. I would like a macro I could assign to a button that copies the workbook SAVING form progress to said point and allows me to SAVE AS a new doc and doc name... Without disrupting original doc or original...
Hello,
I have 2 docs that have phone numbers and I believe most of the numbers in doc 2, are in doc 2. So this is what I'm trying to find out.
I want to put all phone numbers from doc 1 in Column A and all numbers for doc 2 in column B and I would like excel to find duplicates. Now here is the...
Hi, I am trying to extract the date into excel using VBA but getting stuck...any help would be appreciated
This is the relevant extract from the web page
<div>
<div class="daysTips">
<span>
"Start Date"
": "
"2018-08-24"
</span>
<span>...</span>...
This macro is supposed to place an "x" in column z once a row has been copied and pasted, so that I can add items to the list without re-adding all the items on the list. When I step through the code, I watch the x get placed in column Z. But for some reason, when I run it from the button on the...
I have some code working right now where there are 2 master lists of documents that may be needed in a file. The user goes through and puts an "x" next to the documents they want.
The code is doing what it is supposed to,... it copies any document with an x next to it, and moves it to the...
Hi all,
I have a user form which has various text boxes containing info.
One text box relates to a word doc receipt as just a basic number system.
Is there a code we can use to apply to a button on the user form that would then look at a specific text box and open its relevant word doc receipt...
I have a large database in Access with document names and parts that the documents contain. The lay-out is something like:
doc 1, part 1
doc 1, part 2
doc 1, part 3
doc 2, part 4
doc 2, part 5
doc 3, part 6
etc
In Excel I have another table with the document name. My goal is to link the table...
Hello,
I use the following code to automatically email a spreadsheet when a button is clicked on the sheet. The issue is that I cannot figure out how to have a popup window show up stating "Thank you. Your status update has been submitted.". Can anyone help?
Private Sub CommandButton3_Click()...
hello
I'm looking for ideas for a weekly timetable to my company.
timetable is edited every week, there are 5 workers, each one of them has own line colour, I made a hourly grid where his colour showed his avaliability but in my opinion it becomes chaotic.
Next, filled in colours table goes...
Hi,
Do you know how to create a new word doc under the subfolder in NewR folder? This is what I have so far. I was able to create a subfolder under NewR folder, but is currently trying to create a word doc in the subfolder. Any help will be appreciated. thanks
Option Explicit
Private Sub...
So currently, I have 3 command buttons with the following code;
Private Sub Command368_Click()
DoCmd.OutputTo acOutputReport, "Visit Report By PMCC", acFormatXLS, "c:\Exports\Visit Report by PMCC.xls", True
End Sub
Is it possible to export 3 reports into 1 excel doc and have each report in a...
Is there an IF formula that stipulates if cell A contains the word "DOC" then Cell C will populate the date in MMDDYEAR format? Also if there are additional instances of the date being used it would need to add 01, 02, etc. after the date. Thanks!
<tbody>
Type
Date
ID
DOC
4/11/18
04112018...
Hi,
I've set up a spreadsheet to be co-authored but some users are saying there are issues when other users freeze panes in the shared doc. Is there a way around this? (Aside from saying don't freeze panes).
Hello,
I have an excel file has 90 plus rows of data with each row having data for one country. I need to update a word doc (report) with some columns of data from the excel file (Eg. col. A, Col C, Col E). The data is in text, numbers, percentage format. Once the doc is updated I need to save...
hello, I need help in sorting lap time for school event (sport day) and display it automatically after the time been insert in the sheet. I'm sorry I don't know how to attach my excel here but here are my google doc link for the excel book...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.