doc

  1. NdNoviceHlp

    Show Word doc in XL userform frame

    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...
  2. T

    Best way to run a macro on every xlsx file in document?

    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...
  3. A

    Select from Drop down list in Internet Page

    ı 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...
  4. P

    Automation Runtime error with "InternetExplorerMedium"

    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...
  5. R

    VBA to follow hyperlinks to different files and save in alt folder

    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...
  6. D

    VBA code that copies workbook and saves it locking in current form progess

    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...
  7. M

    Find Duplicates question

    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...
  8. J

    extract a span value from webpage

    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>...
  9. P

    When I step through, it works. When I run the macro, it doesn't

    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...
  10. P

    Copying from a pick list- creating duplicates on the final output list

    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...
  11. I

    Open word doc from user form button

    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...
  12. P

    Circumventing duplicate value in column issue

    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...
  13. B

    Need Code For Popup Window Stating Email Was Sent (VBA)

    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()...
  14. C

    Ideas for timetable

    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...
  15. R

    VBA question - new doc in subfolder

    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...
  16. R

    Export 3 Access Reports to 1 Excel Doc - Cmd Button

    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...
  17. N

    Can Excel COPY DATE Values from one cell to another in MMDDYEAR format

    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...
  18. J

    Excel Co-authoring issues

    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).
  19. J

    Extracting Data from Excel into Word

    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...
  20. A

    Need help in sort and display best lap time and best 2nd laptime

    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've detected that you are using an adblocker.

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.
Go back
Back
Top