Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox Useage
Hello again,
Run into a bit of a snag There was some code in place in the excel project I am working on....... chdrive ("C") chdir Curdir msgbox "current working directory is ", CurDir Now when I try run this macro (excel spreadsheet saved as excel 5.0/95, but opened and edited in excel 2000, then saved back to 5.0) I get an error...HELP!!! lol It USED to work The msgbox is a requirment of the project, to come up and tell the user which directory their files are in I need to get the msgbox working again using the curdir (currentdirectory) Thanks in advance Jeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox Useage
"Jeff" wrote in message
... Hello again, Run into a bit of a snag There was some code in place in the excel project I am working on....... chdrive ("C") chdir Curdir msgbox "current working directory is ", CurDir Now when I try run this macro (excel spreadsheet saved as excel 5.0/95, but opened and edited in excel 2000, then saved back to 5.0) I get an error...HELP!!! lol It USED to work The msgbox is a requirment of the project, to come up and tell the user which directory their files are in I need to get the msgbox working again using the curdir (currentdirectory) Thanks in advance Jeff Hi Jeff, Just replace the komma with an ampersand (&) like this: msgbox "current working directory is " & CurDir Glenner003 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox Useage
You don't need chdir Curdir
That does nothing. chdrive ("C") msgbox "current working directory is " & CurDir -- Regards, Tom Ogilvy "glenner003" wrote in message .be... "Jeff" wrote in message ... Hello again, Run into a bit of a snag There was some code in place in the excel project I am working on....... chdrive ("C") chdir Curdir msgbox "current working directory is ", CurDir Now when I try run this macro (excel spreadsheet saved as excel 5.0/95, but opened and edited in excel 2000, then saved back to 5.0) I get an error...HELP!!! lol It USED to work The msgbox is a requirment of the project, to come up and tell the user which directory their files are in I need to get the msgbox working again using the curdir (currentdirectory) Thanks in advance Jeff Hi Jeff, Just replace the komma with an ampersand (&) like this: msgbox "current working directory is " & CurDir Glenner003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - open work book useage agreement | Excel Worksheet Functions | |||
CPU useage at 100% on EXCEL.EXE | Excel Discussion (Misc queries) | |||
what is print to file in print dialogue box and its useage? | Excel Worksheet Functions | |||
IF Statement useage | Excel Discussion (Misc queries) | |||
MsgBox | Excel Discussion (Misc queries) |