Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when running macro
Hi,
I have the following code that runs fine when the file is opened from my directory, however when opened from a file attached to an email, a code 9 error occurs. I think it's to do with the file name when opened from an email being ~7341470.xls (or similar) whereas it has a proper name when opened from a directory. Is there a way to overcome this, perhaps by checking whether the file has ~ in its name? Dim iFname As String Range("A1").Formula = _ "=VLOOKUP(D2,[" + iFname + "]Database,2,False)" Thanks, Rob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when running macro
difficult to guess, without knowing what's in iFname.
But did you include the exclamation point? And did you include the single quotes around the filename? And if the Database is in the same workbook, you could drop all that stuff that refers to another workbook. And VBA is very forgiving, but I'd use & to concatenate strings. + is usually used for adding numbers. Rob wrote: Hi, I have the following code that runs fine when the file is opened from my directory, however when opened from a file attached to an email, a code 9 error occurs. I think it's to do with the file name when opened from an email being ~7341470.xls (or similar) whereas it has a proper name when opened from a directory. Is there a way to overcome this, perhaps by checking whether the file has ~ in its name? Dim iFname As String Range("A1").Formula = _ "=VLOOKUP(D2,[" + iFname + "]Database,2,False)" Thanks, Rob -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when running macro
Thanks Dave, single quotes was the problem. Rob
"Dave Peterson" wrote in message ... difficult to guess, without knowing what's in iFname. But did you include the exclamation point? And did you include the single quotes around the filename? And if the Database is in the same workbook, you could drop all that stuff that refers to another workbook. And VBA is very forgiving, but I'd use & to concatenate strings. + is usually used for adding numbers. Rob wrote: Hi, I have the following code that runs fine when the file is opened from my directory, however when opened from a file attached to an email, a code 9 error occurs. I think it's to do with the file name when opened from an email being ~7341470.xls (or similar) whereas it has a proper name when opened from a directory. Is there a way to overcome this, perhaps by checking whether the file has ~ in its name? Dim iFname As String Range("A1").Formula = _ "=VLOOKUP(D2,[" + iFname + "]Database,2,False)" Thanks, Rob -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error 400 when running Macro | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Error Running a Macro | Excel Discussion (Misc queries) |