page

  1. M

    Return Duration

    I have a table of data that shows activity in relation to users web activity and I need to establish a time spent on each page for each user. My data has User name Time landed on the page Any Links clicked on the page As I have the time the user landed on the page via the link clicked I need...
  2. R

    power query to import data from web page that use login name

    I am trying to extract data from a web page through power query, new query using excel 2016 but unsuccessful as it requires to login to access the web page , Anyone knows a technique to achieve this.:confused::confused:
  3. M

    Pasting Book Page

    This macro should open up the file (Food room book 2), copy/paste the selected range into the SkutoSkutemplate and then close the page (Foodroom book 2). Range("A1:J810").Select Selection.Copy Windows("SkutoSkuTemplate1").Activate ActiveSheet.Paste...
  4. ACommandLineKindaGuy

    How to disable Page View buttons (Normal, Page Layout, Page Break View) next to Zoom on status bar

    Amazing how impossible it is to phrase this search on Google... I'm not interested in manipulating or viewing page breaks. All I want is to be in normal view. I am not interested in workarounds similar to attaching If ActiveWindow.View <> xlNormalView Then ActiveWindow.View = xlNormalView to...
  5. G

    Need to Upload a PDF into the Web page

    Hi , I m New to VB and I was struggling to the code for upload a PDF into the web page. I need to upload a PDF in (https://draftable.com/compare) in this website please help here and provide any code to upload a PDF using VBA. I have tried to upload PDF but getting error when "Choose File...
  6. C

    Printing in a workbook.

    Hello all, When I am trying to print, the pages contains too much white space and doesn't take up the entire page or have my data too small. Please advise what I can do. For the first tab, I am trying to print the data onto 3 pages(portrait) but there is too much white space. How can I have...
  7. D

    Make an image snap to a page

    I have a button that inserts a signature at the bottom of a sheet under the last row but if the rows are nearing the bottom of the page, the signature image will be pasted half on one page and half on the next page. Here is the code to paste a set signature and code to paste a custom signature...
  8. A

    Navigate and getting data from website

    Hi All, I am looking for VBA code where following steps areperformed: Open website https://www.abs.gov.au/Price-Indexes-and-Inflation Click on link “Consumer Price Index” on that page. Click on “Download” tab on that page. Open .Xls file from that page (do not save that file). Copy...
  9. M

    Center cash flow over the whole page print area

    Hi, Can someone explain to me how I can get my print area centered out over the whole page? Currently it leaves most of the page blank, but I want it to be spread out whilst keeping to fit the sheet on one page.
  10. D

    VBA Change Header Font Size and Text

    Greetings Can the below VBA string be modified to add the word "Date:" before the actual date, and change the font to Ariel 12 point bold? I'm using MS Office Professional 2013 and Windows 10 Enterprise. RightHeader = Format(Date, "dd-mmm-yy") & Chr(10) & "Page: &P of:&P" As an example, the...
  11. A

    VBA for copy and paste between worksheets

    Hi all, I have a worksheet that has multiple sheets of data, and i want to consolidate the data into 1 page of unique values. I have this code written but want to shorten it by using some loops for the copying and pasting. What my code does: 1) copies data from column "Project Name" and...
  12. I

    Linking two worksheets in word

    This is probably an easy one but, I have two excel 2003 worksheets in a single Microsoft Word doc.. Is there a way I can link them? Or at least a sum on one page to another? What I have is a long spreadsheet that I wish I could fit on one sheet but it is way to long. I had to put the information...
  13. D

    Adjust page breaks on multiple Sheets Excel 2013

    Seems our engineering friends at Microsoft are at it again. They love breaking things that work perfectly. I have a workbook with about 70 identical sheets. I wanted to print the same rows on each sheet. Well in the 2013 version you can no longer set the print area on multiple sheets. Fine, I...
  14. T

    Can I make my PDF look better?

    Hi Everyone, OK not come across this one before but heres what i need. I have a sheet with 3 different Ranges Range B2:F10 Range J7:T37 Range AA3:AT40 Now the problem im having is I want these ranges to be my Page sizes but when i print i get everything shrunk to match the width of Range...
  15. E

    Stop Excel hyperlinks from opening in a web page

    At some point, my hyperlinks (that use to open up in Excel) started opening up in a web page. I think this is due to a global change that IT made in at my company (not sure). I am looking for a setting to stop this from happening. I am using simple hyperlinks to open other Excel workbooks. I...
  16. N

    Print Visible Cells after Filtering

    When I try to print only the visible cells after filtering,it prints one row per page, instead of all on one page. If there is no filter on it prints correctlyall on one page. This is my code: FinalRow = Cells(Rows.Count, 3).End(xlUp).Row ActiveSheet.PageSetup.PrintArea = Range("C7:M" &...
  17. J

    Sending a workbook in Page Layout

    hey everyone, i need some help. I have finalized my workbook, each tab has one page per sheet in the workbook, i want to send this to my team however I want them to view these sheets as page layout view. my problem is i only want the active sheet in each tab and i can't get rid of any...
  18. P

    Linking an Excel Snag List to the Comments in a Word File

    Is it possible to link an Excel file to the comments being generated in a Word file? I have a situation at work where we have a Word document that is being used by several different people who are adding comments to it. One of the guys is using an Excel file to create a snag list of issues...
  19. G

    How do I copy and paste avoiding top line

    Hi I have a workbook that has approx 12,000 entries but im trying to copy and paste into a new workbook but avoid line 1. At present im having to highlight all the data from line 2 onward down the page and copy and paste into new workbook. Is there any easier way I can copy and paste...
  20. H

    Restarting page numbers part way through report

    Hi folks, We have a report which consists of 10 sheets. Several of the sheets may vary in the number of pages that print. For example sheet 4 in the series may print 1 or up to 5 pages (varies with each report). For example: Sheet 1 - 1 page Sheet 2 - 1 page Sheet 3 - 1 or 2 pages Sheet 4 - 1...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top