Search:

Type: Posts; User: afc17

Search: Search took 0.02 seconds.

  1. Re: Using Word Bookmark to import to Excel? Currency problem

    That worked great, thank you
  2. Using Word Bookmark to import to Excel? Currency problem

    Hi all,

    I am trying to import a value from Excel to Word using the bookmarks in Word but cannot get it to import fully i.e. $1203.10 would import as 1203.1

    Why is it missing the zero off the...
  3. Replies
    10
    Views
    1,136

    Re: If file exists add a 1 on the end?

    I get a runtime error 1004

    Method "SaveAs' of object'_Workbook' failed
  4. Replies
    10
    Views
    1,136

    Re: If file exists add a 1 on the end?

    They both name the file name

    q3 = where I would put in the shipment ID i.e. ID123 (also the name of the created folder)

    ag5 = Customs Invoice
  5. Replies
    10
    Views
    1,136

    Re: If file exists add a 1 on the end?

    Sub SaveInvoice1()

    'Creates New Folder Shipments.

    Dim FSO
    Dim sFolder As String
    Dim strFilename As String
    Dim Ref

    Ref = Sheets("INVOICE").Range("Q3").Value
  6. Replies
    10
    Views
    1,136

    Re: If file exists add a 1 on the end?

    I have tried it in afew different positions in the coding but everytime I get the same message that a file already exists?
  7. Replies
    10
    Views
    1,136

    Re: If file exists add a 1 on the end?

    Where about do I need to put that code mate? I keep getting a message saying that that file already exists?
  8. Replies
    10
    Views
    1,136

    If file exists add a 1 on the end?

    Hi guys,

    I am using a macro button to create a folder and save the workbook into the folder, which is looking up at a two cells to name the folder and file. This is all fine and good, but if I...
  9. Re: [RESOLVED] VB: Making folder and saving workbook into that folder?

    Hi all,, following on from the aboce

    I have a macro to create a folder, name it from a certain cell and save the workbook to it. How can I get the folder to be named and read from another cell to...
  10. Re: VB: Making folder and saving workbook into that folder?

    Thanks, I needed to add another line so it would save in the folder created

    sFolder2 = "C:\Users\User\Documents\Shipments\2017\" & Sheets("Input").Range("T4").Value & "\" &...
  11. [RESOLVED] VB: Making folder and saving workbook into that folder?

    Hi all

    i am having some issues saving an Excel workbook after creating a folder, not sure how to save the workbook after the folder has been created :confused:

    At the moment I click save...
Results 1 to 11 of 11



Click Here to Expand Forum to Full Width