Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    205

    Re: VBA to open a PDF in another location.

    333 New Store.... works great with my original code, but really we have always used a 4 digit code as some stores are named as 9453 for example. People complete an excel spreadsheet and click a...
  2. Replies
    6
    Views
    205

    Re: VBA to open a PDF in another location.

    Just tried it, doesn't seem to work.

    Sub OpenPDF_3()


    Dim strPath As String
    Dim strFileName As String

    strPath = "\\172.27.154.13\D$\Excel Dashboard\Inventory"
    If...
  3. Replies
    6
    Views
    205

    Re: VBA to open a PDF in another location.

    Hi

    Thanks for quick response. Would this work if there was more than 1 zero, ie 0023?
  4. Replies
    6
    Views
    205

    VBA to open a PDF in another location.

    Hi All

    I have the following code that searches a network folder for a PDF doc based on the number in a cell and opens it if one exists:

    Sub OpenPDF_3()

    Dim strPath As String
    Dim...
  5. Replies
    1
    Views
    81

    Moving ToggleButtons

    Any ideas how to stop toggle buttons from moving every time i open my spreadsheet. I have a few of them. I have grouped them, set them to don't move or resize but they still do it.

    Many Thanks
  6. Replies
    12
    Views
    328

    Re: Multiple Toggle Buttons VBA Code

    I like this option. Can you specify a cell range for this, as when I tried it (slightly different code) it worked on every cell in the worksheet instead of just the cells I wanted. Also, can you...
  7. Replies
    12
    Views
    328

    Re: Multiple Toggle Buttons VBA Code

    Works a treat now I have it in the right place.

    Many thanks
  8. Replies
    12
    Views
    328

    Re: Multiple Toggle Buttons VBA Code

    Mick

    This looks a great option, however, I copied and pasted the code but it doesn't work.

    Regards
  9. Replies
    12
    Views
    328

    Re: Multiple Toggle Buttons VBA Code

    Hi

    Sounds good. Can you specify a range of cells that this applies to? I tried the below code I found and it works ok but on the whole worksheet.

    Am new to this so thanks for your patience....
  10. Replies
    12
    Views
    328

    Re: Multiple Toggle Buttons VBA Code

    Hi

    Clean House in Range("A1")
    Clean Garage in Range("A2")
    Cook Mr. Excel a Cake in Range("A3")

    Can you double click to turn green and add text, ie, No, Yes? Is this done through conditional...
  11. Replies
    12
    Views
    328

    Multiple Toggle Buttons VBA Code

    Hi All

    I have a spreadsheet with a row of Toggle Buttons. The toggle buttons are to indicate if a task has been completed. When clicking the button it says 'YES' and using conditional...
  12. Replies
    1
    Views
    186

    Dashboard Macro Automation

    Hi All
    I have created a dashboard using excel. I will be displaying the dashboard on anoffice TV. I have around 5 differentworksheets on the dashboard and I want to switch between the...
  13. Replies
    12
    Views
    439

    Re: Open a PDF doc from Excel dash board

    Hi Again

    I got an email saying you had responded to my last question but I can't see anything.
  14. Replies
    12
    Views
    439

    Re: Open a PDF doc from Excel dash board

    Hi Domenic

    I have another question regarding a formula. I have a job schedule and I have (with help)constructed a way of filtering a persons initials to just show the jobs he isdoing. But...
  15. Replies
    12
    Views
    439

    Re: Open a PDF doc from Excel dash board

    Hi Domenic

    Many thanks for your quick response.

    I've looked at the code and I did have the back slashes in place. I can't understand why they disappeared when I copied the code in here? Here's...
  16. Replies
    12
    Views
    439

    Re: Open a PDF doc from Excel dash board

    Hi Domenic

    May thanks for taking the time to help. I have done as advised but on clicking the button, am getting the error "File Not Found" . I tried both methods on different sheets. See code...
  17. Replies
    12
    Views
    439

    Re: Open a PDF doc from Excel dash board

    Hi

    Many thanks for taking the time to reply. Another dumb question before I start, wheredo I put this code? I created an activex button but when I opened it I got this:
    Private Sub...
  18. Replies
    12
    Views
    439

    Open a PDF doc from Excel dash board

    Hi All

    Note to self, write your post in word and then copy to thiswindow, as I have now written the post 3 times, only for the window to crashand reopen without my text L.

    Now to my...
Results 1 to 18 of 18