Excel Get current user name VBA help needed for script

Question

I have a Filemaker Pro runtime DB that exports reports to Excel then opens in PDF, there is no problems running this on my machine but.....when a customer loads it onto there machine the VBA code (Current Username) needs to change. One big hurdle for me is to be able to distribute the Excel forms with my solution and have Excel know the different User name. So below is part of my VBA, I need to be able to change the SEAQ(username) to the Current Username.....export to Location is documents, I don't need to change that part.

ActiveWorkbook.UpdateLink Name:= _
    "C:\Users\seaq\Desktop\LAB 17025\Forms\Particle Distribution\PD FM Exported.xlsx" _
    , Type:=xlExcelLinks

Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    "C:\Users\seaq\Desktop\LAB 17025\Forms\Particle Distribution\Particle Dist Customer Report.pdf" _
    , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
    :=False, OpenAfterPublish:=True

Environ("Username")

Tim Williams
– Tim Williams

2015-11-24 01:39:10 +00:00
Commented Nov 24, 2015 at 1:39 — Tim Williams
– Tim Williams, Commented Nov 24, 2015 at 1:39

Tim Williams · Accepted Answer · 2015-11-24 01:40:46Z

1

E.g.

ActiveWorkbook.UpdateLink Name:= _
   "C:\Users\" & Environ("Username") & _
   "\Desktop\LAB 17025\Forms\Particle Distribution\PD FM Exported.xlsx", _
   Type:=xlExcelLinks

answered Nov 24, 2015 at 1:40

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel Get current user name VBA help needed for script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related