Posts by DCFeather

    I didn't see a need for debugging because my code works. I just didn't quite understand how. However I will be using the watch window more often like I did 10 years ago when I was writing VB6 code using Access databases for a company called Wincare.


    And thanks for reminder about code tags.


    The link to bettersolutions.com is awesome. It basically confirmed what I had already figured out on my own along with filling in some additional blanks. I will be referring to it often.


    I appreciate your response, and I got a good laugh from your GIF.

    Code
    Range("X11").Select
    ActiveCell.FormulaR1C1 = "='" & strMon(ii) & strYear & "'" & "!RC"


    !RC is used in the above code example. I needed to use it in order to append "X11" to the end of the string. Simply putting X11 in quotes didn't work. This example is embedded within code that causes X11 in each sheet to refer to the X11 cell in the previous sheet.


    I've seen other examples of using !RC that look like the following: !R[4]C and !R24C20. However I cannot find an explanation for its usage or meaning anywhere. I need to know how flexible its usage is and what syntax is involved.


    Thanks
    Dennis

    Alright never mind I figured it out! Unix is at the core of apples new systems. They use forward slashes instead of backslashes in the path strings. So the second line of VB code in my first post was close to correct. All I had to do is remove the volume name (Yosemity) and begin the path string with a forward slash. Not to mention the fact that I misspelled Yosemite. This works:


    Workbooks.Open ("/Users/dcfeatheradm/Documents/Budget Spreadsheets/2014/Budget_2014.xlsm")

    I'm using office 2016 for Macintosh. Trying to open a workbook from 2014 using VBA. Here is the line of code:


    Workbooks.Open ("C:\Users\dcfeatheradm\Documents\Budget Spreadsheets\2014\Budget_2014.xlsm")


    I have also tried this:


    Workbooks.Open ("Yosemity/Users/dcfeatheradm/Documents/Budget Spreadsheets/2014/Budget_2014.xlsm")


    I keep getting a message indicating that VBA can't find it. This is the right path and filename, however I'm not sure about the usage of the "C:" or the space " " in the directory "Budget Spreadsheets" on the Macintosh.


    I appreciate any help anybody can offer.


    Thank you


    Dennis