VBA code

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

how to set the value of a variable?

example:

Dim FiletoPrint As String

And then I want to assign a value to FiletoPrint

What's the syntax in VBA?

FiletoPrint:= "S:\66103\04TILL\file1" ?

thanks,

Mary
 
Just and equal sign, no colon. The syntax := is used only with named arguments
in procedure calls.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Word Documents From Access 4
vba code help for multiple string searching 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Extensions 2
I need help with this program written in Visual Basic for Excel 2007. 4
Access 2007,reports,VBA 2
Example Of VBA SQL Statement 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top