VBA to JavaScript conversion for sheet

83 views
Skip to first unread message

Mr. Adrien

unread,
Nov 22, 2022, 8:49:54 AM11/22/22
to Google Apps Script Community
Hi, I'm new to the forum and really need help! I would like to convert two little VBA code from my Excel file to my new GoogleSheet file and I'm really lost in the Java code language. Does anyone have the ability to convert both VBAs for me. Here are the two codes.

1-
Sub MacroSauv() 
MacroSauv Macro 

Range("A1:K53").Select 
Range("K1").Activate 
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _ "Demande d'inscription et de réinscription." & Range("N7") _ , Quality:=xlQualityMinimum, IncludeDocProperties:=True, IgnorePrintAreas _ :=False, OpenAfterPublish:=False 

End Sub

2-
Sub MacroCE1() 
MacroCE1 Macro 
Sheets("2APG").Select 

 Application.ScreenUpdating = False 
DL = 1 + Range("B65500").End(xlUp).Row 
Cells(DL, "B").FormulaLocal = "=Formulaire!C9" 
Cells(DL, "C").FormulaLocal = "=Formulaire!H9" 
Cells(DL, "D").FormulaLocal = "=Formulaire!I15" 
 Range("B" & DL & ":D" & DL) = Range("B" & DL & ":D" & DL).Value   

End Sub
Reply all
Reply to author
Forward
0 new messages