rngdestination

Hi dear, I am still learning about hyperlinks (with shape). I have vba code in module to move from one sheet to another, like this Sub HomeButton() Dim wb As Workbook: Set wb = ThisWorkbook Dim rngReference As Worksheet Dim rngDestination As Worksheet Dim shpHyperlink As Shape...

Hi all. My friend wrote me a macro to export data in templates to PDFs. Simple enough task, but neither of us can get it to work on my Mac. Is it possible to do so? Code below. Thanks in advance! Sub GetDataGenerateInvoices() Dim DealerCounter As Integer Dim DealerCodePos As Integer...

Hi Everyone, I have the macro below on a button in a worksheet and I want it to open "C:\Users\HOME\Dropbox\DSR DAILY IMPORT" so we can select a file which it does BUT it also opens "My Documents" folder as well? I'm not seeing why that is happening? Thank you! ​Sub Macro1()<code...

Hi Everyone, I have the following macro which works well except for one issue. It will import a selected file to whichever sheet is open at the time and I need to edit it where it imports to a sheet titled "POS IMPORT" whether its open or not. Thanks in advance!! Sub...

I have a macro below that opens a workbook and copies the data. However the fields in the import data changes from time to time i.e. extra fields are added I need my code altered so that only columns containing the following headings in row 1 are copied Stock Number Order Number...

Hello! Currently my spreadsheet uses the following code, which I just found off another site. It's great but I need to advance it a bit and don't know how. I would like to be able to select the document but have it automatically import a specific range (which always remains the same) within...

Hey guys, stuck with this one. Found this code online: <code class="vb keyword">Sub</code> <code class="vb plain">ImportDatafromotherworksheet()</code> <code class="vb spaces"> </code><code class="vb keyword">Dim</code> <code class="vb plain">wkbCrntWorkBook </code><code class="vb...