Search:

Type: Posts; User: diddi; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    3
    Views
    139

    Re: Append to pdf VBA

    thx for that. i did try PDFsam but could not get the shell script to work, so hopefully i can use your link but better success.
  2. Replies
    3
    Views
    139

    Append to pdf VBA

    Morning all.
    I am hoping to find advice for a Shell( ) or other method to add sheets to a pdf file.
    I have tried several pdf generators / merging programs that support command line, but cannot get...
  3. Re: Massive problem: Excel has found unreadable content.

    Try exporting your userforms and saving your modules and class modules into text files. then you can restore the "repaired" version. i had an excel crash event recently on a perfectly good userform...
  4. Replies
    2
    Views
    190

    Re: Getting elements of a Type declaration

    i want to write a generic Random File reader/dumper
    So i can call the function or sub to read entire files.

    eg
    GetRandomFile MyFileName, Invoice
    would call a sub which loads MyFileName and...
  5. Replies
    2
    Views
    190

    Getting elements of a Type declaration

    hi I was wondering if it is possible to determine the elements within a declared Type. so as an example, I have a variable "Invoice" as declared


    Type Invoice
    Job As Integer
    ...
  6. Re: How to create a list of all possible combinations

    i am thinking there are 3^8 combinations here. or am i not seeing the problem correctly
  7. Replies
    3
    Views
    225

    Re: I need to creat a Print Button

    hi and welcome to your first question post.

    i would consider making your own userform that only offers the options you want available and then print without showing the print dialog box. i dont...
  8. Re: i used all the letters for CNTRL+SHIFT+letter how to write more macros?

    create a userform menu with commandbuttons that allow the user to chooses a task
  9. Replies
    1
    Views
    167

    Re: Setting Global Variables

    these 2 lines need to be declared outside the sub but in the same module
    Dim finalRow_Paste As Integer
    Dim finalRow_2Wks_Trades As Integer

    variables are not shared between subs unless they are...
  10. Re: Auto Print Button with auto hide and unhide vba

    hi and welcome to the forum.

    not knowing your code, i can suggest you look at the .RowHeight property.

    eg MySheet.Rows(5).Rowheight = 0 will set that row to 0 height

    eg


    If...
  11. Re: Import Userform Image dependant on Textbox input

    keep a library of images in a folder and load them up as needed. smaller file and prolly quicker.
  12. Replies
    1
    Views
    300

    Re: VBA sub to launch external app/program

    this may help
    http://www.cpearson.com/excel/ShellAndWait.aspx
  13. Replies
    1
    Views
    242

    Re: How to select specific CheckBox's?

    try this...



    for row = 18 to 48
    Controls("Checkbox" & row).value = true
    next row
  14. Replies
    6
    Views
    23,312

    Re: VBA to save Userform as PDF

    i use the default printer method which works well as long as you dont need to print in landscape as there is no printpreview control. i use bullzip as my pdf printer which supports vba and is free.
  15. Re: Creating a txt file from excel with 1000 characters

    i suggest you look into random access file handling
  16. Thread: ie automation

    by diddi
    Replies
    0
    Views
    218

    ie automation

    hi all. i have an ie automation issue. the code (bottom) works fine. my problem is that there are multiple pages. it is possible to display all pages however by automating this portion of html:
    ...
  17. Replies
    0
    Views
    110

    Reading a font file

    greets all.
    I am looking at retrieving some of the specs about a font which are stored within the file such as the font family name, copyright owner etc. My problem is that I cannot find a way of...
  18. Re: Display Image in userform listbox classModule

    can you post your userform code please
  19. Thread: Web interaction

    by diddi
    Replies
    9
    Views
    319

    Re: Web interaction

    http://www.jpsoftwaretech.com/excel-vba/automate-internet-explorer/
  20. Re: Updating userform textboxes after reading from a barcode scanner

    if you only want the barcode box to work for text entry, set the property TabStop = False for all the other controls
  21. Replies
    4
    Views
    1,820

    Re: Organize Music Library in Excel?!?!?!

    there is a free program called MP3tag which can export ID3 tags from entire volumes and nested folders. try that :)
  22. Replies
    4
    Views
    1,820

    Re: Organize Music Library in Excel?!?!?!

    do some googling about ID3 tags
    I think I asked about this about 6 years ago...
  23. Replies
    1
    Views
    203

    Re: Spin button problem

    "selection" is not a variable used with spinbuttons, nor is it the name of a control.
    you seem to be setting properties of the control here rather than using it to branch your code?
  24. Re: redim preserve matrix doesnt work (the preserve part)

    you are missing the Preserve keyword
  25. Re: macro closes active workbook but other workbooks wont close

    try using

    Application.Quit
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4