strfilename

  1. V

    Array Overflow Errow

    Sub Searching() Dim FilePath As String Dim strFilename As String: strFilename = "C:\Users\Jack\Desktop\test.txt" Dim strTextLine As String Dim iFile As Integer: iFile = FreeFile Dim income_a(10) As Integer, i As Integer i = 0 Open strFilename For Input As #iFile Do Until EOF(1) Line Input...
  2. A

    macro to disconnect data connections when copying a sheet from master to standalone wrkbk

    Hi there, I have a code for creating a separate worksheet for any active sheet out of a master workbook that has data connections in it. now i am looking for a way to insert macro code that can: make sure this new workbook being created is matching the original format disconnecting all the...
  3. A

    vba to copy certain sheet and make copy of it as a stand alone workbook

    Hi there, i am trying to create a workbook out of a specific sheet (the name and location changes every time- based on need) from a different workbook. And this is how far i got with my code that gets stuck at line 16 Sub Button1_Click() Dim ws As Worksheet Dim wbNew As Workbook...
  4. 3

    VBA Macro to Convert Word Docs to PDF with Looping through Subfolders?

    I am trying to adapt the below VBA code, which converts all Word documents in a given folder into PDFs, in order to also do the same to all other Words documents found in all subfolders cascading downwards from the original folder: <code style="margin: 0px; padding: 0px; border: 0px...
  5. T

    Using VB to print and save one worksheet from another as a PDF with the file name based on a cell value

    I am using an ActiveX button to execute the printing of one sheet from another, this is working. But I am also am trying to save the second sheet as a PDF based on a cell value in the first worksheet, in the same code. Here is the code: Private Sub CommandButton1_Click() 'Print only "Cal...
  6. I

    Alert message for duplication of a file

    Morning, I have the following supplied code which i run after i have printed an invoice. It saves a word invoice to the folder mentioned & informs me with a message box once done. Could you advise a edit where it will only allow the save to go ahead if that invoice number does not exist. I mean...
  7. I

    One code updates two worksheets

    Morning, I have the following supplied code which works fine. The worksheet that this code is on is named INVOICE. I have copied this worksheet & named it INVOICE 2 What i would like to do is after the current invoice number has incremented by 1 on INVOICE 1 have the same happen for INVOICE 2...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top