dcsimg

Search:

Type: Posts; User: mrwad

Search: Search took 0.15 seconds.

  1. Re: Get Google Maps XML data, parse it and input to Excel cells

    Here is the loop, but can't figure out how to make hours and min display correct in Excel point of view. Replace just makes 3 hours 2 mins -> 3,2 however to be correct it is 3,02. Also it converts 29...
  2. Get Google Maps XML data, parse it and input to Excel cells

    I managed to get a working solution for getting Google Maps XML data, parsing it and inputting to Excel cells. However my next intention get it working for several requests when there are 5 different...
  3. Re: Web scraping in web browser in UserForm

    This issue was solved by adding:


    While .Busy
    DoEvents
    Wend
    While .ReadyState <> 4
    DoEvents
    Wend
  4. [RESOLVED] Web scraping in web browser in UserForm

    I have web browser in UserForm and would like to automate the procedure for button in UserForm. So once user clicks button on UserForm with browser window code should do web scraping. This works if...
  5. Excel UserForm size related to screen scaling

    Is there any way to scale UserForm according to screen scaling?

    168707

    This code works for screen resolution, but it does not recognize screen scaling:



    With Me
    ...
  6. Replies
    1
    Views
    253

    Dynamic range for hiding rows

    I have workbook where I have buttons for hiding and unhiding rows. So when rows are hided one button is also hided and then vise versa. Then I have range that should be hided and unhided while...
  7. Re: ActiveX ComboBox dynamic range for ListFillRange

    SOLVED! I have used empty cells ""

    and this code


    Private Sub Worksheet_Change(ByVal Target As Range)


    'If Target.Address = Range("E216").Address Then
    ...
  8. [RESOLVED] ActiveX ComboBox dynamic range for ListFillRange

    I have `ThisWorkbook.Sheets("MAIN")` and ActiveX `ComboBox11` on it. I also have table:



    A B
    1 John 1 10000
    2 John 2 ...
  9. Replies
    12
    Views
    554

    Re: Save userform as .xlsx on users desktop

    We have file system (M - F i l e s) and files are stored actually in there. However once you open some file Word, Excel etc. it opens on your computer as usual and the code is running on your...
  10. Replies
    12
    Views
    554

    Re: Save userform as .xlsx on users desktop

    I don't know whats the problem... I think also it should work but it isn't. We have file system and once I am running Excel on my Desktop it seems to work, but from file system it doesn't. However...
  11. Replies
    12
    Views
    554

    Re: Save userform as .xlsx on users desktop

    If I understand correct, I have edited code like this now:



    Private Sub CommandButton5_Click()
    Application.ScreenUpdating = False

    Dim NewBook As Workbook
    Set NewBook =...
  12. Replies
    12
    Views
    554

    Re: Save userform as .xlsx on users desktop

    Just tried:


    Private Sub CommandButton5_Click()
    Application.ScreenUpdating = False


    Dim NewBook As Workbook
    Dim newWB As Worksheet
  13. Replies
    12
    Views
    554

    Re: Save userform as .xlsx on users desktop

    I probably had to mention that I have two buttons: one for saving userform to PDF and another one for saving to XLSX. PDF works fine, I just wanted to add XLSX possibility, but can't get it work. I...
  14. Replies
    12
    Views
    554

    Save userform as .xlsx on users desktop

    I would like to save userform as an image inside .xlsx file. I have button in userform to save as .xlsx. So my code should take a screenshot, create new Excel file, paste screenshot in there and save...
  15. Re: Excel VBA conditional insert of page breaks

    Great! Thanks again! :thumb:

    What do you think by the way about PrintVersion.Activate. Is it proper way or not? I have learned now that at least .Select should be avoided.
  16. Re: Excel VBA conditional insert of page breaks

    Here is updated file that saves pdf to same folder as xlsm. Code is working here:

    https://drive.google.com/file/d/1e3HUpy3kzscPCUDI1Uk90p3-sinIIOSF/view?usp=sharing


    I am talking about this...
  17. Re: Excel VBA conditional insert of page breaks

    Actually this seems to work. The only thing I would like to tweak is language section in the end. Current page break code does not recognize it.

    P.S. Current code saves file to %temp% folder.

    ...
  18. Re: Excel VBA conditional insert of page breaks

    I have code for automatically inserting Page Breaks depending on sections in Column C. Also I do not know how to avoid Activate in my code.

    My sections are in 4 rows.

    165997

    Here is the...
  19. Re: Excel VBA conditional insert of page breaks

    Hello westconn1 again,

    I have made some tweaks to file and now for some reason code is not working. I have moved texts from column B to column C. After that I have edited part of the code to...
  20. Re: Combining two VBA codes for embedded Word documents into one

    I just tested macro on my personal computer and everything works fine for running separate code several times. However one button click for Call template1SaveToWord and Call template2SaveToWord works...
  21. Re: Combining two VBA codes for embedded Word documents into one

    Here is an example of my workbook.

    165409

    If you run first one, then close Excel, then open it again and run the second one everything works great. However you are not able to run both without...
  22. [RESOLVED] Combining two VBA codes for embedded Word documents into one

    I came across the problem with combining two similar codes in one task. The code running into an error after the first code is done and debugger points to
    sh.OLEFormat.Activate. I have tried to...
  23. Re: Export data from Excel to Word step by step with specific formatting (loop)

    The problem has been solved!
  24. Re: Export data from Excel to Word step by step with specific formatting (loop)

    Hello my old professional supporter in world of VBA code! :)
    I have chosen completely different strategy for now. After some investigations it seems to be much easier to create a Word template with...
  25. [RESOLVED] Export data from Excel to Word step by step with specific formatting (loop)

    I have code guidelines in my Worksheet Column C. They are title (Heading 1), main (number starting from 1 and Heading 2 | Output "1. Terms of condition"), sub (number starting from 1.1 and Heading...
  26. Re: Excel VBA Center header/footer “Align Left”

    For me it doesn't really matter what type to use as it would just do what I need.

    - I have tried with image. Code is taking a screenshot of cells and inserts an image into center header but then...
  27. Re: Excel VBA Center header/footer “Align Left”

    This would be easy solution if I would have the same text in my header all the time. The problem is that I use =VLOOKUP function to look for translations of text on another Sheet. I have drop down to...
  28. Re: Excel VBA Center header/footer “Align Left”

    Thanks again for your effort. I saw this one already but it looks like &L is sending text to the left header. I was thinking maybe my text is on the left as it is on top of the "Left header" and by...
  29. [RESOLVED] Excel VBA Center header/footer “Align Left”

    Is there any way to align Center Header in Excel? I know there is no any built in solution but is there any VBA code that would work. I have been trying copying cells to header, setting center header...
  30. Excel VBA copy range from Excel and paste it to Word header Text Box

    I have Excel Workbook from where I am running following code below. I have logo and page numbering already in Word document so I do not need to paste the whole range from Excel. I have two Text Boxes...
  31. Re: Excel VBA Macro for automated paragraph numbering

    I have got this one from another forum. If somebody needs the same, here is the code:


    Sub Addlevels()
    Dim m As Long, s As Long, ss As Long
    Dim Cl As Range

    For Each Cl In...
  32. [RESOLVED] Excel VBA speed up code to hide rows/delete color

    I am using following code to delete color and hide rows that include several criteria before exporting sheets to pdf's. Is there any way to speed up this process as it is taking quite a lot of time...
  33. Excel VBA Macro for automated paragraph numbering

    Can somebody help with macro for automated paragraph numbering in my document?

    In column "A" I need to have paragraph numbers. I have three different types of numbering. They are "1", "1.1" and...
  34. Re: Excel VBA real time UserForm Labels from Workbook cells

    Thanks to everyone. I came up with this solution.


    Private Sub Worksheet_Calculate()
    Dim KeyCell1 As Range
    Dim KeyCell2 As Range
    ' The variable KeyCells contains the cells that...
  35. [RESOLVED] Excel VBA real time UserForm Labels from Workbook cells

    I have userform called "DisplaySummaryForm" that meant to display live information about project being calculated. I have Labels to display values from worksheet cells. Now I have to reopen UserForm...
  36. Re: Excel VBA conditional insert of page breaks

    I have already started to think it is impossible to achieve and then you posted your code. You are true genius!
    Thanks to everyone for their effort! Quoted code worked for me with no problem!...
  37. Re: Excel VBA conditional insert of page breaks

    Thank you very much! I was testing this code for some time with no success. Now I thought that maybe the problem is that I am in Europe and we use cm instead of inches here? One cell is 0,51 cm at...
  38. Re: Excel VBA conditional insert of page breaks

    Thank you for your effort! I have been testing your code with no success. For some reason your code does not do anything. Is it possible to upload file with working code, maybe I can get it working...
  39. Re: Excel VBA conditional insert of page breaks

    You can download file here: https://files.fm/u/78q4zy6w

    Problem is that paragraphs are not every 10th or 15th or 18th row. There are can be different amount of paragraphs and rows in each...
  40. [RESOLVED] Excel VBA conditional insert of page breaks

    I have a form that is changing all the time according to my "Filling form" where user is filling in information. Then I have "Print version" sheet for autoformatting and printing to .pdf/.xls. In...
Results 1 to 40 of 40



Featured


Click Here to Expand Forum to Full Width