Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA macros files mixed up
I had my macros ready to run and suddenly something happened... my file with
macros does not find the other file... I open one file using macros from another file but it say it does not exit... the file is there..... if I open the first file and from there open the second one then even if I close it it will recognize it as valid... I have notice some times I can see on the VBA editor that the lost file will be there twice... This is very desesperate for me... can somebody help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA macros files mixed up
Can you post the macro code. The answer depends on the methods you arre using. the code is probably looking in the default folder and not swtching to the folder you are expecting the data. Can you explain how you are seeing the files more than once? -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147811 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA macros files mixed up
I figure it out while sleeping last night.... it was kind of your
explanation... getting lost in the file path... got it fix already, thanks "joel" wrote: Can you post the macro code. The answer depends on the methods you arre using. the code is probably looking in the default folder and not swtching to the folder you are expecting the data. Can you explain how you are seeing the files more than once? -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147811 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving files with macros | New Users to Excel | |||
identifying files with macros | Excel Programming | |||
Macros and saving .csv files | Excel Discussion (Misc queries) | |||
Macros across multiple files | Excel Programming | |||
Do Macros cause corruption of big files | Excel Discussion (Misc queries) |