Posts by ady171

Hi all,

I have a spreadsheet which pulls data from Sage. There are two columns added on the spreadsheet which the user picks items, the and Department it is for.

The issue I have is that if something gets added or removed from Sage and then the databases is updated, the quantity and department are no longer assigned to picked product row.

Is there a way to keep these assigned to the selected row?

e.g of what is looks like..

Thanks guys

Hi guys,

I am trying to run this code but keep getting syntax error..

Sub UpdateFormula()
Range("K2").Formula = "=IF(ISNUMBER(MATCH(I2,'C1'!$I$2:I$66,0)),"","Not Found")"
End Sub

any ideas?

Thank you

Re: Importing currency to word doc?

Spot on Kenneth! :party: 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 value and is there anyway to import it as its in excel in currency?

Sub Contents()
Dim objWord As Object
Dim ws As Worksheet




    Set ws = ThisWorkbook.Sheets("SER_INC_INVOICE")




    Set objWord = CreateObject("Word.Application")




    objWord.Visible = True




    objWord.Documents.Open "O:\Despatch\Customs\CUSTOMS INVOICES\CONTENTS II.doc"
    
    With objWord.ActiveDocument
        .Bookmarks("Date").Range.Text = ws.Range("M3").Value
        .Bookmarks("Value2").Range.Text = ws.Range("N5").Value = "$ #,##0.00_)"
    End With
 
    objWord.PrintOut




    Application.Wait Time + TimeValue("00:00:03")




    objWord.Quit SaveChanges:=wdDoNotSaveChanges




    Set objWord = Nothing




End Sub

How do I get it to import exactly as the value in N5 cell?

I tried this with paste-special as link in Word but since the word doc is used with another excel file also it would have two values.

Thanks guys