Dear Noorain SIr,
Please Help,
My Query ho to convert number to word
Please Help Sir,,
On Saturday, August 30, 2014 7:18:44 PM UTC+5:30, Ayush Jain wrote:
>
> Dear members,
>
> We’d like to invite members of the discussexcel.com community to the
> annual Excel and Financial Modeling Wo
Ur Welcome
P
On Fri, Sep 5, 2014 at 10:43 PM, Nagendra Joshi
wrote:
> Thanks Buddy,
>
> For your support.
>
>
> On Fri, Sep 5, 2014 at 8:46 AM, Pramod Singh wrote:
>
>> Hi Joshi,
>>
>>
>> PFA.
>>
>>
>> On Thu, Sep 4, 2014 at 10:20 PM,
That works great thank you :)
One more question if I have data in the sheet from column a to e how would
I get this to work with columns G:K starting at row 6
I tried but if the last row of info in column A is row 66 and I edit this
form to work for column G:K it inputs the info at G67 and not
Thanks Buddy,
For your support.
On Fri, Sep 5, 2014 at 8:46 AM, Pramod Singh wrote:
> Hi Joshi,
>
>
> PFA.
>
>
> On Thu, Sep 4, 2014 at 10:20 PM, Nagendra Joshi
> wrote:
>
>> Dear Team,
>>
>> Please find the enclosed file which contains many sheets but i need a
>>
I've done that with Sharepoint.
In my Library view, I can "open with Explorer" and it opens the folder.
However, it opens as:
http://blah/blah/blah
I was able to drop the http: and change the / to \
and end up with:
SP_path = "\\blah\blah\blah"
I then create a filesystem object and parse th
Its actually a sharepoint link. Its a database wherein anybody can save any
file and its openly available for viewing.
Its not a shared drive, however its in the folder format.
Regards
Jones
On 5 Sep 2014 19:56, "Paul Schreiner" wrote:
> You say: "office intranet"
>
> is that what you mean? as i
Thanks for the reply!
Trying to get it by:
activeworkbook.names("chk").value
I've not tested the results, but in the immediate window this shows promise:
? evaluate(activeworkbook.names("chk").value)
where the "chk" name is my UDF("input range) call.
I've got another issue I'm working on to
You're asking a question about VBA, so you've come to the right place!
You said"When I try to "get" the return in VBA, it ends up being the formula,
not the executed function's value."
that shouldn't happen.
How are you trying to "get" it?
For a given cell (D4):
If the cell is an excel formula
Are you saying you need to set NextRw to 6 if it's the first set?
if so, after
NextRw = .Cells(Rows.Count, 2) _
.End(xlUp).Offset(1, 0).Row
add:
If (NextRw < 6) then NextRw = 6
Paul
-
“Do all the good you can,
By all the means you can,
In all
Figure it out Paul that works very nice now I need to get it to start at
row 6 and go down from there.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RUL
Thanks Paul. let me try on that. thanks again
Regards,
Ganesh N
On Fri, Sep 5, 2014 at 7:38 PM, Paul Schreiner
wrote:
> That's a bit more involved.
> Have you ever used the filesystem object similar to:
>
>
> Const ForReading = 1, ForWriting = 2, ForAppending = 8
> Dim fs, f
> Set
Paul thank you for that. What in this would I need to change to match what
you put.
Set ws = Sheet1
lRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(2, 0).Row
as the IRow part changed. This part gives me the blank row between the sets
but unclear how to edit it to fix with your code.
--
You say: "office intranet"
is that what you mean? as in:
it's a link on a web site?
or is it actually on a network folder?
Actually, the link would actually BE pointing to a network folder.
If you can open the file location, then you'd be able to see what the network
path is to the file and u
I think you're pretty close.
consider:
the syntax for Cells() is Cells(row,column)
and for "column" you can use the letter (rather than the number)
So, your set should look like:
.Cells(NextRw + 0, "A").Value = Me.txtAssignmentName.Value
.Cells(NextRw + 1, "A").Value = Me.txtDa
Hi All,
I have a task at hand. Wherein i have files stored online on my office
intranet. And i need those files downloaded and merged as and when required.
For example, I have 10 folders and in each folders there are 2 files say A
and B, now whenever i need the data i have to download the files 1
That's a bit more involved.
Have you ever used the filesystem object similar to:
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Dim fs, f
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.OpenTextFile("c:\temp\testfile.txt", ForAppending, True)
f.Write
Hi folks, hope you don't mind the cross-posting, other group's read my
post twice and replied none where I originally put it on 9/3 and after
scanning the other recent postings it appears they don't seem to center on
the kind of issue I've asked about
.
.
.
I've got a function requiring a
Hi Paul,
Im fine with every thing but after saving the excel file to .txt it contain
some additional (") quotes (unwanted). can you please help me to avoid that
one ?
Thanks & Regards,
Ganesh N
On Fri, Sep 5, 2014 at 8:58 AM, Ganesh N wrote:
> Thanks Paul. Let me check on this.
>
> Regards,
>
excellent boss, well done
On Tue, Sep 2, 2014 at 6:30 AM, Anil Gawli wrote:
> Dear Hilary,
>
> Pl find below attached file for you ref.
>
> Warm Regards,
> Gawli Anil.
>
>
> On Mon, Sep 1, 2014 at 9:16 PM, Hilary Lomotey wrote:
>
>> Hello Experts
>>
>> Just found a temporal solution to my que
19 matches
Mail list logo