Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-03-17 Thread Vaibhav Joshi
Try this macro: https://sites.google.com/site/thexlwiz/files/SaveDBF.zip?attredirects=0 On Tue, Mar 17, 2015 at 12:22 PM, Pravin Gunjal wrote: > Hello, > Can anyone help me to modify & save DBF files in Excel 2007. > > Pravin. > > > On Saturday, March 14, 2015 at 1:01:39 PM UTC+5:30, Pravin G

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-03-16 Thread Pravin Gunjal
Hello, Can anyone help me to modify & save DBF files in Excel 2007. Pravin. On Saturday, March 14, 2015 at 1:01:39 PM UTC+5:30, Pravin Gunjal wrote: > > Hi, > > I tried working on it but could not do the same. > > Could you please explain me how to do it or is there any other solution > for th

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-03-14 Thread Pravin Gunjal
Hi, I tried working on it but could not do the same. Could you please explain me how to do it or is there any other solution for this. Please do share. Thank you Regards Pravin Gunjal On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote: > > That usually is a problem

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-03-02 Thread Pravin Gunjal
Hi Vabs Any updates on this please. Regards Pravin Gunjal On Wednesday, February 11, 2015 at 5:00:32 PM UTC+5:30, Pravin Gunjal wrote: > > Hi Vabs > > Following is the code: > > Function savedbf() As Boolean > Dim filename As Variant > Dim temp As Variant > Dim currentFile As String >

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-02-11 Thread Pravin Gunjal
Hi Vabs Following is the code: Function savedbf() As Boolean Dim filename As Variant Dim temp As Variant Dim currentFile As String Dim defaultFile As String currentFile = ActiveWorkbook.Name temp = Split(currentFile, ".") temp(UBound(temp)) = "dbf" defaultFile = J

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-02-07 Thread Vaibhav Joshi
Hi pl send code to test on, also what is your MS office version? On Thu, Feb 5, 2015 at 2:07 PM, Pravin Gunjal wrote: > Hi > > I tried this one and un-ticked MISSING from libraries and tried to Save As > the file with existing. > Then it says: The file is already exists. Do you want to replace

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-02-05 Thread Pravin Gunjal
Hi I tried this one and un-ticked MISSING from libraries and tried to Save As the file with existing. Then it says: The file is already exists. Do you want to replace with existing file? When I click on Yes it again says: Unable to remove existing file.. Kindly look in to this please. Than

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-02-03 Thread Vaibhav Joshi
Yes agree with paul On Feb 3, 2015 9:45 PM, "Paul Schreiner" wrote: > That usually is a problem with "References". > > try these steps: > > Stop execution of macro > in VB Editor, select Tools-> References... > > you'll find several libraries selected. > But you might see one that says "Missi

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-02-03 Thread Paul Schreiner
That usually is a problem with "References". try these steps: Stop execution of macro in VB Editor, select Tools-> References... you'll find several libraries selected. But you might see one that says "Missing" (or something like that). The problem is that once the compiler hits this missin

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-02-03 Thread Vaibhav Joshi
Try replacing Left with Left$ On Tue, Feb 3, 2015 at 7:03 PM, Pravin Gunjal wrote: > Hi > > I have downloaded the DBF save add-in but while saving got the attached > error in VB. > Could anyone please check and update me on this issue. > > Thank you > Pravin Gunjal > > -- > Are you =EXP(E:RT) or