Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all, I have code line (see below) in my macro
Const AN As String = "C:\My Documents\Pic\AN.jpg" I want to change this above line into the code line (see below) but I get error message with the below code line. Please can any friend can tell that what I am doing wrong. Const AN As String = Thisworkbook.path & "\AN.jpg" |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just declare it as variable
Dim AN As String An = Thisworkbook.path & "\AN.jpg" -- __________________________________ HTH Bob "K" wrote in message ... Hi all, I have code line (see below) in my macro Const AN As String = "C:\My Documents\Pic\AN.jpg" I want to change this above line into the code line (see below) but I get error message with the below code line. Please can any friend can tell that what I am doing wrong. Const AN As String = Thisworkbook.path & "\AN.jpg" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro code to put series name next to individual line in line grap | Charts and Charting in Excel | |||
Change A Line in A Module Using VBA Code | Excel Programming | |||
keep track of last code line before error | Excel Programming | |||
Change reference style in line of code | Excel Programming | |||
Way to change a single line of vb code in several hundred excel files? | Excel Programming |