Search:
Type: Posts; User: afc17
Search:
Search took 0.02 seconds.
-
That worked great, thank you
-
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...
-
I get a runtime error 1004
Method "SaveAs' of object'_Workbook' failed
-
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
-
Sub SaveInvoice1()
'Creates New Folder Shipments.
Dim FSO
Dim sFolder As String
Dim strFilename As String
Dim Ref
Ref = Sheets("INVOICE").Range("Q3").Value
-
I have tried it in afew different positions in the coding but everytime I get the same message that a file already exists?
-
Where about do I need to put that code mate? I keep getting a message saying that that file already exists?
-
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...
-
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...
-
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 & "\" &...
-
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...
|
Click Here to Expand Forum to Full Width
|