should also work
Type: Posts; User: westconn1
should also work
probably something like
*.mdb, or a partially qualified database filename
i would believe, that as parts of filesearch no longer worked with the new file formats introduced in 2007, it was discontinued
edit: disclaimer and qualification
while vba userforms have an event
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
'code here will run if form tries to close
i do not know if access forms...
you can try like
If Not Err.Number = 0 Then
Application.OnTime Now + TimeSerial(0, 1, 0), "webpull"
Call Macro152 'Transfers record sheet
what are some values in sheet (aa7:ac7) for url?
no i can only open early version (.xls) anyway need to see what code you are using, so need the macros to be included
SaveAs excel 2003 or earlier
as i know nothing about macs, i will pass here
from experience shared drives in vmware virtual machines, look like shared drives in real machines, where as virtualbox was a problem in this area
is this different from your other thread?
as i can not open .xlsm, only .xls, i can not look at your workbook
perhaps you can use application.ontime to create a delay, between calls to the web...
no, you can try like
Printer.Orientation = vbPRORLandscape
Me.WindowState = vbMaximized
have you tried?
search the forum
this not the correct forum for vb.net, any code suggested here is likely not to work for you
as the example specifies how it is to be done, it would be hard to duplicate in vb6
this will thread...
see if this works correctly for you
Private Sub Text1_GotFocus()
s = Text1.SelStart
num = CDbl(Left(Text1.Text, s))
Text1.Text = Format(Text1.Text, "General Number")
Text1.SelStart = Len(num)...
explorer, network places, or map network drive
should not be required and is bad practice to share root
network a couple of machines?
this should be quicker
varArrayData = range("b191").resize(30,61)
Range("A1").End(xlDown).Offset(1,0).resize(30, 61).value = varArrayData NOTE in both cases the range needs to be fully qualified...
i have barely looked, but not all the required code is here
no procedure logintosalesforce
you need to find and download the file SF_MSApi3.dll...
rw = 3
For x = 3 To numRecs + 1
If (x - 3) Mod 12 = 0 Then rw = rw + 1
.Cells(rw, 1).Value = Format(rsHPData!EffectiveMonth, "mmmm-yyyy")
will look later or at the weekend
i have tested this code, it will exit from the do loop correctly replace the original content of my for loop with
Set firstfnd = s.Range("a1")
Set fnd = s.Cells(Rows.Count, 5).End(xlUp).Offset(1)...
for ws = 2 to thisworkbook.sheets.count
set fnd = thisworkbook.sheets(ws).cells(rows.count, 5).end(xlup)
set fnd =...
see the tutorial for automating office applications in the faq thread at the top of this forum
where is n defined in a module or in the userform?
is the code posted above in the userform module or a standard module?
do you have option explicit at the top of all your modules?
the above link is not directly related to what you want to achieve, but from memory, it does show how to capture any window to a...
this seems like doubling up as s is already a typecast shape, why cast again to shp
while i am not sure of exact syntax
set newshp =...
set the new dropdown to an object variable when adding, you can the change the name of object to some meaningful value, relaed to the row or whatever, you can then access later by name
what code have you tried so far?
afaik firefox is only a browser, not an email client, while webmail can be read and composed within any browser i am surprised that shell execute can manage using firefox
i found a previous post, jul 1 2010
i am reasonably sure i tested this at the time, change the filepath\name to suit, just add after body, this was the format for outlook express, there may be...
build a web page to navigate2 seems the simplest
if you just navigate to the .jpg you can not position, but a link in a web page can be positioned (and sized) to suit
you can add attachments using this method, but i can not remember the trick to it, though i know i have posted it before, i will try a search for it and if successful will append to this post
not really, just difficult to understand how it is set up
you have not specified which application you are working in, i would guess excel, but it could be a word table
do you want the user to...
i saw the file added to the folder
probably not, strformurl should have a value, as it has not been passed to the procedure some other code must be wrong
yes it does, but you would need to use...
the monthly folder name could be automated, based on the current month and when the year start changes
i made some small change to your code, to test on my website with hardcoded file from local computer
i pm you my url so you can test
i have now put msgbox for return status
menu > tools > references, find winhttp and check
as instruction, add reference to winhttp
i had to learn it to write it, the code in the module should be ok, unless your upload server has special requirements, you will need to change the file...